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