PRST

Transparent Table Application Table

Project - BOM link

PRST is an SAP database table in S/4HANA. Project - BOM link. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProjectBOMLink view from BASIC Work Breakdown Structure Link for BOM
I_Prst view from BASIC Project - BOM link
P_WBSBillOfMaterialLink view_entity from BASIC

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pspnr CS_PSPNR WBS Element
KEY matnr MATNR Material
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.

-- Project - BOM link
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRST (
    MANDT,  -- Client [MANDT]
    PSPNR,  -- WBS Element [CS_PSPNR]
    MATNR,  -- Material [MATNR]
    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, PSPNR, MATNR, WERKS, STLAN, STLNR, STLAL)
);