A_StockLevelPrpslBOM

DDL: A_STOCKLEVELPRPSLBOM Type: view_entity COMPOSITE Package: ODATA_PP_DD_BUFFERSIZING_API
22 Fields 2 Data Sources 1 OData Services

Longest Path in BOM

A_StockLevelPrpslBOM is a Composite CDS View that provides data about "Longest Path in BOM" in SAP S/4HANA. It reads from 2 data sources (I_StockLevelPrpslBOM, A_ProductBufferSizing) and exposes 22 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion. It is exposed through 1 OData service (API_BUFFERSIZING_SRV). Part of development package ODATA_PP_DD_BUFFERSIZING_API.

Data Sources (2)

SourceAliasJoin Type
I_StockLevelPrpslBOM _BOMProposal left_outer
A_ProductBufferSizing _ProdBufLvlPrpslData from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Longest Path in BOM view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_BUFFERSIZING_SRV API_BUFFERSIZING_SRV V2 C2 C1

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Material A_ProductBufferSizing Material Vehicle Model
KEY Plant A_ProductBufferSizing Plant Valuation Area
KEY MRPArea A_ProductBufferSizing MRPArea MRP Area
KEY ProposalStartDate A_ProductBufferSizing ProposalStartDate
KEY ProposalVersion A_ProductBufferSizing ProposalVersion
KEY BillOfMaterialUUID I_StockLevelPrpslBOM BillOfMaterialUUID Character Field of Length 12
KEY ParentComponent I_StockLevelPrpslBOM ParentComponent Parent BOM Comp
KEY ParentPlant I_StockLevelPrpslBOM ParentPlant Parent Plant
KEY BillOfMaterialComponent I_StockLevelPrpslBOM BillOfMaterialComponent Component
KEY ComponentPlant I_StockLevelPrpslBOM ComponentPlant Component Plant
ParentMRPArea I_StockLevelPrpslBOM ParentMRPArea Parent MRP Area
ComponentMRPArea I_StockLevelPrpslBOM ComponentMRPArea Component MRP Area
ComponentLeadTime I_StockLevelPrpslBOM ComponentLeadTime Individual Lead Time
LeadTimeCalculationMethod I_StockLevelPrpslBOM LeadTimeCalculationMethod
ComponentSOS I_StockLevelPrpslBOM ComponentSOS Source of Supply
ComponentSOSType I_StockLevelPrpslBOM ComponentSOSType Source Type
SOSTypeDescription I_StockLevelPrpslBOM SOSTypeDescription
CreatedByUser I_StockLevelPrpslBOM CreatedByUser User Name
LastChangedByUser I_StockLevelPrpslBOM LastChangedByUser User Name
CreationDateTime I_StockLevelPrpslBOM CreationDateTime Timestamp
LastChangeDateTime I_StockLevelPrpslBOM LastChangeDateTime Timestamp
_ProposalHdr _ProposalHdr

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 A_StockLevelPrpslBOM.
-- 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.

CREATE VIEW A_StockLevelPrpslBOM AS
SELECT
  _ProdBufLvlPrpslData.Material AS Material,
  _ProdBufLvlPrpslData.Plant AS Plant,
  _ProdBufLvlPrpslData.MRPArea AS MRPArea,
  _ProdBufLvlPrpslData.ProposalStartDate AS ProposalStartDate,
  _ProdBufLvlPrpslData.ProposalVersion AS ProposalVersion,
  _BOMProposal.BillOfMaterialUUID AS BillOfMaterialUUID,
  _BOMProposal.ParentComponent AS ParentComponent,
  _BOMProposal.ParentPlant AS ParentPlant,
  _BOMProposal.BillOfMaterialComponent AS BillOfMaterialComponent,
  _BOMProposal.ComponentPlant AS ComponentPlant,
  _BOMProposal.ParentMRPArea AS ParentMRPArea,
  _BOMProposal.ComponentMRPArea AS ComponentMRPArea,
  _BOMProposal.ComponentLeadTime AS ComponentLeadTime,
  _BOMProposal.LeadTimeCalculationMethod AS LeadTimeCalculationMethod,
  _BOMProposal.ComponentSOS AS ComponentSOS,
  _BOMProposal.ComponentSOSType AS ComponentSOSType,
  _BOMProposal.SOSTypeDescription AS SOSTypeDescription,
  _BOMProposal.CreatedByUser AS CreatedByUser,
  _BOMProposal.LastChangedByUser AS LastChangedByUser,
  _BOMProposal.CreationDateTime AS CreationDateTime,
  _BOMProposal.LastChangeDateTime AS LastChangeDateTime
FROM A_ProductBufferSizing AS _ProdBufLvlPrpslData
LEFT OUTER JOIN I_StockLevelPrpslBOM AS _BOMProposal ON /* join condition not captured in parsed metadata */
;

Learn More