I_MaintBOMItemHdrChangeState

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_MaintBOMItemHdrChangeState.
-- 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: IMAINTBOMITEMCHG

CREATE VIEW I_MaintBOMItemHdrChangeState AS
SELECT
  cast( valid_items.BillOfMaterial as abap.char( 8 ) ) AS BillOfMaterial,
  valid_items.BillOfMaterialCategory AS BillOfMaterialCategory,
  valid_items.BillOfMaterialVariant AS BillOfMaterialVariant,
  valid_items.BillOfMaterialVersion AS BillOfMaterialVersion,
  valid_items.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  stko.EngineeringChangeDocument AS HeaderChangeDocument,
  stko.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  case valid_items.BillOfMaterialCategory when 'E' then stko._Eqst.Plant when 'T' then stko._Tpst.Plant when 'M' then stko._Mast.Plant else '' end as Plant AS PlantelseendasPlant,
  case valid_items.BillOfMaterialCategory when 'E' then stko._Eqst.Equipment when 'T' then stko._Tpst.FunctionalLocation when 'M' then stko._Mast.Material else '' end as TechnicalObject AS MaterialelseendasTechnicalObject,
  stko.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  valid_items.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  stko.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  valid_items.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  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.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  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 abap.char( 4 ) ) AS BillOfMaterialItemNumber,
  valid_items.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  valid_items.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  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.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.QuantityVariableSizeItem AS QuantityVariableSizeItem,
  valid_items.FormulaKey AS FormulaKey,
  valid_items.BOMItemDescription AS BOMItemDescription,
  valid_items.BOMItemText2 AS BOMItemText2,
  valid_items.LongTextLanguage AS LongTextLanguage,
  valid_items.ComponentDescription AS ComponentDescription,
  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.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 abap.char( 8 ) ) AS OrigSalesOrderBOM,
  valid_items.OrigSalesOrderBOMItmNodeNumber AS OrigSalesOrderBOMItmNodeNumber,
  valid_items.OrigSalesOrderBOMItmNumber AS OrigSalesOrderBOMItmNumber,
  valid_items._BOMItemCategory AS _BOMItemCategory,
  valid_items._UnitOfMeasure AS _UnitOfMeasure,
  valid_items._Currency AS _Currency
FROM I_BillOfMaterialComponent AS valid_items
INNER JOIN I_BillOfMaterial AS stko ON /* join condition not captured in parsed metadata */
;