TPST

Transparent Table Application Table
10 Fields 3 CDS Views

Link Between Functional Location and BOM

TPST is an SAP database table in S/4HANA. Link Between Functional Location and BOM. It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_DFS_DisconnectedFuncnlBOM view inner BASIC Disconnected Functional BOM
I_FunctionalLocBOMLink view from BASIC Link Between Functional Location and BOM
I_Tpst view from BASIC Link Between Functional Location and BOM

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tplnr TPLNR Functional loc.
KEY werks WERKS_D Plant
KEY stlan STLAN Usage
KEY stlnr STNUM BOM
KEY stlal STALT Alternative
andat ANDAT Created On
annam ANNAM Created by
aedat AEDAT Changed On
aenam AENAM Changed By

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.

-- Link Between Functional Location and BOM
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TPST (
    MANDT,  -- Client [MANDT]
    TPLNR,  -- Functional loc. [TPLNR]
    WERKS,  -- Plant [WERKS_D]
    STLAN,  -- Usage [STLAN]
    STLNR,  -- BOM [STNUM]
    STLAL,  -- Alternative [STALT]
    ANDAT,  -- Created On [ANDAT]
    ANNAM,  -- Created by [ANNAM]
    AEDAT,  -- Changed On [AEDAT]
    AENAM,  -- Changed By [AENAM]
    PRIMARY KEY (MANDT, TPLNR, WERKS, STLAN, STLNR, STLAL)
);

Learn More