PPH_DD_STPR_HDR

Stock Level Proposal Header | #header | Component: Basis
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
BERID FK MRP Area
PROP_DATE_FROM Proposal Validity From Date
PROP_VER Proposal Version
Column Name Description
💲 Currency Key (ABC_CURR):
ABC_VALUE Value for ABC Analysis ( Specific to DDMRP )
Column Name Description
📏 Base Unit of Measure (XYZ_UNIT):
XYZ_QTY Value from XYZ Analysis
📏 Base Unit of Measure (MOQ_UNIT):
MOQ_QTY Minimum order quantity in base unit of measure
Column Name Description
PROP_DATE_FROM Proposal Validity From Date
PROP_DATE_TO Proposal Valid To Date
BOM_EXPL_DATE BOM Explosion Date
SUSP_DATE_FROM Proposal Run Suspension Start Date
SUSP_DATE_TO Proposal Run Suspension End Date
_DATAAGING Data Filter Value for Data Aging
Column Name Description
ABC_IND Value Indicator Show values
ABC_MODE Value Mode Show values
XYZ_IND Variability Co-efficient Indicator Show values
XYZ_MODE Variability Mode Show values
EFG_IND Decoupled Lead Time Indicator Show values
EFG_PROCTYPE Procurement Type Show values
EFG_MODE Decoupled Lead Time Mode Show values
PQR_IND BOM Usage Indicator Show values
PQR_MODE BOM Usage Mode Show values
SOURCE_TYPE Source Type Show values
PROPOSAL_STATUS Proposal Status Show values
PROPOSAL_MODE Proposal Mode Show values
MOQ_CONSIDERD Is Minimum Order Quantity Considered Show values
CHANGE_MODE Mode of change Show values
ADU_MODE Average Daily Usage Mode Show values
Column Name Description Domain name
PROPOSAL_ID Proposal Id PPH_PROPOSAL_ID
EFG_VALUE Value from EFG Analysis PPH_EFG_VALUE
PQR_VALUE Value from PQR Analysis PPH_PQR_VALUE
HORIZ_DAYS_MINUS Period for ADU and LeadTime calculation in past days PPH_HORIZON_PAST
HORIZ_DAYS_PLUS Period for ADU calculation in future days PPH_HORIZON_FUTURE
LEAD_TIME Individual Lead Time in Days PPH_LEAD_TIME
DECOUPLED_LEAD_TIME Decoupled Lead Time PPH_LEAD_TIME
SOURCE_OF_SUPPLY Source of Supply PPH_SOURCE_OF_SUPPLY
FACTOR_LEAD_TIME Decoupled Lead Time Factor PPH_FACTOR
FACTOR_VARIABILITY Variability Factor PPH_VARIABILITY_FACTOR
PROP_STAT_CHNG_TIME Proposal Status Changed Time TZNTSTMPS
ADJ_FACTOR_RED Adjustment Factor for Red Zone (Obselete) PPH_ADJ_FACTOR
ADJ_FACTOR_YELLOW Adjustment Factor for Yellow Zone (Obselete) PPH_ADJ_FACTOR
ADJ_FACTOR_GREEN Adjustment Factor for Green Zone (Obselete) PPH_ADJ_FACTOR
ADJ_FACTOR_RED_CHNG Modified Adjustment Factor for Red Zone (Obselete) PPH_ADJ_FACTOR
ADJ_FACTOR_YELLOW_CHNG Modified Adjustment Factor for Yellow Zone (Obselete) PPH_ADJ_FACTOR
ADJ_FACTOR_GREEN_CHNG Modified Adjustment Factor for Green Zone (Obselete) PPH_ADJ_FACTOR
ORDER_CYCLE Order Cycle in Days PPH_ORDER_CYCLE
BOM_ID Internal Key for BOMID SYSUUID
SUSPEND_IND Suspend Proposal Indicator CHAR1
CREATED_BY Name of Person Responsible for Creating the Object USNAM
CHANGED_BY Name of Person Who Changed Object USNAM
CREATED_TIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CHANGED_TIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
MRP Area
  • PPH_DD_STPR_HDR.MANDT == MDLV.MANDT
  • PPH_DD_STPR_HDR.BERID == MDLV.BERID
Individual Lead Time calculation Method
Client PPH_DD_STPR_HDR.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • PPH_DD_STPR_HDR.MATNR == MARA.MATNR
  • PPH_DD_STPR_HDR.MANDT == MARA.MANDT
Base Unit of Measure
  • PPH_DD_STPR_HDR.MANDT == T006.MANDT
  • PPH_DD_STPR_HDR.MOQ_UNIT == T006.MSEHI
Plant
  • PPH_DD_STPR_HDR.MANDT == T001W.MANDT
  • PPH_DD_STPR_HDR.WERKS == T001W.WERKS