What is I_MaterialBOM in SAP S/4HANA?

I_MaterialBOM is a basic CDS view in SAP S/4HANA. Interface view to expose material and plant with header data It contains 58 fields.

Which tables does I_MaterialBOM read from?

I_MaterialBOM reads data from: I_BillOfMaterial.

What VDM layer is I_MaterialBOM?

I_MaterialBOM is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_MaterialBOM

DDL: I_MATERIALBOM SQL: IMATERIALBOM Type: view BASIC

58 Fields 1 Data Sources 8 Associations

Interface view to expose material and plant with header data

I_MaterialBOM is a Basic CDS View that provides data about "Interface view to expose material and plant with header data" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterial) and exposes 58 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument. It has 8 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BillOfMaterial	bom_header	from

Associations (8)

Cardinality	Target	Alias	Condition
[0..1]	I_VersionStatus	_VersionStatus	`$projection.BOMVersionStatus = _VersionStatus.BOMVersionStatus and _VersionStatus.Language = $session.system_language`
[0..1]	I_Material	_Material	`$projection.Material = _Material.Material`
[0..1]	I_BillOfMaterialUsage	_BillOfMaterialVariantUsage	`$projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage and _BillOfMaterialVariantUsage.Language = $session.system_language`
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[0..1]	I_UnitOfMeasure	_UnitOfMeasure	`$projection.BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure`
[0..*]	I_BomChanges	_BOMChangeNumbers	`$projection.BillOfMaterial = _BOMChangeNumbers.BillOfMaterial and $projection.BillOfMaterialCategory = _BOMChangeNumbers.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BOMChangeNumbers.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _BOMChangeNumbers.BillOfMaterialVersion and $projection.Material = _BOMChangeNumbers.Material and $projection.Plant = _BOMChangeNumbers.Plant and $projection.BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage`
[0..1]	I_ChangeMaster	_ChangeNumbers	`$projection.EngineeringChangeDocument = _ChangeNumbers.ChangeNumber`
[0..1]	I_Product	_Product	`$projection.Material = _Product.Product`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	IMATERIALBOM	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Interface view to expose material and plant with header data	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.writeEnabled	true	view

Fields (58)

Key	Field	Source Table	Source Field	Description
KEY	BillOfMaterialCategory	I_BillOfMaterial	BillOfMaterialCategory	BOM category
KEY	BillOfMaterial	I_BillOfMaterial	BillOfMaterial	BOM
KEY	BillOfMaterialVariant	I_BillOfMaterial	BillOfMaterialVariant	AlternativeBOM
KEY	BillOfMaterialVersion	I_BillOfMaterial	BillOfMaterialVersion	BOM Version
KEY	EngineeringChangeDocument	I_BillOfMaterial	EngineeringChangeDocument	Change Number
KEY	Material	_Mast	Material	Vehicle Model
KEY	Plant	_Mast	Plant	Valuation Area
	BillOfMaterialVariantUsage	I_BillOfMaterial	BillOfMaterialVariantUsage	Usage
	BillOfMaterialHeaderUUID	I_BillOfMaterial	BillOfMaterialHeaderUUID	Guid
	BOMCharUUID
	BillOfMaterialUUID	I_BillOfMaterial	BillOfMaterialUUID	Character Field of Length 12
	IsMultipleBOMAlt	I_BillOfMaterial	IsMultipleBOMAlt	Alt.det. MBOM
	BOMHeaderInternalChangeCount	I_BillOfMaterial	BOMHeaderInternalChangeCount	Counter
	BOMPrioritizedVersion	I_BillOfMaterial	BOMPrioritizedVersion	Selection ID
	BOMExplosionApplication	I_BillOfMaterial	BOMExplosionApplication	BOM Application
	BOMUsagePriority	I_BillOfMaterial	BOMUsagePriority	Sel. priority
	BillOfMaterialAuthsnGrp	I_BillOfMaterial	BillOfMaterialAuthsnGrp	Auth group
	BOMVersionStatus	I_BillOfMaterial	BOMVersionStatus	BOM Version Status
	MaterialToLotSizeQuantity	_Mast	MaterialToLotSizeQuantity	To Lot Size
	MatFromLotSizeQuantity	_Mast	MatFromLotSizeQuantity	From Lot Size
	IsVersionBillOfMaterial	I_BillOfMaterial	IsVersionBillOfMaterial	Versioning Relevant
	IsLatestBOMVersion	I_BillOfMaterial	IsLatestBOMVersion	Latest Rel Version
	BOMTechnicalType	I_BillOfMaterial	BOMTechnicalType	Tech type
	BOMGroup	I_BillOfMaterial	BOMGroup	BOM group
	BOMHeaderText	I_BillOfMaterial	BOMHeaderText	BOM Description
	BOMAlternativeText	I_BillOfMaterial	BOMAlternativeText	Alt Text
	BillOfMaterialStatus	I_BillOfMaterial	BillOfMaterialStatus	BOM Status
	HeaderValidityEndDate	I_BillOfMaterial	HeaderValidityEndDate	to
	HeaderValidityStartDate	I_BillOfMaterial	HeaderValidityStartDate	Valid From
	ChgToEngineeringChgDocument	I_BillOfMaterial	ChgToEngineeringChgDocument	Change No. To
	IsMarkedForDeletion	I_BillOfMaterial	IsMarkedForDeletion	Purch.org. data
	BOMIsArchivedForDeletion	I_BillOfMaterial	BOMIsArchivedForDeletion	Deletion flag
	IsConfiguredMaterial	I_BillOfMaterial	IsConfiguredMaterial	Configured matl
	BOMIsConfigurableasBOMIsConfigurable
	IsALEasIsALE
	BOMHeaderBaseUnit	I_BillOfMaterial	BOMHeaderBaseUnit	Base UoM
	BOMHeaderQuantityInBaseUnit	I_BillOfMaterial	BOMHeaderQuantityInBaseUnit	Base quantity
	RecordCreationDate	I_BillOfMaterial	RecordCreationDate	Created On
	LastChangeDate	I_BillOfMaterial	LastChangeDate	Time Stamp
	LastChangedByUser	I_BillOfMaterial	LastChangedByUser	User Name
	CreatedByUser	I_BillOfMaterial	CreatedByUser	User Name
	BOMIsToBeDeleted	I_BillOfMaterial	BOMIsToBeDeleted	Handling Del. Flag
	DocumentIsCreatedByCAD	I_BillOfMaterial	DocumentIsCreatedByCAD	CAD Indicator
	LaboratoryOrDesignOffice	I_BillOfMaterial	LaboratoryOrDesignOffice	Lab/Office
	LastChangeDateTime	I_BillOfMaterial	LastChangeDateTime	Timestamp
	BOMAssetNtwkHndovrIsRelevant	I_BillOfMaterial	BOMAssetNtwkHndovrIsRelevant	BOM to AIN Handover
	MaterialBOMObjectID	_Mast	MaterialBOMObjectID	MBOM key
	BOMPredecessorVersion			Predecessor Version
	BOMPredecessorVersion	I_BillOfMaterial	BOMPredecessorVersion	Predecessor Version
	IsBOMVersionInactive
	_Material		_Material
	_BillOfMaterialItem		_BillOfMaterialItem
	_BillOfMaterialVariantUsage		_BillOfMaterialVariantUsage
	_VersionStatus		_VersionStatus
	_UnitOfMeasure		_UnitOfMeasure
	_Plant		_Plant
	_BOMChangeNumbers		_BOMChangeNumbers
	_Product		_Product

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_MaterialBOM.
-- 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: IMATERIALBOM

CREATE VIEW I_MaterialBOM AS
SELECT
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  bom_header.BillOfMaterial AS BillOfMaterial,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.BillOfMaterialVersion AS BillOfMaterialVersion,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  _Mast.Material AS Material,
  _Mast.Plant AS Plant,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bom_header.BillOfMaterialUUID AS BillOfMaterialUUID,
  bom_header.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bom_header.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bom_header.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  bom_header.BOMExplosionApplication AS BOMExplosionApplication,
  bom_header.BOMUsagePriority AS BOMUsagePriority,
  bom_header.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  bom_header.BOMVersionStatus AS BOMVersionStatus,
  _Mast.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  _Mast.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  bom_header.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bom_header.IsLatestBOMVersion AS IsLatestBOMVersion,
  bom_header.BOMTechnicalType AS BOMTechnicalType,
  bom_header.BOMGroup AS BOMGroup,
  bom_header.BOMHeaderText AS BOMHeaderText,
  bom_header.BOMAlternativeText AS BOMAlternativeText,
  bom_header.BillOfMaterialStatus AS BillOfMaterialStatus,
  bom_header.HeaderValidityEndDate AS HeaderValidityEndDate,
  bom_header.HeaderValidityStartDate AS HeaderValidityStartDate,
  bom_header.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_header.IsMarkedForDeletion AS IsMarkedForDeletion,
  bom_header.BOMIsArchivedForDeletion AS BOMIsArchivedForDeletion,
  bom_header.IsConfiguredMaterial AS IsConfiguredMaterial,
  bom_header.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bom_header.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bom_header.RecordCreationDate AS RecordCreationDate,
  bom_header.LastChangeDate AS LastChangeDate,
  bom_header.LastChangedByUser AS LastChangedByUser,
  bom_header.CreatedByUser AS CreatedByUser,
  bom_header.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bom_header.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bom_header.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  bom_header.LastChangeDateTime AS LastChangeDateTime,
  bom_header.BOMAssetNtwkHndovrIsRelevant AS BOMAssetNtwkHndovrIsRelevant,
  _Mast.MaterialBOMObjectID AS MaterialBOMObjectID,
  bom_header.BOMPredecessorVersion AS BOMPredecessorVersion
FROM I_BillOfMaterial AS bom_header
LEFT OUTER JOIN I_VersionStatus AS _VersionStatus ON BOMVersionStatus = _VersionStatus.BOMVersionStatus AND _VersionStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- 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_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BomChanges AS _BOMChangeNumbers ON BillOfMaterial = _BOMChangeNumbers.BillOfMaterial AND BillOfMaterialCategory = _BOMChangeNumbers.BillOfMaterialCategory AND BillOfMaterialVariant = _BOMChangeNumbers.BillOfMaterialVariant AND BillOfMaterialVersion = _BOMChangeNumbers.BillOfMaterialVersion AND Material = _BOMChangeNumbers.Material AND Plant = _BOMChangeNumbers.Plant AND BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumbers ON EngineeringChangeDocument = _ChangeNumbers.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
;

Depth:

I_MaterialBOM view

I_BillOfMaterial view