What is R_BillOfMaterialItemTP in SAP S/4HANA?

R_BillOfMaterialItemTP is a transactional CDS view in SAP S/4HANA. Bill of Material Item It contains 105 fields.

Which tables does R_BillOfMaterialItemTP read from?

R_BillOfMaterialItemTP reads data from: I_BOMItemHdrChangeState.

What VDM layer is R_BillOfMaterialItemTP?

R_BillOfMaterialItemTP is classified as a Transactional view that supports create, update, and delete operations.

R_BillOfMaterialItemTP

DDL: R_BILLOFMATERIALITEMTP SQL: IBOMITEMSAPITP Type: view_entity TRANSACTIONAL

105 Fields 1 Data Sources 7 Associations

Bill of Material Item

R_BillOfMaterialItemTP is a Transactional CDS View that provides data about "Bill of Material Item" in SAP S/4HANA. It reads from 1 data source (I_BOMItemHdrChangeState) and exposes 105 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BOMItemHdrChangeState	I_BOMItemHdrChangeState	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	I_MultiLevelBOM	_MultilevelBOM	`$projection.BillOfMaterialComponent = _MultilevelBOM.Material and $projection.Plant = _MultilevelBOM.Plant`
[0..1]	I_BillOfMaterialItemCategory	_BOMItemCategory	`$projection.BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory`
[0..1]	I_BillOfMaterialUsage	_BillOfMaterialUsage	`$projection.BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage and _BillOfMaterialUsage.Language = $session.system_language`
[0..1]	I_ChangeMaster	_ChangeNumber	`$projection.EngineeringChangeDocForEdit = _ChangeNumber.ChangeNumber ----Extension`
[1..1]	E_BillOfMaterialItemTP	_BillOfMaterialItemExtension	`$projection.BillOfMaterial = _BillOfMaterialItemExtension.BillOfMaterial and $projection.BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory and $projection.BillOfMaterialItemNodeNumber = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount`
[0..*]	R_BOMItmObjDpnAssignmentTP	_BOMItmObjDependencyAssignment
[0..*]	R_BillOfMaterialSubitemTP	_BOMSubItems

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Bill of Material Item	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
VDM.viewType	#TRANSACTIONAL	view

Fields (105)

Key	Field	Source Field	Description
KEY	BillOfMaterial		BOM
KEY	BillOfMaterialCategory	BillOfMaterialCategory	BOM category
KEY	BillOfMaterialVariant	BillOfMaterialVariant	AlternativeBOM
KEY	BillOfMaterialVersion	BillOfMaterialVersion	BOM Version
KEY	BillOfMaterialItemNodeNumber	BillOfMaterialItemNodeNumber	Item node
KEY	HeaderChangeDocument	HeaderChangeDocument	Change Number
KEY	Material	Material	Vehicle Model
KEY	Plant	Plant	Valuation Area
	BillOfMaterialItemUUID	BillOfMaterialItemUUID	Guid
	BillOfMaterialHeaderUUID	BillOfMaterialHeaderUUID	Guid
	BOMItemInternalChangeCount	BOMItemInternalChangeCount	Counter
	ValidityStartDate	ValidityStartDate	Validity Start Date
	ValidityEndDate	ValidityEndDate	ValidTo
	EngineeringChangeDocForEdit	EngineeringChangeDocument	Change Number
	EngineeringChangeDocument	EngineeringChangeDocument	Change Number
	BillOfMaterialVariantUsage	BillOfMaterialVariantUsage	Usage
	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		Item
	BillOfMaterialItemUnit	BillOfMaterialItemUnit	Component UoM
	BillOfMaterialItemQuantity	BillOfMaterialItemQuantity	Quantity
	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
	VariableSizeItemQuantity	NumberOfVariableSizeItem	Number Required
	VariableSizeCompUnitOfMeasure	VariableSizeCompUnitOfMeasure	VSI unit
	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
	PreliminaryComponent	PreliminaryMaterial	Description
	_BillOfMaterial	_BillOfMaterial
	_BOMItemCategory	_BOMItemCategory
	_BOMItmObjDependencyAssignment	_BOMItmObjDependencyAssignment
	_BOMSubItems	_BOMSubItems
	_BillOfMaterialUsage	_BillOfMaterialUsage
	_ChangeNumber	_ChangeNumber

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 R_BillOfMaterialItemTP.
-- 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: IBOMITEMSAPITP

CREATE VIEW R_BillOfMaterialItemTP AS
SELECT
  cast( BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  HeaderChangeDocument,
  Material,
  Plant,
  BillOfMaterialItemUUID,
  BillOfMaterialHeaderUUID,
  BOMItemInternalChangeCount,
  ValidityStartDate,
  ValidityEndDate,
  EngineeringChangeDocument AS EngineeringChangeDocForEdit,
  EngineeringChangeDocument,
  BillOfMaterialVariantUsage,
  ChgToEngineeringChgDocument,
  InheritedNodeNumberForBOMItem,
  BOMItemRecordCreationDate,
  BOMItemCreatedByUser,
  BOMItemLastChangeDate,
  BOMItemLastChangedByUser,
  BillOfMaterialComponent,
  BillOfMaterialItemCategory,
  cast( BillOfMaterialItemNumber as cs_sposn preserving type ) AS BillOfMaterialItemNumber,
  BillOfMaterialItemUnit,
  BillOfMaterialItemQuantity,
  IsSubItem,
  BOMItemSorter,
  FixedQuantity,
  BOMItemHasFixedQuantity,
  PurchasingGroup,
  Currency,
  MaterialComponentPrice,
  IdentifierBOMItem,
  MaterialPriceUnitQty,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  IsNetScrap,
  NumberOfVariableSizeItem AS VariableSizeItemQuantity,
  VariableSizeCompUnitOfMeasure,
  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,
  PreliminaryMaterial AS PreliminaryComponent
FROM I_BOMItemHdrChangeState
LEFT OUTER JOIN I_MultiLevelBOM AS _MultilevelBOM ON BillOfMaterialComponent = _MultilevelBOM.Material AND Plant = _MultilevelBOM.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialUsage ON BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage AND _BillOfMaterialUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON EngineeringChangeDocForEdit = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN E_BillOfMaterialItemTP AS _BillOfMaterialItemExtension ON BillOfMaterial = _BillOfMaterialItemExtension.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory AND BillOfMaterialItemNodeNumber = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount  -- association [1..1]
LEFT OUTER JOIN R_BOMItmObjDpnAssignmentTP AS _BOMItmObjDependencyAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_BillOfMaterialSubitemTP AS _BOMSubItems ON /* condition not available in parsed metadata */  -- association [0..*]
;

Depth:

R_BillOfMaterialItemTP view_entity

I_BOMItemHdrChangeState view