I_SalesBOMItemHdrChangeState

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_SalesBOMItemHdrChangeState.
-- 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: IKBOMITEMHDRCHG

CREATE VIEW I_SalesBOMItemHdrChangeState AS
SELECT
  valid_items.BillOfMaterialCategory AS BillOfMaterialCategory,
  cast( valid_items.BillOfMaterial as char8 preserving type ) AS BillOfMaterial,
  valid_items.BillOfMaterialVariant AS BillOfMaterialVariant,
  valid_items.BillOfMaterialVersion AS BillOfMaterialVersion,
  valid_items.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  valid_items.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  stko.EngineeringChangeDocument AS HeaderChangeDocument,
  _SalesOrderBOMLink.Material AS Material,
  _SalesOrderBOMLink.Plant AS Plant,
  stko.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  stko.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  stko.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  valid_items.ValidityStartDate AS ValidityStartDate,
  valid_items.ValidityEndDate AS ValidityEndDate,
  valid_items.EngineeringChangeDocument AS EngineeringChangeDocument,
  valid_items.ChgToEngineeringChgDocument 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,
  valid_items.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  cast( valid_items.BillOfMaterialItemNumber as char4 preserving type ) AS BillOfMaterialItemNumber,
  valid_items.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  cast( valid_items.IsAssembly as stlkz preserving type ) AS IsAssembly,
  valid_items.IsSubItem AS IsSubItem,
  valid_items.BOMItemSorter AS BOMItemSorter,
  valid_items.BOMItemHasFixedQuantity AS BOMItemHasFixedQuantity,
  valid_items.PurchasingGroup AS PurchasingGroup,
  valid_items.Currency AS Currency,
  valid_items.IdentifierBOMItem AS IdentifierBOMItem,
  valid_items.LongTextLanguage AS LongTextLanguage,
  valid_items.ComponentDescription AS ComponentDescription,
  valid_items.MaterialGroup AS MaterialGroup,
  valid_items.ClassNumber AS ClassNumber,
  valid_items.ClassType AS ClassType,
  valid_items.ResultingItemCategory AS ResultingItemCategory,
  valid_items.DependencyObjectNumber AS DependencyObjectNumber,
  valid_items.ObjectType AS BillOfMaterialObjectType,
  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.VariableSizeCompUnitOfMeasure AS VariableSizeCompUnitOfMeasure,
  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.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  valid_items.IsPhantomItem AS IsPhantomItem,
  valid_items.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  valid_items.LastChangeDateTime AS LastChangeDateTime,
  valid_items.AlternativeItemGroup AS AlternativeItemGroup,
  valid_items.AlternativeItemPriority AS AlternativeItemPriority,
  valid_items.AlternativeItemStrategy AS AlternativeItemStrategy,
  valid_items.UsageProbabilityPercent AS UsageProbabilityPercent,
  valid_items.IsPMAssemblyRelevant AS IsPMAssemblyRelevant,
  valid_items.OrigSalesOrderBOMItmCategory AS OrigSalesOrderBOMItmCategory,
  cast( valid_items.OrigSalesOrderBOM as char8 preserving type ) AS OrigSalesOrderBOM,
  valid_items.OrigSalesOrderBOMItmNodeNumber AS OrigSalesOrderBOMItmNodeNumber,
  valid_items.OrigSalesOrderBOMItmNumber AS OrigSalesOrderBOMItmNumber,
  valid_items.PreliminaryMaterial AS PreliminaryMaterial,
  valid_items._BOMItemCategory AS _BOMItemCategory,
  valid_items._UnitOfMeasure AS _UnitOfMeasure
FROM I_BillOfMaterialComponent AS valid_items
INNER JOIN I_BillOfMaterial AS stko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOrderBOMLink AS _SalesOrderBOMLink ON BillOfMaterialCategory = _SalesOrderBOMLink .BillOfMaterialCategory AND BillOfMaterial = _SalesOrderBOMLink .BillOfMaterial AND BillOfMaterialVariant = _SalesOrderBOMLink .BillOfMaterialVariant  -- association [0..1]
;