What is A_SalesOrderBOMItem_1 in SAP S/4HANA?

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

Which tables does A_SalesOrderBOMItem_1 read from?

A_SalesOrderBOMItem_1 reads data from: R_SlsOrdBillOfMaterialItemTP.

What VDM layer is A_SalesOrderBOMItem_1?

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

A_SalesOrderBOMItem_1

DDL: A_SALESORDERBOMITEM_1 SQL: AKORDERITEM_1 Type: view_entity COMPOSITE

99 Fields 1 Data Sources 1 Associations

Item

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

SAP Help Documentation

Category	API Views
Status	Released

Purpose
This CDS view provides the prerequisites for answering the following business questions: How to retrieve the order BOM item details from a BOM? What is the order BOM number used in combination with the BOM category to uniquely identify a BOM or a BOM group? What is the BOM category that defines a BOM according to the object (such as material or equipment) to which it is linked? What are the order BOM item categories that define a BOM according to the object (such as material or equipment) to which it is linked? What is the internal change count of order BOM items? Which document info record in the SAP System stores all the business information for a document? Which document types categorize documents according to their distinguishing features and the organizational procedures that result from them? Which document numbers identify the versions of document info record? What document parts are maintained as independent documents? Design departments, for example, can use document parts to divide up large documents such as design drawings into pages. What is the start and end date for the validity period of an object (such as material, BOM, or routing) in the SAP System? What is the end of validity period of an object (such as material, BOM, or routing) in the SAP System? What is the date on which the record was last changed? What is the name of the person who last changed the object? What is the engineering change document associated with the order BOM item? Which order BOM items are marked to show that data of the assembly or component has been distributed to the SAP system using Application Link Enabling (ALE)? Which order BOM items are marked as subitems? Which order BOM items are production, plant, costing, sales, and engineering relevant? Is the order BOM item a spare part? What is the BOM component, BOM item number, and BOM item quantity and unit? Is the order BOM item an assembly? What is the description for an order BOM item? Which order BOM items are marked for deletion with reference to the change number? What is the date on which the record was created and last changed? What is the name of the person who created and who last changed the record? What is the purchasing group of the order BOM item? What is the material component price and currency and material price unit quantity for the order BOM item? What is the BOM component scrap in percentage and operation scrap in percentage? What is the number, quantity, formula key, and size attributes for a variable-size item? What are the keys for design office or laboratory? What is the class number and class type for a class item category? What is the object type and object dependency number? Which are the document info records that are created from CAD Desktop?

Structure
You can access the order BOM item details primarily by filtering on the BOM category, BOM, and the validity start and end date fields. Attributes Some important attributes are: Bill of Material Bill of Material Category Bill of Material Variant Bill of Material Item Node Number Header Change Document Material Plant Bill of Material Variant Usage Bill of Material Item UUID BOM Item Internal Change Count Validity Start Date Validity End Date Engineering Change Document For Edit Engineering Change Document Change To Engineering Change Document Inherited Node Number For BOM Item BOM Item Record Creation Date BOM Item Created By User BOM Item Last Change Date BOM Item Last Changed By User Bill of Material Component Bill of Material Item Category Bill of Material Item Number Bill of Material Item Unit Bill of Material Item Quantity Is Assembly Is Subitem BOM Item Sorter Fixed Quantity BOM Item Has Fixed Quantity Purchasing Group Currency Material Component Price Identifier BOM Item Material Price Unit Quantity Component Scrap In Percent Operation Scrap In Percent Is Net Scrap Number of Variable Size Item Quantity Variable Size Item Formula Key Component Description BOM Item Description BOM Item Text2 Mater

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
R_SlsOrdBillOfMaterialItemTP	R_SlsOrdBillOfMaterialItemTP	projection

Associations (1)

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

Annotations (11)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	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
ObjectModel.sapObjectNodeType.name	SalesBillOfMaterialItem	view

Fields (99)

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
	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
	_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_1.
-- 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: AKORDERITEM_1

CREATE VIEW A_SalesOrderBOMItem_1 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,
  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 R_SlsOrdBillOfMaterialItemTP
LEFT OUTER JOIN A_BOMItemCategory AS _BOMItemCategory ON BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
;

Depth:

A_SalesOrderBOMItem_1 view_entity

R_SlsOrdBillOfMaterialItemTP view_entity