CIC_BOM_ITEM

DDL: CIC_BOM_ITEM Type: view_entity
12 Fields 1 Data Sources

Bill of Material Item

CIC_BOM_ITEM is a CDS View that provides data about "Bill of Material Item" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterialItem) and exposes 12 fields with key fields Category, BillOfMaterial, Variant, ItemNodeNumber.

Data Sources (1)

SourceAliasJoin Type
I_BillOfMaterialItem _item from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bill of Material Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Category
KEY BillOfMaterial I_BillOfMaterialItem BillOfMaterial BOM
KEY Variant I_BillOfMaterialItem BillOfMaterialVariant AlternativeBOM
KEY ItemNodeNumber I_BillOfMaterialItem BillOfMaterialItemNodeNumber Item node
ItemCategory I_BillOfMaterialItem BillOfMaterialItemCategory Item Category
ItemNumber I_BillOfMaterialItem BillOfMaterialItemNumber Item
Component I_BillOfMaterialItem BillOfMaterialComponent Component
BillOfMaterialVersion I_BillOfMaterialItem BillOfMaterialVersion BOM Version
ItemQuantity I_BillOfMaterialItem BillOfMaterialItemQuantity Quantity
ItemUnit I_BillOfMaterialItem BillOfMaterialItemUnit Component UoM
ValidityStartDate I_BillOfMaterialItem ValidityStartDate Validity Start Date
ValidityEndDate I_BillOfMaterialItem ValidityEndDate ValidTo

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 CIC_BOM_ITEM.
-- 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 CIC_BOM_ITEM AS
SELECT
  cast( 'product' as char7 preserving type ) AS Category,
  _item.BillOfMaterial AS BillOfMaterial,
  _item.BillOfMaterialVariant AS Variant,
  _item.BillOfMaterialItemNodeNumber AS ItemNodeNumber,
  _item.BillOfMaterialItemCategory AS ItemCategory,
  _item.BillOfMaterialItemNumber AS ItemNumber,
  _item.BillOfMaterialComponent AS Component,
  _item.BillOfMaterialVersion AS BillOfMaterialVersion,
  _item.BillOfMaterialItemQuantity AS ItemQuantity,
  _item.BillOfMaterialItemUnit AS ItemUnit,
  _item.ValidityStartDate AS ValidityStartDate,
  _item.ValidityEndDate AS ValidityEndDate
FROM I_BillOfMaterialItem AS _item
;

Learn More