LFM1 table — Vendor Purchasing Organization Data Table
LFM1 stores vendor master data at the purchasing organization level: one row per vendor per purchasing organization, holding order currency, payment terms, incoterms, GR-based invoice verification flag, automatic PO indicator, minimum order value and planned delivery time. It is the org-level counterpart to LFA1 (general data) and LFB1 (company code data), and it is what purchasing actually reads when a PO is created.
LFM1 holds the purchasing-organization-specific view of the vendor master: terms of payment, currency, incoterms and control indicators that apply whenever this vendor is purchased from through a given purchasing organization. This page covers the key fields, how it joins into the wider MM data model, and the recurring mistakes consultants make when they read vendor purchasing data without checking which purchasing org actually applies.
Published 15 Sept 2026· 971 words
What it stores
Each row in LFM1 represents the purchasing view of one vendor for one purchasing organization. A vendor extended to three purchasing organizations has three rows here, and each row can carry different payment terms, order currency, incoterms and control settings even though the underlying business partner is the same. This is the data that a purchase order actually inherits by default when it is created against that vendor and purchasing org combination, before any manual override at the PO line. It is maintained in the vendor master purchasing organization data view and is a mandatory extension step before a vendor can be used on a PO issued from that org, distinct from the general data in LFA1 and the accounting-relevant data in LFB1.
Key fields
- MANDT - client
- LIFNR - vendor number, links to LFA1 and LFB1
- EKORG - purchasing organization, the second half of the key
- WAERS - order currency used as default on POs against this vendor and org
- ZTERM - payment terms key defaulted onto purchase orders
- INCO1 / INCO2 - incoterm part 1 and part 2 (free text location)
- WEBRE - GR-based invoice verification indicator, controls whether MIRO can reference the PO directly or must reference the goods receipt
- KZAUT - automatic purchase order indicator, enables automatic PO creation from this vendor
- MINBW - minimum order value for the vendor and purchasing org
- PLIFZ - planned delivery time in days, defaults into the PO delivery date calculation
- MMSTA - purchasing block status at the org level
How it joins the data model
- LFM1-LIFNR = LFA1-LIFNR
- LFM1-LIFNR = LFB1-LIFNR
- LFM1-LIFNR = EKKO-LIFNR (purchase order header vendor)
- LFM1-EKORG = EKKO-EKORG (purchase order purchasing organization)
- LFM1-LIFNR = EINE-LIFNR and LFM1-EKORG = EINE-EKORG (info record purchasing org data, via EINA for the vendor-material link)
How to read it safely
MANDT plus LIFNR plus EKORG form the key, so any selective read restricts on both LIFNR and EKORG together, never LIFNR alone. The table is small relative to transaction tables like EKPO or MSEG, so a full table scan on vendor number alone is usually fine, but pulling it without EKORG produces multiple rows per vendor and silently doubles or triples counts in any join to EKKO if the analyst forgets the org is part of the join. When comparing a value seen on a PO against what LFM1 shows, always confirm which purchasing org the PO actually used, because a vendor can look inconsistent across purchasing orgs when it is in fact configured correctly for each one separately.
How to prove it in the data
Symptom: invoices for a vendor are blocked or postable before goods receipt when the business expects invoice-only-after-GR. Selection: read LFM1 for that LIFNR and the EKORG used on the disputed PO and check WEBRE. If WEBRE is blank, GR-based invoice verification is not active for that vendor and org, and MIRO will accept the PO reference directly regardless of receipt status, which is expected behavior, not a defect.
ECC vs S/4HANA
LFM1 continues to exist as a transparent table in S/4HANA and is still where the purchasing organization vendor data physically sits. The vendor master itself has moved toward business partner as the leading object for maintenance, with LFM1 populated in the background through the business partner vendor role synchronization rather than maintained directly, but reporting and joins written against LFM1 still work unchanged.
Common pitfalls
- Reading LFM1 by LIFNR only and treating the first row returned as the vendor's settings, when the vendor actually has different terms configured per purchasing organization.
- Assuming a change to ZTERM or WAERS in LFM1 retroactively updates existing open purchase orders. It does not; existing PO items keep the values copied in at creation time, and only new POs pick up the new default.
- Concluding a vendor cannot receive automatic POs because KZAUT looks unset, without checking whether the relevant purchasing org row was maintained at all versus simply defaulted.
- Treating MMSTA as the only block that matters and missing a company-code-level block on LFB1 or a central block on LFA1, all three of which can independently stop procurement.
- Comparing incoterms between LFM1 and what appears on a printed PO or info record and assuming a mismatch is a data error, when the info record or the PO line itself carries its own override that takes precedence.
- Forgetting that a vendor with no LFM1 row for a given purchasing organization simply cannot be used on a PO from that org, and misreading the resulting creation error as a general vendor master problem rather than a missing extension.
Whose problem this is
Master data governance or the MM/procurement configuration team owns vendor purchasing org data, since ZTERM, WAERS, incoterms and the GR-based IV flag are business-agreed settings, not free text. Functional MM consultants investigate discrepancies by comparing LFM1 against the actual PO and info record values; changes to the underlying defaults require sign-off from procurement, not a technical fix.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/lfm1ERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.