LFM1_ADDR

Transparent Table Application Table
30 Fields 2 CDS Views

Supplier master purchasing org data: Address dep. attributes

LFM1_ADDR is an SAP database table in S/4HANA. Supplier master purchasing org data: Address dep. attributes. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SuplrAddrDepdntPurgOrg view from EXTENSION Suplr Add dept purch org - Extn
I_SuplrAddrDepdntPurchasingOrg view from BASIC Supplier Purch org data For Address

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lifnr ELIFN Supplier
KEY adrnr BU_ADDRNUM Address Number
KEY ekorg EKORG Purchasing Org.
sperm SPERM_M Pur. block POrg
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
expvz EXPVZ Mode of Trans.
zolla DZOLLS Customs office
ekgrp EKGRP Purch. Group
plifz PLIFZ Pl. Deliv. Time
mrppp MRPPP_W Planning cal.
lfrhy LFRHY Planning Cycle
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
weora WEORA Origin Accept.
abueb ABUEB Creation Profile
transport_chain WRF_PSCD_TC_ID Transportation Chain
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
eikto EIKTO_M Acc. w. supplier
vsbed VSBED Shipping Conditions
dummy_lfm1_addr_incl_eew_ps CFD_DUMMY Dummy

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.

-- Supplier master purchasing org data: Address dep. attributes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFM1_ADDR (
    MANDT,                        -- Client [MANDT]
    LIFNR,                        -- Supplier [ELIFN]
    ADRNR,                        -- Address Number [BU_ADDRNUM]
    EKORG,                        -- Purchasing Org. [EKORG]
    SPERM,                        -- Pur. block POrg [SPERM_M]
    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]
    EXPVZ,                        -- Mode of Trans. [EXPVZ]
    ZOLLA,                        -- Customs office [DZOLLS]
    EKGRP,                        -- Purch. Group [EKGRP]
    PLIFZ,                        -- Pl. Deliv. Time [PLIFZ]
    MRPPP,                        -- Planning cal. [MRPPP_W]
    LFRHY,                        -- Planning Cycle [LFRHY]
    INCOV,                        -- Inco. Version [INCOV]
    INCO2_L,                      -- Inco. Location1 [INCO2_L]
    INCO3_L,                      -- Inco. Location2 [INCO3_L]
    WEORA,                        -- Origin Accept. [WEORA]
    ABUEB,                        -- Creation Profile [ABUEB]
    TRANSPORT_CHAIN,              -- Transportation Chain [WRF_PSCD_TC_ID]
    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]
    EIKTO,                        -- Acc. w. supplier [EIKTO_M]
    VSBED,                        -- Shipping Conditions [VSBED]
    DUMMY_LFM1_ADDR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, LIFNR, ADRNR, EKORG)
);

Learn More