PPH_DD_STPR_COMP

Transparent Table Application Table

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_entity 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)
);