LFA1_ADDR

Transparent Table Application Table
9 Fields 2 CDS Views

Supplier Master (General Section): Address dep. attributes

LFA1_ADDR is an SAP database table in S/4HANA. Supplier Master (General Section): Address dep. attributes. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SupplierAddrDepdnt view from EXTENSION Supl addr dept information - Extn
I_SupplierAddrDepdntGeneral view from BASIC Supplier General Address Dependent info

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lifnr LIFNR Supplier
KEY adrnr BU_ADDRNUM Address Number
bahns BAHNS Train station
plkal FABKL Factory Calend.
stgdl STGDL Stat.grp, agent
fisku FISKU Tax Office
weora WEORA Origin Accept.
dummy_lfa1_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 (General Section): Address dep. attributes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFA1_ADDR (
    MANDT,                        -- Client [MANDT]
    LIFNR,                        -- Supplier [LIFNR]
    ADRNR,                        -- Address Number [BU_ADDRNUM]
    BAHNS,                        -- Train station [BAHNS]
    PLKAL,                        -- Factory Calend. [FABKL]
    STGDL,                        -- Stat.grp, agent [STGDL]
    FISKU,                        -- Tax Office [FISKU]
    WEORA,                        -- Origin Accept. [WEORA]
    DUMMY_LFA1_ADDR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, LIFNR, ADRNR)
);

Learn More