PPH_DD_STPR_HDR

Transparent Table Application Table
59 Fields 1 CDS Views

Stock Level Proposal Header

PPH_DD_STPR_HDR is an SAP database table in S/4HANA. Stock Level Proposal Header. It contains 59 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdBufLvlPrpslData view_entity from BASIC Product Buffer Level Proposal Data

Fields (59)

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
prop_date_to pph_proposal_endda Proposal Valid To
proposal_id pph_proposal_id Proposal Id
abc_ind pph_abc_ind Value Indicator
abc_value pph_dd_abc_con_value Value for ABC Analysis
abc_curr waers Currency
abc_mode pph_abc_clfn_mode Value Mode
xyz_ind pph_xyz_ind Variability Indicator
xyz_qty pph_xyz_qty Value from XYZ Analysis
xyz_unit meins Base Unit
xyz_mode pph_xyz_clfn_mode Variability Mode
efg_ind pph_efg_ind DLT Indicator
efg_proctype pph_proc_type Procurement Type
efg_value pph_efg_value Value from EFG Analysis
efg_mode pph_efg_clfn_mode DLT Mode
pqr_ind pph_pqr_ind BOM Usage Indicator
pqr_value pph_pqr_value Value from PQR Analysis
pqr_mode pph_pqr_clfn_mode BOM Usage Mode
horiz_days_minus pph_horizon_past Horizon for past
horiz_days_plus pph_horizon_future Horizon for future
dlt_multiplier_past pph_dlt_multiplier_past DLT Multiplier for Past
dlt_multiplier_futr pph_dlt_multiplier_futr DLT Multiplier for Future
lead_time pph_ind_lead_time Individual Lead Time
lead_time_calc_method pph_leadtime_calc_method ILT Calc. Method
decoupled_lead_time pph_decoupled_leadtime Decoupled Lead Time
source_of_supply pph_source_of_supply Source of Supply
source_type pph_source_type Source Type
factor_lead_time pph_leadtime_factor DLT Factor
factor_variability pph_variability_factor Variabilty Factor
proposal_status pph_proposal_status Proposal Status
proposal_mode pph_proposal_mode Proposal Mode
prop_stat_chng_time pph_prop_stat_chng_time Time Stamp
moq_considerd pph_moq_considered Is MOQ Considered
moq_qty minau Min.order qty
moq_unit meins Base Unit
adj_factor_red pph_adj_factor_red Adj. Factor Red Zone
adj_factor_yellow pph_adj_factor_yellow Adj Fctr Yellow Zone
adj_factor_green pph_adj_factor_green Adj. Fctr Green Zone
adj_factor_red_chng pph_adj_factor_red_chng Adj. Factor Red Zone
adj_factor_yellow_chng pph_adj_factor_yellow_chng Adj. Factor Yel Zone
adj_factor_green_chng pph_adj_factor_green_chng Adj. Fctr. Gree Zone
order_cycle pph_order_cycle Order Cycle
bom_id pph_dd_bomid Internal key for BOM
bom_expl_date pph_bom_expl_date Explosion Date
susp_date_from pph_susp_prpsl_begda Prpsl Run Susp Start
susp_date_to pph_susp_prpsl_endda Prpsl Run Susp End
suspend_ind pph_susp_prpsl_ind Susp Proposal Ind.
change_mode pph_change_mode Mode of Change
adu_mode pph_avgdaily_usage_mode Average Daily Usage Mode
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 Level Proposal Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_DD_STPR_HDR (
    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]
    PROP_DATE_TO,            -- Proposal Valid To [pph_proposal_endda]
    PROPOSAL_ID,             -- Proposal Id [pph_proposal_id]
    ABC_IND,                 -- Value Indicator [pph_abc_ind]
    ABC_VALUE,               -- Value for ABC Analysis [pph_dd_abc_con_value]
    ABC_CURR,                -- Currency [waers]
    ABC_MODE,                -- Value Mode [pph_abc_clfn_mode]
    XYZ_IND,                 -- Variability Indicator [pph_xyz_ind]
    XYZ_QTY,                 -- Value from XYZ Analysis [pph_xyz_qty]
    XYZ_UNIT,                -- Base Unit [meins]
    XYZ_MODE,                -- Variability Mode [pph_xyz_clfn_mode]
    EFG_IND,                 -- DLT Indicator [pph_efg_ind]
    EFG_PROCTYPE,            -- Procurement Type [pph_proc_type]
    EFG_VALUE,               -- Value from EFG Analysis [pph_efg_value]
    EFG_MODE,                -- DLT Mode [pph_efg_clfn_mode]
    PQR_IND,                 -- BOM Usage Indicator [pph_pqr_ind]
    PQR_VALUE,               -- Value from PQR Analysis [pph_pqr_value]
    PQR_MODE,                -- BOM Usage Mode [pph_pqr_clfn_mode]
    HORIZ_DAYS_MINUS,        -- Horizon for past [pph_horizon_past]
    HORIZ_DAYS_PLUS,         -- Horizon for future [pph_horizon_future]
    DLT_MULTIPLIER_PAST,     -- DLT Multiplier for Past [pph_dlt_multiplier_past]
    DLT_MULTIPLIER_FUTR,     -- DLT Multiplier for Future [pph_dlt_multiplier_futr]
    LEAD_TIME,               -- Individual Lead Time [pph_ind_lead_time]
    LEAD_TIME_CALC_METHOD,   -- ILT Calc. Method [pph_leadtime_calc_method]
    DECOUPLED_LEAD_TIME,     -- Decoupled Lead Time [pph_decoupled_leadtime]
    SOURCE_OF_SUPPLY,        -- Source of Supply [pph_source_of_supply]
    SOURCE_TYPE,             -- Source Type [pph_source_type]
    FACTOR_LEAD_TIME,        -- DLT Factor [pph_leadtime_factor]
    FACTOR_VARIABILITY,      -- Variabilty Factor [pph_variability_factor]
    PROPOSAL_STATUS,         -- Proposal Status [pph_proposal_status]
    PROPOSAL_MODE,           -- Proposal Mode [pph_proposal_mode]
    PROP_STAT_CHNG_TIME,     -- Time Stamp [pph_prop_stat_chng_time]
    MOQ_CONSIDERD,           -- Is MOQ Considered [pph_moq_considered]
    MOQ_QTY,                 -- Min.order qty [minau]
    MOQ_UNIT,                -- Base Unit [meins]
    ADJ_FACTOR_RED,          -- Adj. Factor Red Zone [pph_adj_factor_red]
    ADJ_FACTOR_YELLOW,       -- Adj Fctr Yellow Zone [pph_adj_factor_yellow]
    ADJ_FACTOR_GREEN,        -- Adj. Fctr Green Zone [pph_adj_factor_green]
    ADJ_FACTOR_RED_CHNG,     -- Adj. Factor Red Zone [pph_adj_factor_red_chng]
    ADJ_FACTOR_YELLOW_CHNG,  -- Adj. Factor Yel Zone [pph_adj_factor_yellow_chng]
    ADJ_FACTOR_GREEN_CHNG,   -- Adj. Fctr. Gree Zone [pph_adj_factor_green_chng]
    ORDER_CYCLE,             -- Order Cycle [pph_order_cycle]
    BOM_ID,                  -- Internal key for BOM [pph_dd_bomid]
    BOM_EXPL_DATE,           -- Explosion Date [pph_bom_expl_date]
    SUSP_DATE_FROM,          -- Prpsl Run Susp Start [pph_susp_prpsl_begda]
    SUSP_DATE_TO,            -- Prpsl Run Susp End [pph_susp_prpsl_endda]
    SUSPEND_IND,             -- Susp Proposal Ind. [pph_susp_prpsl_ind]
    CHANGE_MODE,             -- Mode of Change [pph_change_mode]
    ADU_MODE,                -- Average Daily Usage Mode [pph_avgdaily_usage_mode]
    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)
);

Learn More