What is P_ProposedBufferMatlBOM1 in SAP S/4HANA?

P_ProposedBufferMatlBOM1 is a consumption CDS view in SAP S/4HANA. Proposed Buffer Material BOM It contains 33 fields.

Which tables does P_ProposedBufferMatlBOM1 read from?

P_ProposedBufferMatlBOM1 reads data from: I_StockLevelPrpslBOM, P_ProposedBufferMatlBOM2, I_ProdBufLvlPrpsl.

What VDM layer is P_ProposedBufferMatlBOM1?

P_ProposedBufferMatlBOM1 is classified as a Consumption view optimized for specific business scenarios and reporting.

P_ProposedBufferMatlBOM1

DDL: P_PROPOSEDBUFFERMATLBOM1 SQL: PPROPSDMATLBOM Type: view CONSUMPTION

33 Fields 3 Data Sources

Proposed Buffer Material BOM

P_ProposedBufferMatlBOM1 is a Consumption CDS View that provides data about "Proposed Buffer Material BOM" in SAP S/4HANA. It reads from 3 data sources (I_StockLevelPrpslBOM, P_ProposedBufferMatlBOM2, I_ProdBufLvlPrpsl) and exposes 33 fields with key fields Material, Plant, MRPArea, BillOfMaterialUUID, ParentComponent.

Data Sources (3)

Source	Alias	Join Type
I_StockLevelPrpslBOM	_BOMProposal	left_outer
P_ProposedBufferMatlBOM2	_ProposedStockBuffer	from
I_ProdBufLvlPrpsl	_ProposedStockBuffer	union_all

Annotations (7)

Name	Value	Level
AbapCatalog.sqlViewName	PPROPSDMATLBOM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Proposed Buffer Material BOM	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view

Fields (33)

Key	Field	Source Table	Source Field	Description
KEY	Material	I_ProdBufLvlPrpsl	Material	Vehicle Model
KEY	Plant	I_ProdBufLvlPrpsl	Plant	Valuation Area
KEY	MRPArea	I_ProdBufLvlPrpsl	MRPArea	MRP Area
KEY	BillOfMaterialUUID	I_ProdBufLvlPrpsl	BillOfMaterialUUID	Character Field of Length 12
KEY	ParentComponent			Parent BOM Comp
KEY	ParentPlant	I_ProdBufLvlPrpsl	ParentPlant	Valuation Area
KEY	BillOfMaterialComponent			Component
KEY	ComponentPlant	I_ProdBufLvlPrpsl	Plant	Valuation Area
	ComponentMRPArea		ComponentMRPArea	MRP Area
	ParentMRPArea		ParentMRPArea	Parent MRP Area
	ProposedLeadTimeCalcMethod		LeadTimeCalculationMethod
	ProposalStartDate	I_ProdBufLvlPrpsl	ProposalStartDate
	ProposalVersion	I_ProdBufLvlPrpsl	ProposalVersion
	ComponentSOS	I_ProdBufLvlPrpsl	ComponentSOS	Supply source
	StockLevelProposalID	I_ProdBufLvlPrpsl	StockLevelProposalID
	ProposedLeadTime	I_ProdBufLvlPrpsl	ProposedLeadTime	Individual Lead Time
	BillOfMaterialUUIDkeyMaterial
KEY	Plant		Plant	Valuation Area
KEY	MRPArea		MRPArea	MRP Area
KEY	BillOfMaterialUUID	I_ProdBufLvlPrpsl	BillOfMaterialUUID	Character Field of Length 12
KEY	ParentComponent	I_StockLevelPrpslBOM	ParentComponent	Parent BOM Comp
KEY	ParentPlantendasParentPlant
KEY	BillOfMaterialComponent	I_StockLevelPrpslBOM	BillOfMaterialComponent	Component
KEY	ComponentPlantendasComponentPlant
	ComponentMRPAreaendasComponentMRPArea
	ParentMRPAreaendasParentMRPArea
	ProposedLeadTimeCalcMethod	I_StockLevelPrpslBOM	LeadTimeCalculationMethod
	ProposalStartDate		ProposalStartDate
	ProposalVersion	I_ProdBufLvlPrpsl	ProposalVersion
	ComponentSOS	I_StockLevelPrpslBOM	ComponentSOS	Supply source
	StockLevelProposalID	I_ProdBufLvlPrpsl	StockLevelProposalID
	ProposedLeadTime	I_StockLevelPrpslBOM	ComponentLeadTime	Individual Lead Time
	CreationDateTime	I_StockLevelPrpslBOM	CreationDateTime	Timestamp

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ProposedBufferMatlBOM1.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PPROPSDMATLBOM

CREATE VIEW P_ProposedBufferMatlBOM1 AS
SELECT
  _ProposedStockBuffer.Material AS Material,
  _ProposedStockBuffer.Plant AS Plant,
  _ProposedStockBuffer.MRPArea AS MRPArea,
  _ProposedStockBuffer.BillOfMaterialUUID AS BillOfMaterialUUID,
  cast('' as pph_parent_bom_comp) AS ParentComponent,
  _ProposedStockBuffer.ParentPlant AS ParentPlant,
  cast(_ProposedStockBuffer.Material as idnrk) AS BillOfMaterialComponent,
  _ProposedStockBuffer.Plant AS ComponentPlant,
  ComponentMRPArea,
  ParentMRPArea,
  LeadTimeCalculationMethod AS ProposedLeadTimeCalcMethod,
  _ProposedStockBuffer.ProposalStartDate AS ProposalStartDate,
  _ProposedStockBuffer.ProposalVersion AS ProposalVersion,
  _ProposedStockBuffer.ComponentSOS AS ComponentSOS,
  _ProposedStockBuffer.StockLevelProposalID AS StockLevelProposalID,
  _ProposedStockBuffer.ProposedLeadTime AS ProposedLeadTime,
  _ProposedStockBuffer.CreationDateTime as CreationDateTime AS BillOfMaterialUUIDkeyMaterial,
  case when _BOMProposal.ParentPlant is null or _BOMProposal.ParentPlant = '' then _ProposedStockBuffer.Plant else _BOMProposal.ParentPlant end as ParentPlant AS ParentPlantendasParentPlant,
  case when _BOMProposal.ComponentPlant is null or _BOMProposal.ComponentPlant = '' then _ProposedStockBuffer.Plant else _BOMProposal.ComponentPlant end as ComponentPlant AS ComponentPlantendasComponentPlant,
  case when _BOMProposal.ComponentMRPArea is null or _BOMProposal.ComponentMRPArea = '' then _ProposedStockBuffer.MRPArea else _BOMProposal.ComponentMRPArea end as ComponentMRPArea AS ComponentMRPAreaendasComponentMRPArea,
  case when _BOMProposal.ParentMRPArea is null or _BOMProposal.ParentMRPArea = '' then _ProposedStockBuffer.MRPArea else _BOMProposal.ParentMRPArea end as ParentMRPArea AS ParentMRPAreaendasParentMRPArea,
  _BOMProposal.CreationDateTime AS CreationDateTime
FROM P_ProposedBufferMatlBOM2 AS _ProposedStockBuffer
LEFT OUTER JOIN I_StockLevelPrpslBOM AS _BOMProposal ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_ProdBufLvlPrpsl
;

Depth:

P_ProposedBufferMatlBOM1 view