PPH_DD_STPR_COMP

Transparent Table Application Table
17 Fields 1 CDS Views

Stock Proposal BOM Component

PPH_DD_STPR_COMP is an SAP database table in S/4HANA. Stock Proposal BOM Component. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StockLevelPrpslBOM view from BASIC Demand Driven BOM Component Lead Time

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bom_id PPH_DD_BOMID Internal key for BOM
KEY parent_comp PPH_PARENT_BOM_COMP Parent BOM Comp
KEY parent_werks PPH_PARENT_WERKS Parent Plant
KEY component IDNRK Component
KEY comp_werks PPH_COMPONENT_WERKS Component Plant
parent_berid PPH_PARENT_BERID Parent MRP Area
comp_berid PPH_COMPONENT_BERID Component MRP Area
comp_lead_time PPH_IND_LEAD_TIME Individual Lead Time
comp_lead_time_calc_method PPH_LEADTIME_CALC_METHOD ILT Calc. Method
comp_sos PPH_SOURCE_OF_SUPPLY Source of Supply
comp_sos_type PPH_SOURCE_TYPE Source Type
created_by ERNAM Created By
changed_by AENAM Changed By
created_time TIMESTAMP Time Stamp
changed_time TIMESTAMP Time Stamp
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Stock Proposal BOM Component
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_DD_STPR_COMP (
    MANDT,                       -- Client [MANDT]
    BOM_ID,                      -- Internal key for BOM [PPH_DD_BOMID]
    PARENT_COMP,                 -- Parent BOM Comp [PPH_PARENT_BOM_COMP]
    PARENT_WERKS,                -- Parent Plant [PPH_PARENT_WERKS]
    COMPONENT,                   -- Component [IDNRK]
    COMP_WERKS,                  -- Component Plant [PPH_COMPONENT_WERKS]
    PARENT_BERID,                -- Parent MRP Area [PPH_PARENT_BERID]
    COMP_BERID,                  -- Component MRP Area [PPH_COMPONENT_BERID]
    COMP_LEAD_TIME,              -- Individual Lead Time [PPH_IND_LEAD_TIME]
    COMP_LEAD_TIME_CALC_METHOD,  -- ILT Calc. Method [PPH_LEADTIME_CALC_METHOD]
    COMP_SOS,                    -- Source of Supply [PPH_SOURCE_OF_SUPPLY]
    COMP_SOS_TYPE,               -- Source Type [PPH_SOURCE_TYPE]
    CREATED_BY,                  -- Created By [ERNAM]
    CHANGED_BY,                  -- Changed By [AENAM]
    CREATED_TIME,                -- Time Stamp [TIMESTAMP]
    CHANGED_TIME,                -- Time Stamp [TIMESTAMP]
    _DATAAGING,                  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, BOM_ID, PARENT_COMP, PARENT_WERKS, COMPONENT, COMP_WERKS)
);

Learn More