TWLAD

Transparent Table Customizing Table
5 Fields 1 CDS Views

Determination of Address from Plant and Storage Location

TWLAD is an SAP database table in S/4HANA. Determination of Address from Plant and Storage Location. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StorageLocationAddress view from BASIC Assigned addresses of storage locations

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY werks werks_d Plant
KEY lgort lgort_d Location
KEY lfdnr lfdnr_twlad Sequential no.
adrnr ad_addrnum Address Number

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.

-- Determination of Address from Plant and Storage Location
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TWLAD (
    MANDT,  -- Client [mandt]
    WERKS,  -- Plant [werks_d]
    LGORT,  -- Location [lgort_d]
    LFDNR,  -- Sequential no. [lfdnr_twlad]
    ADRNR,  -- Address Number [ad_addrnum]
    PRIMARY KEY (MANDT, WERKS, LGORT, LFDNR)
);

Learn More