PPH_DD_STPR_COMP
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_StockLevelPrpslBOM | view_entity | from | BASIC | Demand Driven BOM Component Lead Time |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA