LFM2

Transparent Table Application Table
55 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 55 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 (55)

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
erdat ERDAT Created On
ernam ERNAM Created By
sperm SPERM_M Pur. block POrg
loevm LOEVM_M Del. flag POrg.
lfabc LFABC ABC indicator
waers BSTWA Order currency
verkf EVERK Salesperson
telf1 TELFE Telephone
minbw MINBW Minimum value
zterm DZTERM Pyt Terms
inco1 INCO1 Incoterms
inco2 INCO2 Incoterms 2
webre WEBRE GR-Based IV
kzabs KZABS Acknowl. Reqd.
kalsk KALSK Schema Grp Supp
kzaut KZAUT Automatic PO
expvz EXPVZ Mode of Trans.
zolla DZOLLS Customs office
meprf MEPRF Pr. Date Cat.
ekgrp EKGRP Purch. Group
xersy XERSY ERS
plifz PLIFZ Pl. Deliv. Time
mrppp MRPPP_W Planning cal.
lfrhy LFRHY Planning Cycle
libes LIBES PO entry: supp.
lipre LIPRE Price mkg. sup.
liser LISER Rack jobbing
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
weora WEORA Origin Accept.
inco2_key /SCMTMS/INC_LOC_1_KEY Incoterm Location 1
inco3_key /SCMTMS/INC_LOC_2_KEY Incoterm Location 2
inco4_key /SCMTMS/INC_DEV_PLACE_DEST_KEY Dev. Destination
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
upprs UPPRS Subitem pricing
transport_chain WRF_PSCD_TC_ID Transportation Chain
staging_time WRF_PSCD_MST Staging Time

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]
    ERDAT,            -- Created On [ERDAT]
    ERNAM,            -- Created By [ERNAM]
    SPERM,            -- Pur. block POrg [SPERM_M]
    LOEVM,            -- Del. flag POrg. [LOEVM_M]
    LFABC,            -- ABC indicator [LFABC]
    WAERS,            -- Order currency [BSTWA]
    VERKF,            -- Salesperson [EVERK]
    TELF1,            -- Telephone [TELFE]
    MINBW,            -- Minimum value [MINBW]
    ZTERM,            -- Pyt Terms [DZTERM]
    INCO1,            -- Incoterms [INCO1]
    INCO2,            -- Incoterms 2 [INCO2]
    WEBRE,            -- GR-Based IV [WEBRE]
    KZABS,            -- Acknowl. Reqd. [KZABS]
    KALSK,            -- Schema Grp Supp [KALSK]
    KZAUT,            -- Automatic PO [KZAUT]
    EXPVZ,            -- Mode of Trans. [EXPVZ]
    ZOLLA,            -- Customs office [DZOLLS]
    MEPRF,            -- Pr. Date Cat. [MEPRF]
    EKGRP,            -- Purch. Group [EKGRP]
    XERSY,            -- ERS [XERSY]
    PLIFZ,            -- Pl. Deliv. Time [PLIFZ]
    MRPPP,            -- Planning cal. [MRPPP_W]
    LFRHY,            -- Planning Cycle [LFRHY]
    LIBES,            -- PO entry: supp. [LIBES]
    LIPRE,            -- Price mkg. sup. [LIPRE]
    LISER,            -- Rack jobbing [LISER]
    INCOV,            -- Inco. Version [INCOV]
    INCO2_L,          -- Inco. Location1 [INCO2_L]
    INCO3_L,          -- Inco. Location2 [INCO3_L]
    WEORA,            -- Origin Accept. [WEORA]
    INCO2_KEY,        -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY]
    INCO3_KEY,        -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY]
    INCO4_KEY,        -- Dev. Destination [/SCMTMS/INC_DEV_PLACE_DEST_KEY]
    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]
    UPPRS,            -- Subitem pricing [UPPRS]
    TRANSPORT_CHAIN,  -- Transportation Chain [WRF_PSCD_TC_ID]
    STAGING_TIME,     -- Staging Time [WRF_PSCD_MST]
    PRIMARY KEY (MANDT, LIFNR, EKORG, LTSNR, WERKS)
);

Learn More