T499S

Transparent Table Customizing Table

Location

T499S is an SAP database table in S/4HANA. Location. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Location view from BASIC Location

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY werks WERKS_D Plant
KEY stand STORT_T499S Location
ktext TEXT40 Name
addrnum 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.

-- Location
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T499S (
    MANDT,    -- Client [MANDT]
    WERKS,    -- Plant [WERKS_D]
    STAND,    -- Location [STORT_T499S]
    KTEXT,    -- Name [TEXT40]
    ADDRNUM,  -- Address Number [AD_ADDRNUM]
    PRIMARY KEY (MANDT, WERKS, STAND)
);