Deprecated
This CDS view is deprecated in S/4HANA. Use C_BILLOFMATERIALITEMTP instead. View all deprecated CDS views →

C_BillOfMaterialItem

DDL: C_BILLOFMATERIALITEM SQL: CBOMITEMS Type: view CONSUMPTION Package: CS_MODEL
158 Fields 1 Data Sources

Bill of Material Items

C_BillOfMaterialItem is a Consumption CDS View that provides data about "Bill of Material Items" in SAP S/4HANA. It reads from 1 data source (I_Billofmaterialitemwd) and exposes 158 fields with key fields BillOfMaterialItemUUID, BillOfMaterial, BillOfMaterialVariantUsage, BillOfMaterialCategory. Part of development package CS_MODEL.

Data Sources (1)

SourceAliasJoin Type
I_Billofmaterialitemwd bomitems from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CBOMITEMS view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.type #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Bill of Material Items view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_BILLOFMATERIALITEMTP view

Fields (158)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialItemUUID I_Billofmaterialitemwd BillOfMaterialItemUUID Guid
DraftUUIDasDraftUUID
KEY BillOfMaterial I_Billofmaterialitemwd BillOfMaterial BOM
KEY BillOfMaterialVariantUsage I_Billofmaterialitemwd BillOfMaterialVariantUsage Usage
KEY BillOfMaterialCategory I_Billofmaterialitemwd BillOfMaterialCategory BOM category
BillOfMaterialItemNodeNumber I_Billofmaterialitemwd BillOfMaterialItemNodeNumber Item Node Number
ParentDraftUUIDasParentDraftUUID
Material I_Billofmaterialitemwd Material Vehicle Model
Plant I_Billofmaterialitemwd Plant Valuation Area
BillOfMaterialVariant I_Billofmaterialitemwd BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion I_Billofmaterialitemwd BillOfMaterialVersion BOM Version
BOMItemInternalChangeCount I_Billofmaterialitemwd BOMItemInternalChangeCount Counter
ValidityStartDate I_Billofmaterialitemwd ValidityStartDate Validity Start Date
ValidityEndDate I_Billofmaterialitemwd ValidityEndDate ValidTo
EngineeringChangeDocument I_Billofmaterialitemwd EngineeringChangeDocument Change Number
ChgToEngineeringChgDocument I_Billofmaterialitemwd ChgToEngineeringChgDocument Change No. To
IsDeleted I_Billofmaterialitemwd IsDeleted TRUE
InheritedNodeNumberForBOMItem I_Billofmaterialitemwd InheritedNodeNumberForBOMItem Inherited Item Node Number
BOMItemRecordCreationDate I_Billofmaterialitemwd BOMItemRecordCreationDate Created On
BOMItemCreatedByUser I_Billofmaterialitemwd BOMItemCreatedByUser Created by
BOMItemLastChangeDate I_Billofmaterialitemwd BOMItemLastChangeDate Changed On
BOMItemLastChangedByUser I_Billofmaterialitemwd BOMItemLastChangedByUser Changed By
BillOfMaterialComponent I_Billofmaterialitemwd BillOfMaterialComponent Component
ComponentDescription I_Billofmaterialitemwd ComponentDescription Component Description
BillOfMaterialItemCategory I_Billofmaterialitemwd BillOfMaterialItemCategory Item Category
BillOfMaterialItemNumber I_Billofmaterialitemwd BillOfMaterialItemNumber Item
BillOfMaterialItemUnit I_Billofmaterialitemwd BillOfMaterialItemUnit Component UoM
BillOfMaterialItemQuantity I_Billofmaterialitemwd BillOfMaterialItemQuantity Quantity
IsAssembly I_Billofmaterialitemwd IsAssembly Single-Character Flag
IsSubItem I_Billofmaterialitemwd IsSubItem Sub-item ID
IdentifierBOMItem I_Billofmaterialitemwd IdentifierBOMItem Item ID
BOMItemSorter I_Billofmaterialitemwd BOMItemSorter Sort String
FixedQuantity I_Billofmaterialitemwd FixedQuantity Fixed Quantity
PurchasingGroup I_Billofmaterialitemwd PurchasingGroup Purchasing Group
Currency I_Billofmaterialitemwd Currency Valuation Crcy
CostElement I_Billofmaterialitemwd CostElement G/L Account
MaterialComponentPrice I_Billofmaterialitemwd MaterialComponentPrice Price
MaterialPriceUnitQty I_Billofmaterialitemwd MaterialPriceUnitQty Price unit
ComponentScrapInPercent I_Billofmaterialitemwd ComponentScrapInPercent Component Scrap
OperationScrapInPercent I_Billofmaterialitemwd OperationScrapInPercent Operation Scrap
IsNetScrap I_Billofmaterialitemwd IsNetScrap Net Indicator
NumberOfVariableSizeItem I_Billofmaterialitemwd NumberOfVariableSizeItem Number Required
QuantityVariableSizeItem I_Billofmaterialitemwd QuantityVariableSizeItem VSI Quantity
FormulaKey I_Billofmaterialitemwd FormulaKey VSI Formula
BOMItemDescription I_Billofmaterialitemwd BOMItemDescription Item Text
BOMItemText2
MaterialGroup I_Billofmaterialitemwd MaterialGroup Product Group
GoodsReceiptDuration I_Billofmaterialitemwd GoodsReceiptDuration GR proc. time
DocumentType I_Billofmaterialitemwd DocumentType Order Type
DocNumber I_Billofmaterialitemwd DocNumber Document Number
DocumentVersion I_Billofmaterialitemwd DocumentVersion Docu. Version
DocumentPart I_Billofmaterialitemwd DocumentPart Document Part
ClassNumber I_Billofmaterialitemwd ClassNumber Class
ClassType I_Billofmaterialitemwd ClassType X Flag
ResultingItemCategory I_Billofmaterialitemwd ResultingItemCategory Res. item cat.
DependencyObjectNumber I_Billofmaterialitemwd DependencyObjectNumber Assgmt no.
ObjectType I_Billofmaterialitemwd ObjectType Type
IsClassificationRelevant I_Billofmaterialitemwd IsClassificationRelevant Class Selection Indicator
IsBulkMaterial I_Billofmaterialitemwd IsBulkMaterial Bulk material
BOMItemIsSparePart I_Billofmaterialitemwd BOMItemIsSparePart Spare Part ID
BOMItemIsSalesRelevant I_Billofmaterialitemwd BOMItemIsSalesRelevant Sales
IsProductionRelevant I_Billofmaterialitemwd IsProductionRelevant Production
BOMItemIsPlantMaintRelevant I_Billofmaterialitemwd BOMItemIsPlantMaintRelevant Plant maint.
BOMItemIsCostingRelevant I_Billofmaterialitemwd BOMItemIsCostingRelevant CostingRelevncy
IsEngineeringRelevant I_Billofmaterialitemwd IsEngineeringRelevant Engineering
SpecialProcurementType I_Billofmaterialitemwd SpecialProcurementType SpecProcurement
BOMIsRecursive I_Billofmaterialitemwd BOMIsRecursive Recursive
OperationLeadTimeOffset I_Billofmaterialitemwd OperationLeadTimeOffset Oper. LT offset
OpsLeadTimeOffsetUnit I_Billofmaterialitemwd OpsLeadTimeOffsetUnit Oper. LTO unit
DistrKeyCompConsumption I_Billofmaterialitemwd DistrKeyCompConsumption Distribution
IsMaterialProvision I_Billofmaterialitemwd IsMaterialProvision Mat. Prov. Ind.
DocumentIsCreatedByCAD I_Billofmaterialitemwd DocumentIsCreatedByCAD CAD Indicator
DeliveryDurationInDays I_Billofmaterialitemwd DeliveryDurationInDays Del time (days)
Creditor I_Billofmaterialitemwd Creditor Supplier
Size1 I_Billofmaterialitemwd Size1 Size 1
Size2 I_Billofmaterialitemwd Size2 Size 2
Size3 I_Billofmaterialitemwd Size3 Size 3
UnitOfMeasureForSize1To3 I_Billofmaterialitemwd UnitOfMeasureForSize1To3 Size unit
PurchasingOrganization I_Billofmaterialitemwd PurchasingOrganization Purchasing Organization
RequiredComponent I_Billofmaterialitemwd RequiredComponent Reqd Component
MultipleSelectionAllowed I_Billofmaterialitemwd MultipleSelectionAllowed Multiple Sel.
ProdOrderIssueLocation I_Billofmaterialitemwd ProdOrderIssueLocation StorageLocation
MaterialIsCoProduct I_Billofmaterialitemwd MaterialIsCoProduct Co-product
ExplosionType I_Billofmaterialitemwd ExplosionType Explosion type
IsPhantomItem I_Billofmaterialitemwd IsPhantomItem Phantom item
AlternativeItemGroup I_Billofmaterialitemwd AlternativeItemGroup AltItemGroup
FollowUpGroup I_Billofmaterialitemwd FollowUpGroup Follow-up group
DiscontinuationGroup I_Billofmaterialitemwd DiscontinuationGroup Discont. group
OrganizationalArea
IsConfigurableBOM I_Billofmaterialitemwd IsConfigurableBOM Sel. ind.
ReferencePoint I_Billofmaterialitemwd ReferencePoint Reference point
LeadTimeOffset I_Billofmaterialitemwd LeadTimeOffset Lead-tm offset
ProductionSupplyArea I_Billofmaterialitemwd ProductionSupplyArea Supply Area
IsALE I_Billofmaterialitemwd IsALE ALE indicator
IsBOMRecursiveAllowed I_Billofmaterialitemwd IsBOMRecursiveAllowed Rec. allowed
DraftAdministrativeDataUUID I_Billofmaterialitemwd DraftAdministrativeDataUUID UUID
IsActiveEntity I_Billofmaterialitemwd IsActiveEntity Is active
HasActiveEntity I_Billofmaterialitemwd HasActiveEntity TRUE
HasDraftEntity I_Billofmaterialitemwd HasDraftEntity Has Draft
IsItemDraftModified I_Billofmaterialitemwd IsItemDraftModified Single-Character Flag
ItemAttachmentKey I_Billofmaterialitemwd ItemAttachmentKey Object Key
MaterialName
UxFcBillOfMaterialComponent I_Billofmaterialitemwd UxFcBillOfMaterialComponent
UxFcComponentDescription I_Billofmaterialitemwd UxFcComponentDescription
UxFcBillOfMaterialItemNumber I_Billofmaterialitemwd UxFcBillOfMaterialItemNumber
UxFcBillOfMaterialItemUnit I_Billofmaterialitemwd UxFcBillOfMaterialItemUnit
UxFcBillOfMaterialItemQuantity I_Billofmaterialitemwd UxFcBillOfMaterialItemQuantity
UxFcCurrency I_Billofmaterialitemwd UxFcCurrency
UxFcMaterialComponentPrice I_Billofmaterialitemwd UxFcMaterialComponentPrice
UxFcMaterialPriceUnitQty I_Billofmaterialitemwd UxFcMaterialPriceUnitQty
UxFcComponentScrapInPercent I_Billofmaterialitemwd UxFcComponentScrapInPercent
UxFcOperationScrapInPercent I_Billofmaterialitemwd UxFcOperationScrapInPercent
UxFcIsNetScrap I_Billofmaterialitemwd UxFcIsNetScrap
UxFcNumberOfVariableSizeItem I_Billofmaterialitemwd UxFcNumberOfVariableSizeItem
UxFcQuantityVariableSizeItem I_Billofmaterialitemwd UxFcQuantityVariableSizeItem
UxFcFormulaKey I_Billofmaterialitemwd UxFcFormulaKey
UxFcBOMItemDescription I_Billofmaterialitemwd UxFcBOMItemDescription
UxFcBOMItemText2 I_Billofmaterialitemwd UxFcBOMItemText2
UxFcDocumentType I_Billofmaterialitemwd UxFcDocumentType
UxFcDocNumber I_Billofmaterialitemwd UxFcDocNumber
UxFcDocumentVersion I_Billofmaterialitemwd UxFcDocumentVersion
UxFcDocumentPart I_Billofmaterialitemwd UxFcDocumentPart
UxFcClassNumber I_Billofmaterialitemwd UxFcClassNumber
UxFcClassType I_Billofmaterialitemwd UxFcClassType
UxFcIsBulkMaterial I_Billofmaterialitemwd UxFcIsBulkMaterial
UxFcCostElement I_Billofmaterialitemwd UxFcCostElement
UxFcBOMItemIsCostingRelevant I_Billofmaterialitemwd UxFcBOMItemIsCostingRelevant
UxFcMaterialIsCoProduct I_Billofmaterialitemwd UxFcMaterialIsCoProduct
UxFcDeliveryDurationInDays I_Billofmaterialitemwd UxFcDeliveryDurationInDays
UxFcOrganizationalArea
UxFcIsEngineeringRelevant I_Billofmaterialitemwd UxFcIsEngineeringRelevant
UxFcExplosionType I_Billofmaterialitemwd UxFcExplosionType
UxFcFixedQuantity I_Billofmaterialitemwd UxFcFixedQuantity
UxFcGoodsReceiptDuration I_Billofmaterialitemwd UxFcGoodsReceiptDuration
UxFcProdOrderIssueLocation I_Billofmaterialitemwd UxFcProdOrderIssueLocation
UxFcBillOfMaterialItemCategory I_Billofmaterialitemwd UxFcBillOfMaterialItemCategory
UxFcOperationLeadTimeOffset I_Billofmaterialitemwd UxFcOperationLeadTimeOffset
UxFcOpsLeadTimeOffsetUnit I_Billofmaterialitemwd UxFcOpsLeadTimeOffsetUnit
UxFcMaterialGroup I_Billofmaterialitemwd UxFcMaterialGroup
UxFcIsMaterialProvision I_Billofmaterialitemwd UxFcIsMaterialProvision
UxFcMultipleSelectionAllowed I_Billofmaterialitemwd UxFcMultipleSelectionAllowed
UxFcObjectType I_Billofmaterialitemwd UxFcObjectType
UxFcIsProductionRelevant I_Billofmaterialitemwd UxFcIsProductionRelevant
UxFcPurchasingOrganization I_Billofmaterialitemwd UxFcPurchasingOrganization
UxFcPurchasingGroup I_Billofmaterialitemwd UxFcPurchasingGroup
UxFcRequiredComponent
UxFcIsClassificationRelevant I_Billofmaterialitemwd UxFcIsClassificationRelevant
UxFcBOMItemSorter I_Billofmaterialitemwd UxFcBOMItemSorter
UxFcSpecialProcurementType I_Billofmaterialitemwd UxFcSpecialProcurementType
UxFcCreditor I_Billofmaterialitemwd UxFcCreditor
UxFcQuanitityVariableSizeItem
UxFcSize1 I_Billofmaterialitemwd UxFcSize1
UxFcSize2 I_Billofmaterialitemwd UxFcSize2
UxFcSize3 I_Billofmaterialitemwd UxFcSize3
UxFcUnitOfMeasureForSize1To3 I_Billofmaterialitemwd UxFcUnitOfMeasureForSize1To3
UxFcValidityEndDate I_Billofmaterialitemwd UxFcValidityEndDate
UxFcValidityStartDate I_Billofmaterialitemwd UxFcValidityStartDate
UxFcEngineeringChangeDocument I_Billofmaterialitemwd UxFcEngineeringChangeDocument

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 C_BillOfMaterialItem.
-- 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: CBOMITEMS

CREATE VIEW C_BillOfMaterialItem AS
SELECT
  bomitems.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  bomitems.BillOfMaterial AS BillOfMaterial,
  bomitems.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bomitems.BillOfMaterialCategory AS BillOfMaterialCategory,
  bomitems.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  bomitems.Material AS Material,
  bomitems.Plant AS Plant,
  bomitems.BillOfMaterialVariant AS BillOfMaterialVariant,
  bomitems.BillOfMaterialVersion AS BillOfMaterialVersion,
  bomitems.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  bomitems.ValidityStartDate AS ValidityStartDate,
  bomitems.ValidityEndDate AS ValidityEndDate,
  bomitems.EngineeringChangeDocument AS EngineeringChangeDocument,
  bomitems.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bomitems.IsDeleted AS IsDeleted,
  bomitems.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  bomitems.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  bomitems.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  bomitems.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  bomitems.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  bomitems.BillOfMaterialComponent AS BillOfMaterialComponent,
  bomitems.ComponentDescription AS ComponentDescription,
  bomitems.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  bomitems.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  bomitems.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  bomitems.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  bomitems.IsAssembly AS IsAssembly,
  bomitems.IsSubItem AS IsSubItem,
  bomitems.IdentifierBOMItem AS IdentifierBOMItem,
  bomitems.BOMItemSorter AS BOMItemSorter,
  bomitems.FixedQuantity AS FixedQuantity,
  bomitems.PurchasingGroup AS PurchasingGroup,
  bomitems.Currency AS Currency,
  bomitems.CostElement AS CostElement,
  bomitems.MaterialComponentPrice AS MaterialComponentPrice,
  bomitems.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  bomitems.ComponentScrapInPercent AS ComponentScrapInPercent,
  bomitems.OperationScrapInPercent AS OperationScrapInPercent,
  bomitems.IsNetScrap AS IsNetScrap,
  bomitems.NumberOfVariableSizeItem AS NumberOfVariableSizeItem,
  bomitems.QuantityVariableSizeItem AS QuantityVariableSizeItem,
  bomitems.FormulaKey AS FormulaKey,
  bomitems.BOMItemDescription AS BOMItemDescription,
  bomitems.MaterialGroup AS MaterialGroup,
  bomitems.GoodsReceiptDuration AS GoodsReceiptDuration,
  bomitems.DocumentType AS DocumentType,
  bomitems.DocNumber AS DocNumber,
  bomitems.DocumentVersion AS DocumentVersion,
  bomitems.DocumentPart AS DocumentPart,
  bomitems.ClassNumber AS ClassNumber,
  bomitems.ClassType AS ClassType,
  bomitems.ResultingItemCategory AS ResultingItemCategory,
  bomitems.DependencyObjectNumber AS DependencyObjectNumber,
  bomitems.ObjectType AS ObjectType,
  bomitems.IsClassificationRelevant AS IsClassificationRelevant,
  bomitems.IsBulkMaterial AS IsBulkMaterial,
  bomitems.BOMItemIsSparePart AS BOMItemIsSparePart,
  bomitems.BOMItemIsSalesRelevant AS BOMItemIsSalesRelevant,
  bomitems.IsProductionRelevant AS IsProductionRelevant,
  bomitems.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  bomitems.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  bomitems.IsEngineeringRelevant AS IsEngineeringRelevant,
  bomitems.SpecialProcurementType AS SpecialProcurementType,
  bomitems.BOMIsRecursive AS BOMIsRecursive,
  bomitems.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  bomitems.OpsLeadTimeOffsetUnit AS OpsLeadTimeOffsetUnit,
  bomitems.DistrKeyCompConsumption AS DistrKeyCompConsumption,
  bomitems.IsMaterialProvision AS IsMaterialProvision,
  bomitems.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bomitems.DeliveryDurationInDays AS DeliveryDurationInDays,
  bomitems.Creditor AS Creditor,
  bomitems.Size1 AS Size1,
  bomitems.Size2 AS Size2,
  bomitems.Size3 AS Size3,
  bomitems.UnitOfMeasureForSize1To3 AS UnitOfMeasureForSize1To3,
  bomitems.PurchasingOrganization AS PurchasingOrganization,
  bomitems.RequiredComponent AS RequiredComponent,
  bomitems.MultipleSelectionAllowed AS MultipleSelectionAllowed,
  bomitems.ProdOrderIssueLocation AS ProdOrderIssueLocation,
  bomitems.MaterialIsCoProduct AS MaterialIsCoProduct,
  bomitems.ExplosionType AS ExplosionType,
  bomitems.IsPhantomItem AS IsPhantomItem,
  bomitems.AlternativeItemGroup AS AlternativeItemGroup,
  bomitems.FollowUpGroup AS FollowUpGroup,
  bomitems.DiscontinuationGroup AS DiscontinuationGroup,
  bomitems.IsConfigurableBOM AS IsConfigurableBOM,
  bomitems.ReferencePoint AS ReferencePoint,
  bomitems.LeadTimeOffset AS LeadTimeOffset,
  bomitems.ProductionSupplyArea AS ProductionSupplyArea,
  bomitems.IsALE AS IsALE,
  bomitems.IsBOMRecursiveAllowed AS IsBOMRecursiveAllowed,
  bomitems.DraftAdministrativeDataUUID AS DraftAdministrativeDataUUID,
  bomitems.IsActiveEntity AS IsActiveEntity,
  bomitems.HasActiveEntity AS HasActiveEntity,
  bomitems.HasDraftEntity AS HasDraftEntity,
  bomitems.IsItemDraftModified AS IsItemDraftModified,
  bomitems.ItemAttachmentKey AS ItemAttachmentKey,
  '' AS MaterialName,
  bomitems.UxFcBillOfMaterialComponent AS UxFcBillOfMaterialComponent,
  bomitems.UxFcComponentDescription AS UxFcComponentDescription,
  bomitems.UxFcBillOfMaterialItemNumber AS UxFcBillOfMaterialItemNumber,
  bomitems.UxFcBillOfMaterialItemUnit AS UxFcBillOfMaterialItemUnit,
  bomitems.UxFcBillOfMaterialItemQuantity AS UxFcBillOfMaterialItemQuantity,
  bomitems.UxFcCurrency AS UxFcCurrency,
  bomitems.UxFcMaterialComponentPrice AS UxFcMaterialComponentPrice,
  bomitems.UxFcMaterialPriceUnitQty AS UxFcMaterialPriceUnitQty,
  bomitems.UxFcComponentScrapInPercent AS UxFcComponentScrapInPercent,
  bomitems.UxFcOperationScrapInPercent AS UxFcOperationScrapInPercent,
  bomitems.UxFcIsNetScrap AS UxFcIsNetScrap,
  bomitems.UxFcNumberOfVariableSizeItem AS UxFcNumberOfVariableSizeItem,
  bomitems.UxFcQuantityVariableSizeItem AS UxFcQuantityVariableSizeItem,
  bomitems.UxFcFormulaKey AS UxFcFormulaKey,
  bomitems.UxFcBOMItemDescription AS UxFcBOMItemDescription,
  bomitems.UxFcBOMItemText2 AS UxFcBOMItemText2,
  bomitems.UxFcDocumentType AS UxFcDocumentType,
  bomitems.UxFcDocNumber AS UxFcDocNumber,
  bomitems.UxFcDocumentVersion AS UxFcDocumentVersion,
  bomitems.UxFcDocumentPart AS UxFcDocumentPart,
  bomitems.UxFcClassNumber AS UxFcClassNumber,
  bomitems.UxFcClassType AS UxFcClassType,
  bomitems.UxFcIsBulkMaterial AS UxFcIsBulkMaterial,
  bomitems.UxFcCostElement AS UxFcCostElement,
  bomitems.UxFcBOMItemIsCostingRelevant AS UxFcBOMItemIsCostingRelevant,
  bomitems.UxFcMaterialIsCoProduct AS UxFcMaterialIsCoProduct,
  bomitems.UxFcDeliveryDurationInDays AS UxFcDeliveryDurationInDays,
  bomitems.UxFcIsEngineeringRelevant AS UxFcIsEngineeringRelevant,
  bomitems.UxFcExplosionType AS UxFcExplosionType,
  bomitems.UxFcFixedQuantity AS UxFcFixedQuantity,
  bomitems.UxFcGoodsReceiptDuration AS UxFcGoodsReceiptDuration,
  bomitems.UxFcProdOrderIssueLocation AS UxFcProdOrderIssueLocation,
  bomitems.UxFcBillOfMaterialItemCategory AS UxFcBillOfMaterialItemCategory,
  bomitems.UxFcOperationLeadTimeOffset AS UxFcOperationLeadTimeOffset,
  bomitems.UxFcOpsLeadTimeOffsetUnit AS UxFcOpsLeadTimeOffsetUnit,
  bomitems.UxFcMaterialGroup AS UxFcMaterialGroup,
  bomitems.UxFcIsMaterialProvision AS UxFcIsMaterialProvision,
  bomitems.UxFcMultipleSelectionAllowed AS UxFcMultipleSelectionAllowed,
  bomitems.UxFcObjectType AS UxFcObjectType,
  bomitems.UxFcIsProductionRelevant AS UxFcIsProductionRelevant,
  bomitems.UxFcPurchasingOrganization AS UxFcPurchasingOrganization,
  bomitems.UxFcPurchasingGroup AS UxFcPurchasingGroup,
  bomitems.UxFcIsClassificationRelevant AS UxFcIsClassificationRelevant,
  bomitems.UxFcBOMItemSorter AS UxFcBOMItemSorter,
  bomitems.UxFcSpecialProcurementType AS UxFcSpecialProcurementType,
  bomitems.UxFcCreditor AS UxFcCreditor,
  bomitems.UxFcSize1 AS UxFcSize1,
  bomitems.UxFcSize2 AS UxFcSize2,
  bomitems.UxFcSize3 AS UxFcSize3,
  bomitems.UxFcUnitOfMeasureForSize1To3 AS UxFcUnitOfMeasureForSize1To3,
  bomitems.UxFcValidityEndDate AS UxFcValidityEndDate,
  bomitems.UxFcValidityStartDate AS UxFcValidityStartDate,
  bomitems.UxFcEngineeringChangeDocument AS UxFcEngineeringChangeDocument
FROM I_Billofmaterialitemwd AS bomitems
;

Learn More