LFM2

Transparent Table Application Table
18 Fields 2 CDS Views

Vendor Master Record: Purchasing Data

LFM2 is an SAP database table in S/4HANA. Vendor Master Record: Purchasing Data. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SupplierPurch view from BASIC Vendor Details for Purchasing
I_SupplierPurchasingData view_entity from BASIC Supplier Purchasing Data

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY lifnr lifnr Supplier
KEY ekorg ekorg Purchasing Org.
KEY ltsnr ltsnr Suppl. Subrange
KEY werks werks_d Plant
dispo dispo MRP Controller
boind boind_unused SS Index Active
bstae bstae Conf. Control
rdprf rdprf Rnding Profile
megru megru UoM Group
bopnr bopnr LB profile
xersr xersr Aut. GRSet Ret
abueb abueb Creation Profile
paprf wvmi_paprf PROACT control prof
xnbwy xnbwy Revaluation
lebre lebre Srv.-Based Inv. Ver.
bolre bolre_unused Subseq. Settlmt
umsae umsae_unused BVC

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Vendor Master Record: Purchasing Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFM2 (
    MANDT,  -- Client [mandt]
    LIFNR,  -- Supplier [lifnr]
    EKORG,  -- Purchasing Org. [ekorg]
    LTSNR,  -- Suppl. Subrange [ltsnr]
    WERKS,  -- Plant [werks_d]
    DISPO,  -- MRP Controller [dispo]
    BOIND,  -- SS Index Active [boind_unused]
    BSTAE,  -- Conf. Control [bstae]
    RDPRF,  -- Rnding Profile [rdprf]
    MEGRU,  -- UoM Group [megru]
    BOPNR,  -- LB profile [bopnr]
    XERSR,  -- Aut. GRSet Ret [xersr]
    ABUEB,  -- Creation Profile [abueb]
    PAPRF,  -- PROACT control prof [wvmi_paprf]
    XNBWY,  -- Revaluation [xnbwy]
    LEBRE,  -- Srv.-Based Inv. Ver. [lebre]
    BOLRE,  -- Subseq. Settlmt [bolre_unused]
    UMSAE,  -- BVC [umsae_unused]
    PRIMARY KEY (MANDT, LIFNR, EKORG, LTSNR, WERKS)
);

Learn More