What is A_MaintBillOfMaterialItem in SAP S/4HANA?

A_MaintBillOfMaterialItem is a composite CDS view in SAP S/4HANA. Maintenance Bill Of Material Item It contains 91 fields.

Which tables does A_MaintBillOfMaterialItem read from?

A_MaintBillOfMaterialItem reads data from: R_MaintBillOfMaterialItemTP.

What VDM layer is A_MaintBillOfMaterialItem?

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

A_MaintBillOfMaterialItem

DDL: A_MAINTBILLOFMATERIALITEM Type: view_entity COMPOSITE

91 Fields 1 Data Sources 1 Associations

Maintenance Bill Of Material Item

A_MaintBillOfMaterialItem is a Composite CDS View that provides data about "Maintenance Bill Of Material Item" in SAP S/4HANA. It reads from 1 data source (R_MaintBillOfMaterialItemTP) and exposes 91 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, TechnicalObject. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
R_MaintBillOfMaterialItemTP	R_MaintBillOfMaterialItemTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	A_BOMItemCategory	_BOMItemCategory	`$projection.BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	Maintenance Bill Of Material Item	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (91)

Key	Field	Source Table	Source Field	Description
KEY	BillOfMaterial	items	BillOfMaterial	BOM
KEY	BillOfMaterialCategory	items	BillOfMaterialCategory	BOM category
KEY	BillOfMaterialVariant	items	BillOfMaterialVariant	AlternativeBOM
KEY	BillOfMaterialVersion	items	BillOfMaterialVersion	BOM Version
KEY	TechnicalObject	items	TechnicalObject	Technical Object
KEY	Plant	items	Plant	Valuation Area
KEY	EngineeringChangeDocument	items	EngineeringChangeDocument	Change Number
KEY	BillOfMaterialVariantUsage	items	BillOfMaterialVariantUsage	Usage
KEY	BillOfMaterialItemNodeNumber	items	BillOfMaterialItemNodeNumber	Item node
	BillOfMaterialItemUUID	items	BillOfMaterialItemUUID	Guid
	BOMItemInternalChangeCount	items	BOMItemInternalChangeCount	Counter
	ValidityStartDate	items	ValidityStartDate	Validity Start Date
	ValidityEndDate	items	ValidityEndDate	ValidTo
	ChgToEngineeringChgDocument	items	ChgToEngineeringChgDocument	Change No. To
	InheritedNodeNumberForBOMItem	items	InheritedNodeNumberForBOMItem	Nodes
	BOMItemRecordCreationDate	items	BOMItemRecordCreationDate	Created On
	BOMItemCreatedByUser	items	BOMItemCreatedByUser	Created by
	BOMItemLastChangeDate	items	BOMItemLastChangeDate	Changed On
	BOMItemLastChangedByUser	items	BOMItemLastChangedByUser	Changed By
	BillOfMaterialComponent	items	BillOfMaterialComponent	Component
	BillOfMaterialItemCategory	items	BillOfMaterialItemCategory	Item Category
	BillOfMaterialItemNumber	items	BillOfMaterialItemNumber	Item
	BillOfMaterialItemUnit	items	BillOfMaterialItemUnit	Component UoM
	BillOfMaterialItemQuantity	items	BillOfMaterialItemQuantity	Quantity
	IsAssembly	items	IsAssembly	Single-Character Flag
	IsSubItem	items	IsSubItem	Sub-item ID
	BOMItemSorter	items	BOMItemSorter	Sort String
	PurchasingGroup	items	PurchasingGroup	Purchasing Group
	Currency	items	Currency	Valuation Crcy
	MaterialComponentPrice	items	MaterialComponentPrice	Price
	IdentifierBOMItem	items	IdentifierBOMItem	Item ID
	MaterialPriceUnitQty	items	MaterialPriceUnitQty	Price unit
	ComponentScrapInPercent	items	ComponentScrapInPercent	Component Scrap
	OperationScrapInPercent	items	OperationScrapInPercent	Operation Scrap
	IsNetScrap	items	IsNetScrap	Net Indicator
	QuantityVariableSizeItem	items	QuantityVariableSizeItem	VSI Quantity
	FormulaKey	items	FormulaKey	VSI Formula
	ComponentDescription	items	ComponentDescription	Item Text
	BOMItemDescription	items	BOMItemDescription	Item Text
	BOMItemText2	items	BOMItemText2	Item Text
	MaterialGroup	items	MaterialGroup	Product Group
	DocumentType	items	DocumentType	Order Type
	DocNumber	items	DocNumber	Document Number
	DocumentVersion	items	DocumentVersion	Docu. Version
	DocumentPart	items	DocumentPart	Document Part
	ClassNumber	items	ClassNumber	Class
	ClassType	items	ClassType	X Flag
	ResultingItemCategory	items	ResultingItemCategory	Res. item cat.
	DependencyObjectNumber	items	DependencyObjectNumber	Assgmt no.
	ObjectType	items	ObjectType	Type
	IsClassificationRelevant	items	IsClassificationRelevant	as sel. cond.
	IsBulkMaterial	items	IsBulkMaterial	Bulk material
	BOMItemIsSparePart	items	BOMItemIsSparePart	Spare Part ID
	BOMItemIsSalesRelevant	items	BOMItemIsSalesRelevant	Sales
	IsProductionRelevant	items	IsProductionRelevant	Production
	BOMItemIsPlantMaintRelevant	items	BOMItemIsPlantMaintRelevant	Plant maint.
	BOMItemIsCostingRelevant	items	BOMItemIsCostingRelevant	CostingRelevncy
	IsEngineeringRelevant	items	IsEngineeringRelevant	Engineering
	SpecialProcurementType	items	SpecialProcurementType	SpecProcurement
	IsBOMRecursiveAllowed	items	IsBOMRecursiveAllowed	Rec. allowed
	OperationLeadTimeOffset	items	OperationLeadTimeOffset	Oper. LT offset
	OpsLeadTimeOffsetUnit	items	OpsLeadTimeOffsetUnit	Oper. LTO unit
	IsMaterialProvision	items	IsMaterialProvision	Mat. Prov. Ind.
	BOMIsRecursive	items	BOMIsRecursive	Recursive
	DocumentIsCreatedByCAD	items	DocumentIsCreatedByCAD	CAD Indicator
	DistrKeyCompConsumption	items	DistrKeyCompConsumption	Distribution
	DeliveryDurationInDays	items	DeliveryDurationInDays	Del time (days)
	Creditor	items	Creditor	Supplier
	CostElement	items	CostElement	G/L Account
	Size1	items	Size1	Size 1
	Size2	items	Size2	Size 2
	Size3	items	Size3	Size 3
	UnitOfMeasureForSize1To3	items	UnitOfMeasureForSize1To3	Size unit
	GoodsReceiptDuration	items	GoodsReceiptDuration	GR proc. time
	PurchasingOrganization	items	PurchasingOrganization	Purchasing Organization
	RequiredComponent	items	RequiredComponent	Reqd Component
	MultipleSelectionAllowed	items	MultipleSelectionAllowed	Multiple Sel.
	ProdOrderIssueLocation	items	ProdOrderIssueLocation	StorageLocation
	MaterialIsCoProduct	items	MaterialIsCoProduct	Co-product
	ExplosionType	items	ExplosionType	Explosion type
	AlternativeItemGroup	items	AlternativeItemGroup	AltItemGroup
	FollowUpGroup	items	FollowUpGroup	Follow-up group
	DiscontinuationGroup	items	DiscontinuationGroup	Discont. group
	IsConfigurableBOM	items	IsConfigurableBOM	Sel. ind.
	ReferencePoint	items	ReferencePoint	Reference point
	LeadTimeOffset	items	LeadTimeOffset	Lead-tm offset
	ProductionSupplyArea	items	ProductionSupplyArea	Supply Area
	IsDeleted	items	IsDeleted	TRUE
	IsALE	items	IsALE	ALE indicator
	BillOfMaterialHeaderUUID	items	BillOfMaterialHeaderUUID	Guid
	_BOMItemCategory		_BOMItemCategory

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 A_MaintBillOfMaterialItem.
-- 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 A_MaintBillOfMaterialItem AS
SELECT
  items.BillOfMaterial AS BillOfMaterial,
  items.BillOfMaterialCategory AS BillOfMaterialCategory,
  items.BillOfMaterialVariant AS BillOfMaterialVariant,
  items.BillOfMaterialVersion AS BillOfMaterialVersion,
  items.TechnicalObject AS TechnicalObject,
  items.Plant AS Plant,
  items.EngineeringChangeDocument AS EngineeringChangeDocument,
  items.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  items.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  items.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  items.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  items.ValidityStartDate AS ValidityStartDate,
  items.ValidityEndDate AS ValidityEndDate,
  items.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  items.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  items.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  items.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  items.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  items.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  items.BillOfMaterialComponent AS BillOfMaterialComponent,
  items.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  items.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  items.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  items.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  items.IsAssembly AS IsAssembly,
  items.IsSubItem AS IsSubItem,
  items.BOMItemSorter AS BOMItemSorter,
  items.PurchasingGroup AS PurchasingGroup,
  items.Currency AS Currency,
  items.MaterialComponentPrice AS MaterialComponentPrice,
  items.IdentifierBOMItem AS IdentifierBOMItem,
  items.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  items.ComponentScrapInPercent AS ComponentScrapInPercent,
  items.OperationScrapInPercent AS OperationScrapInPercent,
  items.IsNetScrap AS IsNetScrap,
  items.QuantityVariableSizeItem AS QuantityVariableSizeItem,
  items.FormulaKey AS FormulaKey,
  items.ComponentDescription AS ComponentDescription,
  items.BOMItemDescription AS BOMItemDescription,
  items.BOMItemText2 AS BOMItemText2,
  items.MaterialGroup AS MaterialGroup,
  items.DocumentType AS DocumentType,
  items.DocNumber AS DocNumber,
  items.DocumentVersion AS DocumentVersion,
  items.DocumentPart AS DocumentPart,
  items.ClassNumber AS ClassNumber,
  items.ClassType AS ClassType,
  items.ResultingItemCategory AS ResultingItemCategory,
  items.DependencyObjectNumber AS DependencyObjectNumber,
  items.ObjectType AS ObjectType,
  items.IsClassificationRelevant AS IsClassificationRelevant,
  items.IsBulkMaterial AS IsBulkMaterial,
  items.BOMItemIsSparePart AS BOMItemIsSparePart,
  items.BOMItemIsSalesRelevant AS BOMItemIsSalesRelevant,
  items.IsProductionRelevant AS IsProductionRelevant,
  items.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  items.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  items.IsEngineeringRelevant AS IsEngineeringRelevant,
  items.SpecialProcurementType AS SpecialProcurementType,
  items.IsBOMRecursiveAllowed AS IsBOMRecursiveAllowed,
  items.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  items.OpsLeadTimeOffsetUnit AS OpsLeadTimeOffsetUnit,
  items.IsMaterialProvision AS IsMaterialProvision,
  items.BOMIsRecursive AS BOMIsRecursive,
  items.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  items.DistrKeyCompConsumption AS DistrKeyCompConsumption,
  items.DeliveryDurationInDays AS DeliveryDurationInDays,
  items.Creditor AS Creditor,
  items.CostElement AS CostElement,
  items.Size1 AS Size1,
  items.Size2 AS Size2,
  items.Size3 AS Size3,
  items.UnitOfMeasureForSize1To3 AS UnitOfMeasureForSize1To3,
  items.GoodsReceiptDuration AS GoodsReceiptDuration,
  items.PurchasingOrganization AS PurchasingOrganization,
  items.RequiredComponent AS RequiredComponent,
  items.MultipleSelectionAllowed AS MultipleSelectionAllowed,
  items.ProdOrderIssueLocation AS ProdOrderIssueLocation,
  items.MaterialIsCoProduct AS MaterialIsCoProduct,
  items.ExplosionType AS ExplosionType,
  items.AlternativeItemGroup AS AlternativeItemGroup,
  items.FollowUpGroup AS FollowUpGroup,
  items.DiscontinuationGroup AS DiscontinuationGroup,
  items.IsConfigurableBOM AS IsConfigurableBOM,
  items.ReferencePoint AS ReferencePoint,
  items.LeadTimeOffset AS LeadTimeOffset,
  items.ProductionSupplyArea AS ProductionSupplyArea,
  items.IsDeleted AS IsDeleted,
  items.IsALE AS IsALE,
  items.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID
FROM R_MaintBillOfMaterialItemTP
LEFT OUTER JOIN A_BOMItemCategory AS _BOMItemCategory ON BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
;

Depth:

A_MaintBillOfMaterialItem view_entity

R_MaintBillOfMaterialItemTP view_entity