P_ProposedBufferMatlBOM1

Proposed Buffer Material BOM | view: PPROPSDMATLBOM | Extraction: Not supported | Component: Fiori App

Tables used: PPH_DD_STPR_HDR, PPH_DD_STPR_DETS, PPH_DD_STPR_ZADJ, PPH_DD_STPR_COMP, PPH_DD_STPR_DADJ, MARA, MARC, MDMA, T023, T134, T006, T006A

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical
Other (6)
🔗 Relations (8)

Column Name	Description
Material FK	Material Number
Plant FK	Plant
MRPArea FK	MRP Area
BillOfMaterialUUID	Internal Key for BOMID
ParentComponent	Parent BOM Component
ParentPlant FK	Plant
BillOfMaterialComponent FK	BOM component
ComponentPlant FK	Plant

Column Name	Description

Column Name	Description

Column Name	Description
ProposalStartDate	Proposal Validity From Date

Column Name	Description

Column Name	Description	Domain name
ProposedLeadTimeCalcMethod	Individual Lead Time calculation Method	PPH_LEADTIME_CALC_METHOD
ProposalVersion	Proposal Version	PPH_PROPOSAL_VER
ComponentSOS	Source of Supply	PPH_SOURCE_OF_SUPPLY
StockLevelProposalID	Proposal Id	PPH_PROPOSAL_ID
ProposedLeadTime	Individual Lead Time in Days	PPH_LEAD_TIME
CreationDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS

Master Data Relations	Join Conditions
BOM component Client BOM component Material Number	`P_PROPOSEDBUFFERMATLBOM1.MANDT == MARA.MANDT` `P_PROPOSEDBUFFERMATLBOM1.BILLOFMATERIALCOMPONENT == MARA.MATNR` `P_PROPOSEDBUFFERMATLBOM1.MATERIAL == MARA.MATNR`
MRP Area Client MRP Area MRP Area MRP Area	`P_PROPOSEDBUFFERMATLBOM1.MANDT == MDLV.MANDT` `P_PROPOSEDBUFFERMATLBOM1.PARENTMRPAREA == MDLV.BERID` `P_PROPOSEDBUFFERMATLBOM1.COMPONENTMRPAREA == MDLV.BERID` `P_PROPOSEDBUFFERMATLBOM1.MRPAREA == MDLV.BERID`
Plant Client Plant Plant Plant	`P_PROPOSEDBUFFERMATLBOM1.MANDT == T001W.MANDT` `P_PROPOSEDBUFFERMATLBOM1.COMPONENTPLANT == T001W.WERKS` `P_PROPOSEDBUFFERMATLBOM1.PARENTPLANT == T001W.WERKS` `P_PROPOSEDBUFFERMATLBOM1.PLANT == T001W.WERKS`
Material Number Client BOM component Material Number	`P_PROPOSEDBUFFERMATLBOM1.MANDT == MARA.MANDT` `P_PROPOSEDBUFFERMATLBOM1.BILLOFMATERIALCOMPONENT == MARA.MATNR` `P_PROPOSEDBUFFERMATLBOM1.MATERIAL == MARA.MATNR`
MRP Area Client MRP Area MRP Area MRP Area	`P_PROPOSEDBUFFERMATLBOM1.MANDT == MDLV.MANDT` `P_PROPOSEDBUFFERMATLBOM1.PARENTMRPAREA == MDLV.BERID` `P_PROPOSEDBUFFERMATLBOM1.COMPONENTMRPAREA == MDLV.BERID` `P_PROPOSEDBUFFERMATLBOM1.MRPAREA == MDLV.BERID`
MRP Area Client MRP Area MRP Area MRP Area	`P_PROPOSEDBUFFERMATLBOM1.MANDT == MDLV.MANDT` `P_PROPOSEDBUFFERMATLBOM1.PARENTMRPAREA == MDLV.BERID` `P_PROPOSEDBUFFERMATLBOM1.COMPONENTMRPAREA == MDLV.BERID` `P_PROPOSEDBUFFERMATLBOM1.MRPAREA == MDLV.BERID`
Plant Client Plant Plant Plant	`P_PROPOSEDBUFFERMATLBOM1.MANDT == T001W.MANDT` `P_PROPOSEDBUFFERMATLBOM1.COMPONENTPLANT == T001W.WERKS` `P_PROPOSEDBUFFERMATLBOM1.PARENTPLANT == T001W.WERKS` `P_PROPOSEDBUFFERMATLBOM1.PLANT == T001W.WERKS`
Plant Client Plant Plant Plant	`P_PROPOSEDBUFFERMATLBOM1.MANDT == T001W.MANDT` `P_PROPOSEDBUFFERMATLBOM1.COMPONENTPLANT == T001W.WERKS` `P_PROPOSEDBUFFERMATLBOM1.PARENTPLANT == T001W.WERKS` `P_PROPOSEDBUFFERMATLBOM1.PLANT == T001W.WERKS`