PPH_DD_STPR_DETS

Transparent Table Application Table
16 Fields 3 CDS Views

Stock Proposal Item Details

PPH_DD_STPR_DETS is an SAP database table in S/4HANA. Stock Proposal Item Details. It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProdBufLvlPrpslDemand view from BASIC Product Buffer Level Proposal Demand
I_StockLevelPrpslDets view_entity from BASIC Demand Driven Stock Proposal Details
P_ProdBufLvlPrpslDemandFctr view_entity from BASIC Demand Factor Records for SDM Migration

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks werks_d Plant
KEY berid berid MRP Area
KEY prop_date_from pph_proposal_begda Proposal Valid From
KEY prop_ver pph_proposal_ver Proposal Version
KEY calc_for_date pph_calculated_for Prpsl Det. Valid Frm
prop_det_valid_to pph_propsal_det_valid_to Prpsl Det. Valid To
avgdailyusage pph_average_daily_usage Average Daily Usage
adu_unit meins Base Unit
demand_adj_factor pph_demand_adj_factor Demand Adj. Fctr.
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 Item Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_DD_STPR_DETS (
    MANDT,              -- Client [mandt]
    MATNR,              -- Material [matnr]
    WERKS,              -- Plant [werks_d]
    BERID,              -- MRP Area [berid]
    PROP_DATE_FROM,     -- Proposal Valid From [pph_proposal_begda]
    PROP_VER,           -- Proposal Version [pph_proposal_ver]
    CALC_FOR_DATE,      -- Prpsl Det. Valid Frm [pph_calculated_for]
    PROP_DET_VALID_TO,  -- Prpsl Det. Valid To [pph_propsal_det_valid_to]
    AVGDAILYUSAGE,      -- Average Daily Usage [pph_average_daily_usage]
    ADU_UNIT,           -- Base Unit [meins]
    DEMAND_ADJ_FACTOR,  -- Demand Adj. Fctr. [pph_demand_adj_factor]
    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, MATNR, WERKS, BERID, PROP_DATE_FROM, PROP_VER, CALC_FOR_DATE)
);

Learn More