P_ProposedBufferMatlBOM

DDL: P_PROPOSEDBUFFERMATLBOM SQL: PPROPOSEDMATLBOM Type: view CONSUMPTION Package: ODATA_PP_DD_STLM
19 Fields 1 Data Sources 2 Associations

Proposed Buffer Material BOM

P_ProposedBufferMatlBOM is a Consumption CDS View that provides data about "Proposed Buffer Material BOM" in SAP S/4HANA. It reads from 1 data source (P_CurrentBufferMatlBOM) and exposes 19 fields with key fields Material, Plant, MRPArea, BillOfMaterialUUID, ParentComponent. It has 2 associations to related views. Part of development package ODATA_PP_DD_STLM.

Data Sources (1)

SourceAliasJoin Type
P_CurrentBufferMatlBOM _CurrentBOM left_outer

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SourceOfSupplyChgdStsTxt _SourceOfSupplyChgdStsTxt $projection.SOSHasChanged = _SourceOfSupplyChgdStsTxt.SOSHasChanged and _SourceOfSupplyChgdStsTxt.Language = $session.system_language
[1..1] I_BOMCompStsText _BOMCompStsText $projection.BOMComponentLeadTimeStatus = _BOMCompStsText.BOMComponentLeadTimeStatus and _BOMCompStsText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPROPOSEDMATLBOM 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 (19)

KeyFieldSource TableSource FieldDescription
KEY Material _ProposedMatlBOM Material Vehicle Model
KEY Plant _ProposedMatlBOM Plant Valuation Area
KEY MRPArea _ProposedMatlBOM MRPArea MRP Area
KEY BillOfMaterialUUID _ProposedMatlBOM BillOfMaterialUUID Character Field of Length 12
KEY ParentComponent _ProposedMatlBOM ParentComponent
KEY ParentPlant _ProposedMatlBOM ParentPlant
KEY BillOfMaterialComponent _ProposedMatlBOM BillOfMaterialComponent Component
KEY ComponentPlant _ProposedMatlBOM ComponentPlant
ComponentMRPArea _ProposedMatlBOM ComponentMRPArea
ProposedLeadTimeCalcMethod ProposedLeadTimeCalcMethod
CurrentLeadTimeCalcMethod P_CurrentBufferMatlBOM CurrentLeadTimeCalcMethod
ProposalStartDate _ProposedMatlBOM ProposalStartDate
ProposalVersion _ProposedMatlBOM ProposalVersion
CreationDateTime _ProposedMatlBOM CreationDateTime Timestamp
ProposedLeadTime _ProposedMatlBOM ProposedLeadTime
CurrentLeadTime P_CurrentBufferMatlBOM CurrentLeadTime
_BOMCompStsText _BOMCompStsText
_SourceOfSupplyChgdStsTxt _SourceOfSupplyChgdStsTxt
StockLevelProposalID StockLevelProposalID

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_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: PPROPOSEDMATLBOM

CREATE VIEW P_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,
  _ProposedMatlBOM.ComponentPlant AS ComponentPlant,
  _ProposedMatlBOM.ComponentMRPArea AS ComponentMRPArea,
  ProposedLeadTimeCalcMethod,
  _CurrentBOM.CurrentLeadTimeCalcMethod AS CurrentLeadTimeCalcMethod,
  _ProposedMatlBOM.ProposalStartDate AS ProposalStartDate,
  _ProposedMatlBOM.ProposalVersion AS ProposalVersion,
  _ProposedMatlBOM.CreationDateTime AS CreationDateTime,
  _ProposedMatlBOM.ProposedLeadTime AS ProposedLeadTime,
  _CurrentBOM.CurrentLeadTime AS CurrentLeadTime,
  StockLevelProposalID
LEFT OUTER JOIN P_CurrentBufferMatlBOM AS _CurrentBOM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SourceOfSupplyChgdStsTxt AS _SourceOfSupplyChgdStsTxt ON SOSHasChanged = _SourceOfSupplyChgdStsTxt.SOSHasChanged AND _SourceOfSupplyChgdStsTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BOMCompStsText AS _BOMCompStsText ON BOMComponentLeadTimeStatus = _BOMCompStsText.BOMComponentLeadTimeStatus AND _BOMCompStsText.Language = $session.system_language  -- association [1..1]
;

Learn More