C_ProposedBufferMatlBOM

DDL: C_PROPOSEDBUFFERMATLBOM SQL: CPRPSDBUFMATBOM Type: view CONSUMPTION
26 Fields 1 Data Sources 2 Associations

Proposed BOM for Buffered Materials

C_ProposedBufferMatlBOM is a Consumption CDS View that provides data about "Proposed BOM for Buffered Materials" in SAP S/4HANA. It reads from 1 data source (P_ProposedBufferMatlBOM) and exposes 26 fields with key fields Material, Plant, MRPArea, BillOfMaterialUUID, ParentComponent. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProposedBufferMatlBOM _ProposedMatlBOM from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaterialText _MaterialText $projection.BillOfMaterialComponent = _MaterialText.Material and _MaterialText.Language = $session.system_language
[1..1] I_ProductPlantMRPArea _Product $projection.BillOfMaterialComponent = _Product.Material and $projection.ComponentPlant = _Product.Plant and $projection.ComponentMRPArea = _Product.MRPArea

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPRPSDBUFMATBOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Proposed BOM for Buffered Materials view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Material P_ProposedBufferMatlBOM Material Vehicle Model
KEY Plant P_ProposedBufferMatlBOM Plant Valuation Area
KEY MRPArea P_ProposedBufferMatlBOM MRPArea MRP Area
KEY BillOfMaterialUUID P_ProposedBufferMatlBOM BillOfMaterialUUID Character Field of Length 12
KEY ParentComponent P_ProposedBufferMatlBOM ParentComponent
KEY ParentPlant P_ProposedBufferMatlBOM ParentPlant
KEY BillOfMaterialComponent P_ProposedBufferMatlBOM BillOfMaterialComponent Component
KEY ComponentPlant ComponentPlant
ComponentMRPArea ComponentMRPArea
ProposedLeadTimeCalcMethod ProposedLeadTimeCalcMethod
CurrentLeadTimeCalcMethod CurrentLeadTimeCalcMethod
ProposalStartDate P_ProposedBufferMatlBOM ProposalStartDate
ProposalVersion P_ProposedBufferMatlBOM ProposalVersion
CreationDateTime P_ProposedBufferMatlBOM CreationDateTime Timestamp
BillOfMaterialStatus P_ProposedBufferMatlBOM BillOfMaterialStatus BOM Status
RowIndex 0
ChildNode 1
MaterialName _MaterialText MaterialName Material Description
MRPProcedure _Product MRPProcedure
SOSHasChanged SOSHasChanged
BOMComponentLeadTimeStatus BOMComponentLeadTimeStatus
BOMComponentLeadTimeStatusText _BOMCompStsText BOMComponentLeadTimeStatusText
SOSHasChangedText _SourceOfSupplyChgdStsTxt SOSHasChangedText
StockLevelProposalID StockLevelProposalID
ProposedLeadTime ProposedLeadTime
CurrentLeadTime CurrentLeadTime

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 C_ProposedBufferMatlBOM.
-- 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: CPRPSDBUFMATBOM

CREATE VIEW C_ProposedBufferMatlBOM AS
SELECT
  _ProposedMatlBOM.Material AS Material,
  _ProposedMatlBOM.Plant AS Plant,
  _ProposedMatlBOM.MRPArea AS MRPArea,
  _ProposedMatlBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  _ProposedMatlBOM.ParentComponent AS ParentComponent,
  _ProposedMatlBOM.ParentPlant AS ParentPlant,
  _ProposedMatlBOM.BillOfMaterialComponent AS BillOfMaterialComponent,
  ComponentPlant,
  ComponentMRPArea,
  ProposedLeadTimeCalcMethod,
  CurrentLeadTimeCalcMethod,
  _ProposedMatlBOM.ProposalStartDate AS ProposalStartDate,
  _ProposedMatlBOM.ProposalVersion AS ProposalVersion,
  _ProposedMatlBOM.CreationDateTime AS CreationDateTime,
  _ProposedMatlBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  0 AS RowIndex,
  1 AS ChildNode,
  _MaterialText.MaterialName AS MaterialName,
  _Product.MRPProcedure AS MRPProcedure,
  SOSHasChanged,
  BOMComponentLeadTimeStatus,
  _BOMCompStsText.BOMComponentLeadTimeStatusText AS BOMComponentLeadTimeStatusText,
  _SourceOfSupplyChgdStsTxt.SOSHasChangedText AS SOSHasChangedText,
  StockLevelProposalID,
  ProposedLeadTime,
  CurrentLeadTime
FROM P_ProposedBufferMatlBOM AS _ProposedMatlBOM
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON BillOfMaterialComponent = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantMRPArea AS _Product ON BillOfMaterialComponent = _Product.Material AND ComponentPlant = _Product.Plant AND ComponentMRPArea = _Product.MRPArea  -- association [1..1]
;

Learn More