LFA1
LFA1 is a key SAP table in MM/FI. It stores general vendor (supplier) master data, the client-level attributes of a vendor common across purchasing organizations and company codes. (In S/4HANA, vendors are Business Partners, with LFA1 updated via CVI.)
LFA1 remains the general vendor table, but in S/4HANA you maintain vendors as Business Partners (supplier role), which update LFA1/LFM1/LFB1 behind the scenes.
- LIFNR, vendor number (key).
- NAME1, name; ORT01, city; LAND1, country.
- LFM1, vendor purchasing data.
- Watch out: Reading tables directly instead of using CDS/reports where appropriate.
What it stores
It stores general vendor (supplier) master data, the client-level attributes of a vendor common across purchasing organizations and company codes. (In S/4HANA, vendors are Business Partners, with LFA1 updated via CVI.)
Key fields
- LIFNR, vendor number (key).
- NAME1, name; ORT01, city; LAND1, country.
- KTOKK, account group.
- STCEG, VAT registration number.
Keys and relationships
LIFNR is the key. LFA1 holds general data; purchasing-org data is in LFM1, and company-code (accounting) data in LFB1. In S/4HANA these are maintained via the Business Partner and kept in sync by CVI.
Working with it
LFA1 remains the general vendor table, but in S/4HANA you maintain vendors as Business Partners (supplier role), which update LFA1/LFM1/LFB1 behind the scenes. View its structure in SE11 and its data (with authorization) in SE16N.
Common pitfalls
- Reading tables directly instead of using CDS/reports where appropriate.
- Ignoring header/item relationships.
- Performance: querying large tables without indexed selection.