What is C_BOMwhereUsed in SAP S/4HANA?

C_BOMwhereUsed is a consumption CDS view in SAP S/4HANA. Consumption View for Material Where-Used It contains 37 fields.

Which tables does C_BOMwhereUsed read from?

C_BOMwhereUsed reads data from: I_BillOfMaterialItemTP.

What VDM layer is C_BOMwhereUsed?

C_BOMwhereUsed is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BOMwhereUsed

DDL: C_BOMWHEREUSED SQL: CBOMWHEREUSED Type: view CONSUMPTION

37 Fields 1 Data Sources 5 Associations

Consumption View for Material Where-Used

C_BOMwhereUsed is a Consumption CDS View that provides data about "Consumption View for Material Where-Used" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterialItemTP) and exposes 37 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BillOfMaterialItemTP	bomitems	from

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	C_BOMWhereUsedHeader	_BillOfMaterial	`$projection.BillOfMaterial = _BillOfMaterial.BillOfMaterial and $projection.BillOfMaterialCategory = _BillOfMaterial.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _BillOfMaterial.BillOfMaterialVersion and $projection.HeaderChangeDocument = _BillOfMaterial.EngineeringChangeDocument and $projection.Material = _BillOfMaterial.Material and $projection.Plant = _BillOfMaterial.Plant`
[0..1]	I_MaterialText	_MaterialText	`$projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language`
[0..1]	I_BillOfMaterialUsage	_BillOfMaterialUsage	`$projection.BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage and _BillOfMaterialUsage.Language = $session.system_language`
[0..1]	I_PlantStdVH	_Plants	`$projection.Plant = _Plants.Plant`
[0..1]	I_ChangeMaster	_ChangeNumbers	`$projection.EngineeringChangeDocument = _ChangeNumbers.ChangeNumber`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	CBOMWHEREUSED	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Search.searchable	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
EndUserText.label	Consumption View for Material Where-Used	view
Consumption.filter.businessDate.at	true	view

Fields (37)

Key	Field	Source Table	Source Field	Description
KEY	BillOfMaterial	I_BillOfMaterialItemTP	BillOfMaterial	BOM
KEY	BillOfMaterialCategory	I_BillOfMaterialItemTP	BillOfMaterialCategory	BOM 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	Header Change Number
KEY	Material	I_BillOfMaterialItemTP	Material	Vehicle Model
KEY	Plant	I_BillOfMaterialItemTP	Plant	Valuation Area
	BillOfMaterialVariantUsage	I_BillOfMaterialItemTP	BillOfMaterialVariantUsage	Usage
	BillOfMaterialComponent	I_BillOfMaterialItemTP	BillOfMaterialComponent	Component
	BOMComponentForEdit	I_BillOfMaterialItemTP	BOMComponentForEdit	Component
	MaterialName	_MaterialText	MaterialName	Material Description
	PlantName	_Plants	PlantName	Plant Name
	BillOfMaterialItemUUID	I_BillOfMaterialItemTP	BillOfMaterialItemUUID	Guid
	BillOfMaterialItemNumber	I_BillOfMaterialItemTP	BillOfMaterialItemNumber	Item
	BillOfMaterialVariantUsageDesc	_BillOfMaterialUsage	BillOfMaterialVariantUsageDesc	Usage Text
	BillOfMaterialItemCategory	I_BillOfMaterialItemTP	BillOfMaterialItemCategory	Item Category
	BOMVersionStatus	_BillOfMaterial	BOMVersionStatus	BOM Version Status Code
	BOMVersionStatusDescription	_BillOfMaterial	BOMVersionStatusDescription	BOM Version Status
	BillOfMaterialItemQuantity	I_BillOfMaterialItemTP	BillOfMaterialItemQuantity	Quantity
	BillOfMaterialItemUnit
	EngineeringChangeDocument	I_BillOfMaterialItemTP	EngineeringChangeDocument	Component Change Number
	ValidityStartDate	I_BillOfMaterialItemTP	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_BillOfMaterialItemTP	ValidityEndDate	Valid To
	BOMItemDescription	I_BillOfMaterialItemTP	BOMItemDescription	Item Text
	BOMItemText2	I_BillOfMaterialItemTP	BOMItemText2	Item Text
	BillOfMaterialItemCategoryDesc	_BOMItemCategory	BillOfMaterialItemCategoryDesc	Item Category Text
	BillOfMaterialHeaderUUID	_BillOfMaterial	BillOfMaterialHeaderUUID	Guid
	IsLatestBOMVersion
	IsVersionBillOfMaterial
	_BillOfMaterial		_BillOfMaterial
	_Plants		_Plants
	_BillOfMaterialUsage		_BillOfMaterialUsage
	_UnitOfMeasure		_UnitOfMeasure
	_ChangeNumbers		_ChangeNumbers
	_BOMItemCategory		_BOMItemCategory
	_Material		_Material

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_BOMwhereUsed.
-- 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: CBOMWHEREUSED

CREATE VIEW C_BOMwhereUsed AS
SELECT
  bomitems.BillOfMaterial 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,
  bomitems.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bomitems.BillOfMaterialComponent AS BillOfMaterialComponent,
  bomitems.BOMComponentForEdit AS BOMComponentForEdit,
  _MaterialText.MaterialName AS MaterialName,
  _Plants.PlantName AS PlantName,
  bomitems.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  bomitems.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  _BillOfMaterialUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  bomitems.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  _BillOfMaterial.BOMVersionStatus AS BOMVersionStatus,
  _BillOfMaterial.BOMVersionStatusDescription AS BOMVersionStatusDescription,
  bomitems.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  bomitems.EngineeringChangeDocument AS EngineeringChangeDocument,
  bomitems.ValidityStartDate AS ValidityStartDate,
  bomitems.ValidityEndDate AS ValidityEndDate,
  bomitems.BOMItemDescription AS BOMItemDescription,
  bomitems.BOMItemText2 AS BOMItemText2,
  _BOMItemCategory.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  _BillOfMaterial.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID
FROM I_BillOfMaterialItemTP AS bomitems
LEFT OUTER JOIN C_BOMWhereUsedHeader AS _BillOfMaterial ON BillOfMaterial = _BillOfMaterial.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterial.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant AND BillOfMaterialVersion = _BillOfMaterial.BillOfMaterialVersion AND HeaderChangeDocument = _BillOfMaterial.EngineeringChangeDocument AND Material = _BillOfMaterial.Material AND Plant = _BillOfMaterial.Plant  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialUsage ON BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage AND _BillOfMaterialUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _Plants ON Plant = _Plants.Plant  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumbers ON EngineeringChangeDocument = _ChangeNumbers.ChangeNumber  -- association [0..1]
;

Depth:

C_BOMwhereUsed view

I_BillOfMaterialItemTP view