I_BillOfMaterialComponent

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_BillOfMaterialComponent.
-- 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: IBOMCOMPS

CREATE VIEW I_BillOfMaterialComponent AS
SELECT
  valid_items.BillOfMaterialCategory AS BillOfMaterialCategory,
  valid_items.BillOfMaterial AS BillOfMaterial,
  valid_items.BillOfMaterialVariant AS BillOfMaterialVariant,
  valid_items.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  valid_items.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  valid_items.BillOfMaterialVersion AS BillOfMaterialVersion,
  valid_items.ValidityStartDate AS ValidityStartDate,
  valid_items.ValidityEndDate AS ValidityEndDate,
  valid_items.ChangeNumberFrom AS EngineeringChangeDocument,
  cast( valid_items.ChangeNumberTo as aenra preserving type ) AS ChgToEngineeringChgDocument,
  valid_items.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  valid_items.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  valid_items.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  valid_items.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  valid_items.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  valid_items.BillOfMaterialComponent AS BillOfMaterialComponent,
  ' ' AS MaterialName,
  valid_items.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  valid_items.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  cast( valid_items.IsAssembly as stlkz preserving type ) AS IsAssembly,
  valid_items.IsSubItem AS IsSubItem,
  valid_items.BOMItemSorter AS BOMItemSorter,
  valid_items.FixedQuantity AS FixedQuantity,
  valid_items.BOMItemHasFixedQuantity AS BOMItemHasFixedQuantity,
  valid_items.PurchasingGroup AS PurchasingGroup,
  valid_items.Currency AS Currency,
  valid_items.MaterialComponentPrice AS MaterialComponentPrice,
  valid_items.IdentifierBOMItem AS IdentifierBOMItem,
  valid_items.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  valid_items.ComponentScrapInPercent AS ComponentScrapInPercent,
  valid_items.OperationScrapInPercent AS OperationScrapInPercent,
  valid_items.IsNetScrap AS IsNetScrap,
  valid_items.NumberOfVariableSizeItem AS NumberOfVariableSizeItem,
  valid_items.QuantityVariableSizeItem AS QuantityVariableSizeItem,
  valid_items.UnitOfMeasureForVarSizeItem AS UnitOfMeasureForVarSizeItem,
  valid_items.FormulaKey AS FormulaKey,
  valid_items.BOMItemDescription AS BOMItemDescription,
  valid_items.BOMItemText2 AS BOMItemText2,
  valid_items.LongTextLanguage AS LongTextLanguage,
  valid_items.MaterialGroup AS MaterialGroup,
  valid_items.DocumentType AS DocumentType,
  valid_items.DocNumber AS DocNumber,
  valid_items.DocumentVersion AS DocumentVersion,
  valid_items.DocumentPart AS DocumentPart,
  valid_items.ClassNumber AS ClassNumber,
  valid_items.ClassType AS ClassType,
  valid_items.ResultingItemCategory AS ResultingItemCategory,
  valid_items.DependencyObjectNumber AS DependencyObjectNumber,
  valid_items.ObjectType AS ObjectType,
  valid_items.IsClassificationRelevant AS IsClassificationRelevant,
  valid_items.IsBulkMaterial AS IsBulkMaterial,
  valid_items.BOMItemIsSparePart AS BOMItemIsSparePart,
  valid_items.BOMItemIsSalesRelevant AS BOMItemIsSalesRelevant,
  valid_items.IsProductionRelevant AS IsProductionRelevant,
  valid_items.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  valid_items.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  valid_items.IsEngineeringRelevant AS IsEngineeringRelevant,
  valid_items.SpecialProcurementType AS SpecialProcurementType,
  valid_items.IsBOMRecursiveAllowed AS IsBOMRecursiveAllowed,
  valid_items.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  valid_items.OpsLeadTimeOffsetUnit AS OpsLeadTimeOffsetUnit,
  valid_items.IsMaterialProvision AS IsMaterialProvision,
  valid_items.BOMIsRecursive AS BOMIsRecursive,
  valid_items.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  valid_items.DistrKeyCompConsumption AS DistrKeyCompConsumption,
  valid_items.DeliveryDurationInDays AS DeliveryDurationInDays,
  valid_items.Creditor AS Creditor,
  valid_items.CostElement AS CostElement,
  valid_items.Size1 AS Size1,
  valid_items.Size2 AS Size2,
  valid_items.Size3 AS Size3,
  valid_items.UnitOfMeasureForSize1To3 AS UnitOfMeasureForSize1To3,
  valid_items.GoodsReceiptDuration AS GoodsReceiptDuration,
  valid_items.PurchasingOrganization AS PurchasingOrganization,
  valid_items.RequiredComponent AS RequiredComponent,
  valid_items.MultipleSelectionAllowed AS MultipleSelectionAllowed,
  valid_items.ProdOrderIssueLocation AS ProdOrderIssueLocation,
  valid_items.MaterialIsCoProduct AS MaterialIsCoProduct,
  valid_items.ExplosionType AS ExplosionType,
  valid_items.FollowUpGroup AS FollowUpGroup,
  valid_items.DiscontinuationGroup AS DiscontinuationGroup,
  valid_items.IsConfigurableBOM AS IsConfigurableBOM,
  valid_items.ReferencePoint AS ReferencePoint,
  valid_items.LeadTimeOffset AS LeadTimeOffset,
  valid_items.IsSoftwareComponent AS IsSoftwareComponent,
  valid_items.ProductionSupplyArea AS ProductionSupplyArea,
  valid_items.IsDeleted AS IsDeleted,
  valid_items.IsALE AS IsALE,
  valid_items.AlternativeItemGroup AS AlternativeItemGroup,
  valid_items.AlternativeItemPriority AS AlternativeItemPriority,
  valid_items.AlternativeItemStrategy AS AlternativeItemStrategy,
  valid_items.UsageProbabilityPercent AS UsageProbabilityPercent,
  _BOMItemCategoryText.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  cast ( valid_items.IsPhantomItem as dumps preserving type ) AS MaterialComponentIsPhantomItem,
  cast ( valid_items.IsPhantomItem as dumps preserving type ) AS IsPhantomItem,
  valid_items.LastChangeDateTime AS LastChangeDateTime,
  valid_items.IsPMAssemblyRelevant AS IsPMAssemblyRelevant,
  valid_items.OrigSalesOrderBOMItmCategory AS OrigSalesOrderBOMItmCategory,
  valid_items.OrigSalesOrderBOM AS OrigSalesOrderBOM,
  valid_items.OrigSalesOrderBOMItmNodeNumber AS OrigSalesOrderBOMItmNodeNumber,
  valid_items.OrigSalesOrderBOMItmNumber AS OrigSalesOrderBOMItmNumber,
  valid_items.PreliminaryMaterial AS PreliminaryMaterial
FROM P_BOMItems AS valid_items
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [1..1]
LEFT OUTER JOIN I_BomItemCategoryText AS _BOMItemCategoryText ON BillOfMaterialItemCategory = _BOMItemCategoryText.BillOfMaterialItemCategory AND _BOMItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BillOfMaterialItemUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_MaterialBOMLink AS _Mast ON BillOfMaterialCategory = _Mast.BillOfMaterialCategory AND BillOfMaterial = _Mast.BillOfMaterial AND BillOfMaterialVariant = _Mast.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_DocumentBOMLink AS _Dost ON BillOfMaterialCategory = _Dost.BillOfMaterialCategory AND BillOfMaterial = _Dost.BillOfMaterial AND BillOfMaterialVariant = _Dost.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_Prst AS _Prst ON BillOfMaterialCategory = _Prst.BillOfMaterialCategory AND BillOfMaterial = _Prst.BillOfMaterial AND BillOfMaterialVariant = _Prst.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderBOMLink AS _Kdst ON BillOfMaterialCategory = _Kdst.BillOfMaterialCategory AND BillOfMaterial = _Kdst.BillOfMaterial AND BillOfMaterialVariant = _Kdst.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_EquipmentBOMLink AS _Eqst ON BillOfMaterialCategory = _Eqst.BillOfMaterialCategory AND BillOfMaterial = _Eqst.BillOfMaterial AND BillOfMaterialVariant = _Eqst.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_Tpst AS _Tpst ON BillOfMaterialCategory = _Tpst.BillOfMaterialCategory AND BillOfMaterial = _Tpst.BillOfMaterial AND BillOfMaterialVariant = _Tpst.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_Stst AS _Stst ON BillOfMaterialCategory = _Stst.BillOfMaterialCategory AND BillOfMaterial = _Stst.BillOfMaterial AND BillOfMaterialVariant = _Stst.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON BillOfMaterialComponent = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON BillOfMaterialComponent = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialTextEN ON BillOfMaterialComponent = _MaterialTextEN.Material AND _MaterialTextEN.Language = 'E'  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDesc AS _DocumentText ON DocumentType = _DocumentText.DocumentInfoRecordDocType AND DocNumber = _DocumentText.DocumentInfoRecordDocNumber AND DocumentPart = _DocumentText.DocumentInfoRecordDocPart AND DocumentVersion = _DocumentText.DocumentInfoRecordDocVersion AND _DocumentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDesc AS _DocumentTextEN ON DocumentType = _DocumentTextEN.DocumentInfoRecordDocType AND DocNumber = _DocumentTextEN.DocumentInfoRecordDocNumber AND DocumentPart = _DocumentTextEN.DocumentInfoRecordDocPart AND DocumentVersion = _DocumentTextEN.DocumentInfoRecordDocVersion AND _DocumentTextEN.Language = 'E'  -- association [0..1]
LEFT OUTER JOIN I_ClfnClassVH AS _Class ON ClassNumber = _Class.Class AND ClassType = _Class.ClassType  -- association [0..1]
;