C_ChgRecdObjPgBOMComponent

DDL: C_CHGRECDOBJPGBOMCOMPONENT Type: view_entity CONSUMPTION
41 Fields 1 Data Sources 3 Associations

Bill Of Material Item Consumption

C_ChgRecdObjPgBOMComponent is a Consumption CDS View that provides data about "Bill Of Material Item Consumption" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterialItemTP) and exposes 41 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillOfMaterialItemTP bomitems from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BOMAssembly _Mast $projection.BillOfMaterialComponent = _Mast.Material and $projection.Plant = _Mast.Plant
[0..1] I_BillOfMaterialUsage _BillOfMaterialVariantUsage $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage and _BillOfMaterialVariantUsage.Language = $session.system_language
[0..1] I_CalendarDate _calendar _calendar.CalendarDate = $session.system_date

Annotations (9)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Bill Of Material Item Consumption view
Metadata.allowExtensions true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial
KEY BillOfMaterialCategory I_BillOfMaterialItemTP BillOfMaterialCategory Bill of Material Category
KEY BillOfMaterialVariant I_BillOfMaterialItemTP BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion I_BillOfMaterialItemTP BillOfMaterialVersion BOM Version
KEY BillOfMaterialItemNodeNumber I_BillOfMaterialItemTP BillOfMaterialItemNodeNumber Item Node Number
KEY HeaderChangeDocument I_BillOfMaterialItemTP HeaderChangeDocument Change Number
KEY Material I_BillOfMaterialItemTP Material Vehicle Model
KEY Plant I_BillOfMaterialItemTP Plant Valuation Area
ValidityStartDateendasValidityStartDate
ValidityEndDate I_BillOfMaterialItemTP ValidityEndDate Valid To
BillOfMaterialItemUUID I_BillOfMaterialItemTP BillOfMaterialItemUUID ID for Item Change Status
ChangeNumber I_BillOfMaterialItemTP EngineeringChangeDocForEdit Change Number
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID ID for BOM Header Change Status
BOMItemRecordCreationDate I_BillOfMaterialItemTP BOMItemRecordCreationDate Created On
BOMItemCreatedByUser I_BillOfMaterialItemTP BOMItemCreatedByUser Created By
BOMItemLastChangeDate I_BillOfMaterialItemTP BOMItemLastChangeDate Changed On
BOMItemLastChangedByUser I_BillOfMaterialItemTP BOMItemLastChangedByUser Changed By
BillOfMaterialComponent I_BillOfMaterialItemTP BillOfMaterialComponent Component
PreliminaryMaterial I_BillOfMaterialItemTP PreliminaryMaterial Description
ComponentDescription I_BillOfMaterialItemTP ComponentDescription Component Description
BillOfMaterialItemCategory I_BillOfMaterialItemTP BillOfMaterialItemCategory Item Category
BillOfMaterialItemNumber
BillOfMaterialItemUnit I_BillOfMaterialItemTP BillOfMaterialItemUnit Component UoM
BillOfMaterialItemQuantity I_BillOfMaterialItemTP BillOfMaterialItemQuantity Quantity
IsAssembly I_BillOfMaterialItemTP IsAssembly Single-Character Flag
IsSubItem I_BillOfMaterialItemTP IsSubItem Sub-item ID
IdentifierBOMItem I_BillOfMaterialItemTP IdentifierBOMItem Item Identification
BOMItemDescription I_BillOfMaterialItemTP BOMItemDescription Item Text
BillOfMaterialItemCategoryDesc BillOfMaterialItemCategoryDesc Item Category Text
BillOfMaterialVariantUsage I_BillOfMaterialItemTP BillOfMaterialVariantUsage Usage
BillOfMaterialVariantUsageDesc _BillOfMaterialVariantUsage BillOfMaterialVariantUsageDesc
PlantName
BOMIsSubItemSupported _BOMItemCategory BOMIsSubItemSupported
Creditor I_BillOfMaterialItemTP Creditor Supplier
IsBusinessPurposeCompleted _SupplierVH IsBusinessPurposeCompleted Purpose Completed
_BOMItemCategory _BOMItemCategory
_Material _Material
_MaterialText _MaterialText
_UnitOfMeasure _UnitOfMeasure
_Mast _Mast
_SupplierVH _SupplierVH

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_ChgRecdObjPgBOMComponent.
-- 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 C_ChgRecdObjPgBOMComponent AS
SELECT
  cast( bomitems.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  bomitems.BillOfMaterialCategory AS BillOfMaterialCategory,
  bomitems.BillOfMaterialVariant AS BillOfMaterialVariant,
  bomitems.BillOfMaterialVersion AS BillOfMaterialVersion,
  bomitems.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  bomitems.HeaderChangeDocument AS HeaderChangeDocument,
  bomitems.Material AS Material,
  bomitems.Plant AS Plant,
  case when bomitems.ValidityStartDate is initial then _calendar.CalendarDate else bomitems.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  bomitems.ValidityEndDate AS ValidityEndDate,
  bomitems.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  bomitems.EngineeringChangeDocForEdit AS ChangeNumber,
  BillOfMaterialHeaderUUID,
  bomitems.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  bomitems.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  bomitems.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  bomitems.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  bomitems.BillOfMaterialComponent AS BillOfMaterialComponent,
  bomitems.PreliminaryMaterial AS PreliminaryMaterial,
  bomitems.ComponentDescription AS ComponentDescription,
  bomitems.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  cast( bomitems.BillOfMaterialItemNumber as cs_sposn preserving type ) AS BillOfMaterialItemNumber,
  bomitems.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  bomitems.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  bomitems.IsAssembly AS IsAssembly,
  bomitems.IsSubItem AS IsSubItem,
  bomitems.IdentifierBOMItem AS IdentifierBOMItem,
  bomitems.BOMItemDescription AS BOMItemDescription,
  BillOfMaterialItemCategoryDesc,
  bomitems.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  _BillOfMaterial._Plant.PlantName AS PlantName,
  _BOMItemCategory.BOMIsSubItemSupported AS BOMIsSubItemSupported,
  bomitems.Creditor AS Creditor,
  _SupplierVH.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_BillOfMaterialItemTP AS bomitems
LEFT OUTER JOIN I_BOMAssembly AS _Mast ON BillOfMaterialComponent = _Mast.Material AND Plant = _Mast.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialVariantUsage ON BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage AND _BillOfMaterialVariantUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _calendar ON _calendar.CalendarDate = $session.system_date  -- association [0..1]
;

Learn More