LFA1 table — LFA1 Vendor Master General Data
LFA1 holds one row per vendor number, storing the client-independent general data such as name, address, country, and central control flags like the central deletion and posting blocks. It has no company code or purchasing organization data; those live in LFB1 and LFM1. Missing vendor master issues usually mean the number exists here but was never extended to the org level a transaction needs.
LFA1 is the root table of the vendor master, one row per vendor account number, holding the general data segment that is not tied to any company code or purchasing organization. This page covers what actually goes wrong when a vendor cannot be used in a purchase order or invoice, and how to tell a genuine master data gap from an extension gap in LFB1 or LFM1.
Published 15 Sept 2026· 992 words
What it stores
One row in LFA1 represents a single vendor account number at the general data level: name, address, country, language, search terms, tax numbers, bank reference indicator, and account group. This data is shared across every company code and purchasing organization that vendor is later extended into. LFA1 does not carry payment terms, reconciliation account, or purchasing conditions; those are org-dependent and sit in LFB1 (company code) and LFM1 (purchasing organization). A vendor number existing in LFA1 only means the business partner has been created centrally, not that it can be used on a purchase order or an invoice in a given company code. Central blocking and deletion flags also live here, which is why a vendor can be usable in one company code but centrally blocked from all new postings everywhere.
Key fields
- MANDT - client, always the first field in any selection
- LIFNR - vendor account number, the key that links to every other vendor table
- NAME1 - vendor name as printed on correspondence and used in matchcode searches
- LAND1 - country key, drives tax and address logic
- ORT01 - city
- PSTLZ - postal code
- STRAS - street address
- SPRAS - language key used for correspondence and long text
- KTOKK - vendor account group, controls the field status and number range at creation
- SPERR - central posting block flag
- LOEVM - central deletion flag
- STCD1 - tax number 1, commonly the local tax registration
- STCD2 - tax number 2
- KONZS - group key, used to identify related vendors under the same corporate group
How it joins the data model
- LFA1-LIFNR = LFB1-LIFNR, joins to company code specific data such as reconciliation account and payment terms
- LFA1-LIFNR = LFM1-LIFNR, joins to purchasing organization data such as order currency and terms of delivery
- LFA1-LIFNR = EKKO-LIFNR, joins to purchasing documents raised against the vendor
- LFA1-LIFNR = RBKP-LIFNR, joins to incoming invoices posted against the vendor
How to read it safely
Always restrict on MANDT first, though most reporting tools set this implicitly. LIFNR is the natural key and is highly selective when known; selecting by NAME1 or LAND1 without a company code filter returns noisy, duplicate-prone results because the same legal entity can appear under several vendor numbers. LFA1 alone is a small, fast table to scan by primary key, but it says nothing about whether the vendor is usable anywhere; do not conclude from a clean LFA1 row that the vendor can post. Before treating a vendor as fully set up, the company code extension in LFB1 and the purchasing organization extension in LFM1 both have to be checked separately.
How to prove it in the data
Symptom: a buyer reports the vendor cannot be selected when creating a purchase order for a given purchasing organization. Select LFA1 by LIFNR to confirm the vendor exists centrally and that SPERR and LOEVM are blank. Then select LFM1 by the same LIFNR and the purchasing organization in question. If no row comes back, the vendor was created centrally but never extended to that purchasing organization, which is the actual cause, not a master data corruption in LFA1.
ECC vs S/4HANA
In S/4HANA, vendor master data is technically stored through the business partner model, with LFA1 retained as a compatibility view over the underlying business partner tables so that existing reports and custom code using LIFNR continue to work. Reads against LFA1 still function; new vendor creation is expected to go through business partner maintenance rather than the classic vendor transactions. Field content and behavior for general data are largely unchanged from a reporting perspective, though the source of truth has moved.
Common pitfalls
- Assuming a vendor visible in LFA1 is ready for procurement or payment; without a matching LFB1 row for the company code and an LFM1 row for the purchasing organization, no transaction will accept it
- Treating SPERR as the only block that matters; a company-code-level posting block in LFB1 or a purchasing-organization-level block in LFM1 can stop a transaction even when LFA1-SPERR is blank
- Searching by NAME1 and assuming one match means one vendor; duplicate vendor creation is common and multiple LIFNR values can carry near-identical names and addresses
- Reading LOEVM as meaning the vendor has been deleted from the database; it is a deletion flag pending archiving, the master record and all its history are still present and still joinable
- Ignoring KTOKK when comparing two vendors that behave differently; the account group controls which fields are mandatory or hidden and explains apparent inconsistencies between vendor records
- Forgetting that address and tax fields on LFA1 are shared globally; a change made for one company code's reporting need affects every company code using that vendor
Whose problem this is
Vendor master data governance sits with the MM master data or vendor maintenance team, often a shared service function, not with the requester or buyer. Extension to new company codes or purchasing organizations typically requires a formal request through that team, since it touches reconciliation account assignment and payment terms that finance also has to agree to.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/lfa1ERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.