What is I_Bomwhereused in SAP S/4HANA?

I_Bomwhereused is a composite CDS view in SAP S/4HANA. Interface view for single level where used list It contains 27 fields.

What VDM layer is I_Bomwhereused?

I_Bomwhereused is classified as a Composite view that combines data from multiple basic views.

I_Bomwhereused

Q: Which tables does I_Bomwhereused read from?

I_Bomwhereused reads data from: I_DraftAdministrativeData, I_BOMItemHdrChangeState, I_BillOfMaterialItemDraftTP.

DDL: I_BOMWHEREUSED SQL: IBOMWHEREUSED Type: view COMPOSITE

27 Fields 3 Data Sources 1 Associations

Interface view for single level where used list

I_Bomwhereused is a Composite CDS View that provides data about "Interface view for single level where used list" in SAP S/4HANA. It reads from 3 data sources (I_DraftAdministrativeData, I_BOMItemHdrChangeState, I_BillOfMaterialItemDraftTP) and exposes 27 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. It has 1 association to related views.

Data Sources (3)

Source	Alias	Join Type
I_DraftAdministrativeData	_DraftAdministrativeData	left_outer
I_BOMItemHdrChangeState	bomitems	from
I_BillOfMaterialItemDraftTP	item_draft	left_outer

Associations (1)

Cardinality	Target	Alias	Condition
[1..*]	I_MaterialBOM	_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`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	IBOMWHEREUSED	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.authorizationCheck	#NOT_ALLOWED	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	Interface view for single level where used list	view

Fields (27)

Key	Field	Source Table	Source Field	Description
KEY	BillOfMaterial	I_BOMItemHdrChangeState	BillOfMaterial	BOM
KEY	BillOfMaterialCategory	I_BOMItemHdrChangeState	BillOfMaterialCategory	BOM category
KEY	BillOfMaterialVariant	I_BOMItemHdrChangeState	BillOfMaterialVariant	AlternativeBOM
KEY	BillOfMaterialVersion	I_BOMItemHdrChangeState	BillOfMaterialVersion	BOM Version
KEY	BillOfMaterialItemNodeNumber	I_BOMItemHdrChangeState	BillOfMaterialItemNodeNumber	Item node
KEY	HeaderChangeDocument	I_BOMItemHdrChangeState	HeaderChangeDocument	Change Number
KEY	Material	I_BOMItemHdrChangeState	Material	Vehicle Model
KEY	Plant	I_BOMItemHdrChangeState	Plant	Valuation Area
	BillOfMaterialItemUUID	I_BOMItemHdrChangeState	BillOfMaterialItemUUID	Guid
	BillOfMaterialComponent	I_BOMItemHdrChangeState	BillOfMaterialComponent	Component
	BillOfMaterialItemNumber	I_BOMItemHdrChangeState	BillOfMaterialItemNumber	Item
	ParentDraftUUID	I_BillOfMaterialItemDraftTP	ParentDraftUUID	NodeID
	BillOfMaterialItemCategory	I_BOMItemHdrChangeState	BillOfMaterialItemCategory	Item Category
	BillOfMaterialItemUnit	I_BOMItemHdrChangeState	BillOfMaterialItemUnit	Component UoM
	BillOfMaterialItemQuantity	I_BOMItemHdrChangeState	BillOfMaterialItemQuantity	Quantity
	ValidityStartDate	I_BOMItemHdrChangeState	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_BOMItemHdrChangeState	ValidityEndDate	ValidTo
	BOMItemDescription	I_BOMItemHdrChangeState	BOMItemDescription	Item Text
	MaterialName
	PlantName
	BillOfMaterialVariantUsageDesc
	BillOfMaterialVariantUsage	I_BOMItemHdrChangeState	BillOfMaterialVariantUsage	Usage
	BOMVersionStatus	_BillOfMaterial	BOMVersionStatus	BOM Version Status
	BOMVersionStatusDescription
	_UnitOfMeasure	I_BOMItemHdrChangeState	_UnitOfMeasure
	BillOfMaterialHeaderUUID	I_BOMItemHdrChangeState	BillOfMaterialHeaderUUID	Guid
	IsVersionBillOfMaterial	I_BOMItemHdrChangeState	IsVersionBillOfMaterial	Versioning Relevant

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 I_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: IBOMWHEREUSED

CREATE VIEW I_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.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  bomitems.BillOfMaterialComponent AS BillOfMaterialComponent,
  bomitems.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  item_draft.ParentDraftUUID AS ParentDraftUUID,
  bomitems.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  bomitems.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  bomitems.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  bomitems.ValidityStartDate AS ValidityStartDate,
  bomitems.ValidityEndDate AS ValidityEndDate,
  bomitems.BOMItemDescription AS BOMItemDescription,
  _BillOfMaterial._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  _BillOfMaterial._Plant.PlantName AS PlantName,
  _BillOfMaterial._BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  bomitems.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _BillOfMaterial.BOMVersionStatus AS BOMVersionStatus,
  _BillOfMaterial._VersionStatus.BOMVersionStatusDescription AS BOMVersionStatusDescription,
  bomitems._UnitOfMeasure AS _UnitOfMeasure,
  bomitems.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bomitems.IsVersionBillOfMaterial AS IsVersionBillOfMaterial
FROM I_BOMItemHdrChangeState AS bomitems
LEFT OUTER JOIN I_BillOfMaterialItemDraftTP AS item_draft ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialBOM 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..*]
;

Depth:

I_Bomwhereused view