What is A_SalesOrderBOMItem in SAP S/4HANA?

A_SalesOrderBOMItem is a composite CDS view in SAP S/4HANA. Item It contains 101 fields.

Which tables does A_SalesOrderBOMItem read from?

A_SalesOrderBOMItem reads data from: I_OrderBillOfMaterialItemAPITP.

What VDM layer is A_SalesOrderBOMItem?

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

A_SalesOrderBOMItem

DDL: A_SALESORDERBOMITEM SQL: AKOMITEMAPITP Type: view_entity COMPOSITE

101 Fields 1 Data Sources 1 Associations

Item

A_SalesOrderBOMItem is a Composite CDS View that provides data about "Item" in SAP S/4HANA. It reads from 1 data source (I_OrderBillOfMaterialItemAPITP) and exposes 101 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialItemNodeNumber, HeaderChangeDocument. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_OrderBillOfMaterialItemAPITP	I_OrderBillOfMaterialItemAPITP	from

Associations (1)

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

Annotations (10)

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

Fields (101)

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

CREATE VIEW A_SalesOrderBOMItem AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialItemNodeNumber,
  HeaderChangeDocument,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  BillOfMaterialItemUUID,
  BOMItemInternalChangeCount,
  ValidityStartDate,
  ValidityEndDate,
  EngineeringChangeDocForEdit,
  EngineeringChangeDocument,
  ChgToEngineeringChgDocument,
  InheritedNodeNumberForBOMItem,
  BOMItemRecordCreationDate,
  BOMItemCreatedByUser,
  BOMItemLastChangeDate,
  BOMItemLastChangedByUser,
  BillOfMaterialComponent,
  BillOfMaterialItemCategory,
  BillOfMaterialItemNumber,
  BillOfMaterialItemUnit,
  BillOfMaterialItemQuantity,
  IsAssembly,
  IsSubItem,
  BOMItemSorter,
  FixedQuantity,
  BOMItemHasFixedQuantity,
  PurchasingGroup,
  Currency,
  MaterialComponentPrice,
  IdentifierBOMItem,
  MaterialPriceUnitQty,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  IsNetScrap,
  NumberOfVariableSizeItem,
  QuantityVariableSizeItem,
  FormulaKey,
  ComponentDescription,
  BOMItemDescription,
  BOMItemText2,
  MaterialGroup,
  DocumentType,
  DocNumber,
  DocumentVersion,
  DocumentPart,
  ClassNumber,
  ClassType,
  ResultingItemCategory,
  DependencyObjectNumber,
  ObjectType,
  IsClassificationRelevant,
  IsBulkMaterial,
  BOMItemIsSparePart,
  BOMItemIsSalesRelevant,
  IsProductionRelevant,
  BOMItemIsPlantMaintRelevant,
  BOMItemIsCostingRelevant,
  IsEngineeringRelevant,
  SpecialProcurementType,
  IsBOMRecursiveAllowed,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  IsMaterialProvision,
  BOMIsRecursive,
  DocumentIsCreatedByCAD,
  DistrKeyCompConsumption,
  DeliveryDurationInDays,
  Creditor,
  CostElement,
  Size1,
  Size2,
  Size3,
  UnitOfMeasureForSize1To3,
  GoodsReceiptDuration,
  PurchasingOrganization,
  RequiredComponent,
  MultipleSelectionAllowed,
  ProdOrderIssueLocation,
  MaterialIsCoProduct,
  ExplosionType,
  AlternativeItemGroup,
  AlternativeItemPriority,
  AlternativeItemStrategy,
  UsageProbabilityPercent,
  FollowUpGroup,
  DiscontinuationGroup,
  IsConfigurableBOM,
  ReferencePoint,
  LeadTimeOffset,
  ProductionSupplyArea,
  IsDeleted,
  IsALE,
  LastChangeDateTime,
  SalesOrder,
  SalesOrderItem
FROM I_OrderBillOfMaterialItemAPITP
LEFT OUTER JOIN A_BOMItemCategory AS _BOMItemCategory ON BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
;

Depth:

A_SalesOrderBOMItem view_entity

I_OrderBillOfMaterialItemAPITP view