P_BOMComponentsWithKeyDate

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 P_BOMComponentsWithKeyDate.
-- 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: PBOMCOMPWITHDATE

CREATE VIEW P_BOMComponentsWithKeyDate AS
SELECT
  valid_items.BillOfMaterialCategory AS BillOfMaterialCategory,
  valid_items.BillOfMaterial AS BillOfMaterial,
  valid_items.BillOfMaterialVariant AS BillOfMaterialVariant,
  valid_items.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  valid_items.BillOfMaterialVersion AS BillOfMaterialVersion,
  valid_items.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  valid_items.ValidityStartDate AS ValidityStartDate,
  valid_items.ValidityEndDate AS ValidityEndDate,
  valid_items.ChangeNumberFrom AS EngineeringChangeDocument,
  valid_items.ChangeNumberTo 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,
  valid_items.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  valid_items.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  valid_items.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  valid_items.IsAssembly 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.FormulaKey AS FormulaKey,
  valid_items.BOMItemDescription AS BOMItemDescription,
  valid_items.BOMItemText2 AS BOMItemText2,
  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.UnitOfMeasureForVarSizeItem AS UnitOfMeasureForVarSizeItem,
  valid_items.AlternativeItemGroup AS AlternativeItemGroup,
  valid_items.AlternativeItemPriority AS AlternativeItemPriority,
  valid_items.AlternativeItemStrategy AS AlternativeItemStrategy,
  valid_items.UsageProbabilityPercent AS UsageProbabilityPercent,
  valid_items.IsPhantomItem AS IsPhantomItem,
  valid_items.LastChangeDateTime AS LastChangeDateTime
FROM P_BOMItems AS valid_items
;