I_BillOfMaterialItemTP_2

DDL: I_BILLOFMATERIALITEMTP_2 Type: view_entity TRANSACTIONAL Package: CS_MODEL_API
95 Fields 1 Data Sources

Bill Of Material Item - TP

I_BillOfMaterialItemTP_2 is a Transactional CDS View that provides data about "Bill Of Material Item - TP" in SAP S/4HANA. It reads from 1 data source (R_BillOfMaterialItemTP) and exposes 95 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. Part of development package CS_MODEL_API.

Data Sources (1)

SourceAliasJoin Type
R_BillOfMaterialItemTP R_BillOfMaterialItemTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Bill Of Material Item - TP view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Metadata.ignorePropagatedAnnotations true view

Fields (95)

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

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_BillOfMaterialItemTP_2.
-- 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 I_BillOfMaterialItemTP_2 AS
SELECT
  BillOfMaterialItem.BillOfMaterial AS BillOfMaterial,
  BillOfMaterialItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  BillOfMaterialItem.BillOfMaterialVariant AS BillOfMaterialVariant,
  BillOfMaterialItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  BillOfMaterialItem.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  BillOfMaterialItem.HeaderChangeDocument AS HeaderChangeDocument,
  BillOfMaterialItem.Material AS Material,
  BillOfMaterialItem.Plant AS Plant,
  BillOfMaterialItem.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  BillOfMaterialItem.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  BillOfMaterialItem.ValidityStartDate AS ValidityStartDate,
  BillOfMaterialItem.ValidityEndDate AS ValidityEndDate,
  BillOfMaterialItem.EngineeringChangeDocForEdit AS EngineeringChangeDocForEdit,
  BillOfMaterialItem.EngineeringChangeDocument AS EngineeringChangeDocument,
  BillOfMaterialItem.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  BillOfMaterialItem.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  BillOfMaterialItem.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  BillOfMaterialItem.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  BillOfMaterialItem.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  BillOfMaterialItem.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  BillOfMaterialItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  BillOfMaterialItem.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  BillOfMaterialItem.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  BillOfMaterialItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  BillOfMaterialItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  BillOfMaterialItem.IsAssembly AS IsAssembly,
  BillOfMaterialItem.IsSubItem AS IsSubItem,
  BillOfMaterialItem.BOMItemSorter AS BOMItemSorter,
  BillOfMaterialItem.BOMItemHasFixedQuantity AS BOMItemHasFixedQuantity,
  BillOfMaterialItem.PurchasingGroup AS PurchasingGroup,
  BillOfMaterialItem.Currency AS Currency,
  BillOfMaterialItem.MaterialComponentPrice AS MaterialComponentPrice,
  BillOfMaterialItem.IdentifierBOMItem AS IdentifierBOMItem,
  BillOfMaterialItem.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  BillOfMaterialItem.ComponentScrapInPercent AS ComponentScrapInPercent,
  BillOfMaterialItem.OperationScrapInPercent AS OperationScrapInPercent,
  BillOfMaterialItem.IsNetScrap AS IsNetScrap,
  BillOfMaterialItem.QuantityVariableSizeItem AS QuantityVariableSizeItem,
  BillOfMaterialItem.FormulaKey AS FormulaKey,
  BillOfMaterialItem.ComponentDescription AS ComponentDescription,
  BillOfMaterialItem.BOMItemDescription AS BOMItemDescription,
  BillOfMaterialItem.BOMItemText2 AS BOMItemText2,
  BillOfMaterialItem.MaterialGroup AS MaterialGroup,
  BillOfMaterialItem.DocumentType AS DocumentType,
  BillOfMaterialItem.DocNumber AS DocNumber,
  BillOfMaterialItem.DocumentVersion AS DocumentVersion,
  BillOfMaterialItem.DocumentPart AS DocumentPart,
  BillOfMaterialItem.ClassNumber AS ClassNumber,
  BillOfMaterialItem.ClassType AS ClassType,
  BillOfMaterialItem.ResultingItemCategory AS ResultingItemCategory,
  BillOfMaterialItem.DependencyObjectNumber AS DependencyObjectNumber,
  BillOfMaterialItem.ObjectType AS ObjectType,
  BillOfMaterialItem.IsClassificationRelevant AS IsClassificationRelevant,
  BillOfMaterialItem.IsBulkMaterial AS IsBulkMaterial,
  BillOfMaterialItem.BOMItemIsSparePart AS BOMItemIsSparePart,
  BillOfMaterialItem.BOMItemIsSalesRelevant AS BOMItemIsSalesRelevant,
  BillOfMaterialItem.IsProductionRelevant AS IsProductionRelevant,
  BillOfMaterialItem.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  BillOfMaterialItem.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  BillOfMaterialItem.IsEngineeringRelevant AS IsEngineeringRelevant,
  BillOfMaterialItem.SpecialProcurementType AS SpecialProcurementType,
  BillOfMaterialItem.IsBOMRecursiveAllowed AS IsBOMRecursiveAllowed,
  BillOfMaterialItem.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  BillOfMaterialItem.OpsLeadTimeOffsetUnit AS OpsLeadTimeOffsetUnit,
  BillOfMaterialItem.IsMaterialProvision AS IsMaterialProvision,
  BillOfMaterialItem.BOMIsRecursive AS BOMIsRecursive,
  BillOfMaterialItem.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  BillOfMaterialItem.DistrKeyCompConsumption AS DistrKeyCompConsumption,
  BillOfMaterialItem.DeliveryDurationInDays AS DeliveryDurationInDays,
  BillOfMaterialItem.Creditor AS Creditor,
  BillOfMaterialItem.CostElement AS CostElement,
  BillOfMaterialItem.Size1 AS Size1,
  BillOfMaterialItem.Size2 AS Size2,
  BillOfMaterialItem.Size3 AS Size3,
  BillOfMaterialItem.UnitOfMeasureForSize1To3 AS UnitOfMeasureForSize1To3,
  BillOfMaterialItem.GoodsReceiptDuration AS GoodsReceiptDuration,
  BillOfMaterialItem.PurchasingOrganization AS PurchasingOrganization,
  BillOfMaterialItem.RequiredComponent AS RequiredComponent,
  BillOfMaterialItem.MultipleSelectionAllowed AS MultipleSelectionAllowed,
  BillOfMaterialItem.ProdOrderIssueLocation AS ProdOrderIssueLocation,
  BillOfMaterialItem.MaterialIsCoProduct AS MaterialIsCoProduct,
  BillOfMaterialItem.ExplosionType AS ExplosionType,
  BillOfMaterialItem.AlternativeItemGroup AS AlternativeItemGroup,
  BillOfMaterialItem.AlternativeItemPriority AS AlternativeItemPriority,
  BillOfMaterialItem.AlternativeItemStrategy AS AlternativeItemStrategy,
  BillOfMaterialItem.UsageProbabilityPercent AS UsageProbabilityPercent,
  BillOfMaterialItem.FollowUpGroup AS FollowUpGroup,
  BillOfMaterialItem.DiscontinuationGroup AS DiscontinuationGroup,
  BillOfMaterialItem.IsConfigurableBOM AS IsConfigurableBOM,
  BillOfMaterialItem.ReferencePoint AS ReferencePoint,
  BillOfMaterialItem.LeadTimeOffset AS LeadTimeOffset,
  BillOfMaterialItem.ProductionSupplyArea AS ProductionSupplyArea,
  BillOfMaterialItem.IsDeleted AS IsDeleted,
  BillOfMaterialItem.IsALE AS IsALE,
  BillOfMaterialItem.LastChangeDateTime AS LastChangeDateTime
FROM R_BillOfMaterialItemTP
;

Learn More