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 from BASIC Demand Driven Stock Proposal Details
P_ProdBufLvlPrpslDemandFctr view from BASIC

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