C_ProductBOM

DDL: C_PRODUCTBOM SQL: CPRDBOM Type: view CONSUMPTION Package: VDM_MD_PRODUCT
16 Fields 1 Data Sources 3 Associations

Consumption view for Product BOM

C_ProductBOM is a Consumption CDS View that provides data about "Consumption view for Product BOM" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterialTP) and exposes 16 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument. It has 3 associations to related views. Part of development package VDM_MD_PRODUCT.

Data Sources (1)

SourceAliasJoin Type
I_BillOfMaterialTP ProductBOM from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_ProductBOMItem _BillOfMaterialItem $projection.BillOfMaterial = _BillOfMaterialItem.BillOfMaterial and $projection.BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BillOfMaterialItem.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _BillOfMaterialItem.BillOfMaterialVersion and $projection.EngineeringChangeDocument = _BillOfMaterialItem.HeaderChangeDocument and $projection.Material = _BillOfMaterialItem.Product and $projection.Plant = _BillOfMaterialItem.Plant
[0..*] I_ProductText _Text $projection.Material = _Text.Product
[1..1] C_Product _ProductWD $projection.Material = _ProductWD.Product

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CPRDBOM view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Consumption view for Product BOM view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.compositionRoot true view
AccessControl.authorizationCheck #CHECK view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial I_BillOfMaterialTP BillOfMaterial BOM
KEY BillOfMaterialCategory I_BillOfMaterialTP BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant I_BillOfMaterialTP BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion I_BillOfMaterialTP BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument I_BillOfMaterialTP EngineeringChangeDocument Change Number
KEY Material I_BillOfMaterialTP Material Vehicle Model
KEY Plant I_BillOfMaterialTP Plant Valuation Area
MaterialForEdit I_BillOfMaterialTP MaterialForEdit Product
PlantForEdit I_BillOfMaterialTP PlantForEdit Plant ID
ProductName
BOMHeaderBaseUnit I_BillOfMaterialTP BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit I_BillOfMaterialTP BOMHeaderQuantityInBaseUnit Base quantity
AlternativeUnit I_BillOfMaterialTP AlternativeUnit Base UoM
BillOfMaterialVariantUsage I_BillOfMaterialTP BillOfMaterialVariantUsage Usage
_BillOfMaterialItem _BillOfMaterialItem
_ProductWD _ProductWD

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_ProductBOM.
-- 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: CPRDBOM

CREATE VIEW C_ProductBOM AS
SELECT
  ProductBOM.BillOfMaterial AS BillOfMaterial,
  ProductBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  ProductBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  ProductBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  ProductBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  ProductBOM.Material AS Material,
  ProductBOM.Plant AS Plant,
  ProductBOM.MaterialForEdit AS MaterialForEdit,
  ProductBOM.PlantForEdit AS PlantForEdit,
  _Text[1: Language=$session.system_language].ProductName AS ProductName,
  ProductBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  ProductBOM.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  ProductBOM.AlternativeUnit AS AlternativeUnit,
  ProductBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage
FROM I_BillOfMaterialTP AS ProductBOM
LEFT OUTER JOIN C_ProductBOMItem AS _BillOfMaterialItem ON BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterialItem.BillOfMaterialVariant AND BillOfMaterialVersion = _BillOfMaterialItem.BillOfMaterialVersion AND EngineeringChangeDocument = _BillOfMaterialItem.HeaderChangeDocument AND Material = _BillOfMaterialItem.Product AND Plant = _BillOfMaterialItem.Plant  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _Text ON Material = _Text.Product  -- association [0..*]
LEFT OUTER JOIN C_Product AS _ProductWD ON Material = _ProductWD.Product  -- association [1..1]
;

Learn More