P_ProdnModOperationComponent

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_ProdnModOperationComponent.
-- 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.

CREATE VIEW P_ProdnModOperationComponent AS
SELECT
  OperationComponent.BillOfOperationsGroup AS BillOfOperationsGroup,
  OperationComponent.BillOfOperationsType AS BillOfOperationsType,
  OperationComponent.BillOfOperationsVariant AS BillOfOperationsVariant,
  OperationComponent.BOOOperationInternalID AS BOOOperationInternalID,
  OperationComponent.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OperationComponent.BOOOpBOMItemIntVersCounter AS BOOOpBOMItemIntVersCounter,
  OperationComponent.BillOfOperationsSequence AS BillOfOperationsSequence,
  OperationComponent.BillOfOperationsVersion AS BillOfOperationsVersion,
  BOMItem.ProductionModelUUID AS ProductionModelUUID,
  OperationComponent.BillOfMaterial AS BillOfMaterial,
  OperationComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  OperationComponent.BillOfMaterialCategory AS BillOfMaterialCategory,
  OperationComponent.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  BOMItem.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOMItem.Plant AS Plant,
  BOMItem.Material AS Material,
  BOMItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  BOMItem.ProductionModelComponentUUID AS ProductionModelComponentUUID,
  BOMItem.ValidityStartDate AS ValidityStartDate,
  BOMItem.ValidityEndDate AS ValidityEndDate,
  BOMItem.EngineeringChangeDocument AS EngineeringChangeDocument,
  BOMItem.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  BOMItem.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  BOMItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  BOMItem.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  BOMItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  BOMItem.ComponentDescription AS ComponentDescription,
  BOMItem.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  cast( BOMItem.BillOfMaterialItemNumber as cs_sposn preserving type ) AS BillOfMaterialItemNumber,
  BOMItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  BOMItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  OperationComponent.BillOfMaterialItemQuantity AS ProdnModBOMCompAssgdQuantity,
  OperationComponent.BillOfMaterialItemUnit AS ProdnModBOMCompAssgdQtyUnit,
  BOMItem.IsAssembly AS IsAssembly,
  BOMItem.IsSubItem AS IsSubItem,
  BOMItem.IsDeleted AS IsDeleted,
  BOMItem.IdentifierBOMItem AS IdentifierBOMItem,
  BOMItem.BOMItemSorter AS BOMItemSorter,
  BOMItem.BOMItemHasFixedQuantity AS BOMItemHasFixedQuantity,
  BOMItem.ComponentScrapInPercent AS ComponentScrapInPercent,
  BOMItem.OperationScrapInPercent AS OperationScrapInPercent,
  BOMItem.IsNetScrap AS IsNetScrap,
  BOMItem.IsBulkMaterial AS IsBulkMaterial,
  BOMItem.IsMaterialProvision AS MaterialProvisionType,
  BOMItem.BOMItemIsSparePart AS MatlComponentSparePartType,
  BOMItem.BOMItemIsSalesRelevant AS BOMItemSalesRelevancy,
  BOMItem.IsEngineeringRelevant AS IsEngineeringRelevant,
  BOMItem.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  BOMItem.IsProductionRelevant AS IsProductionRelevant,
  BOMItem.BOMItemIsCostingRelevant AS MaterialCompCostingRelevancy,
  BOMItem.BOMIsRecursive AS BOMIsRecursive,
  BOMItem.IsBOMRecursiveAllowed AS IsBOMRecursiveAllowed,
  BOMItem.FollowUpGroup AS FollowUpGroup,
  BOMItem.AlternativeItemGroup AS AlternativeItemGroup,
  BOMItem.MaterialIsCoProduct AS MaterialIsCoProduct,
  BOMItem.AlternativeItemPriority AS AlternativeItemPriority,
  BOMItem.AlternativeItemStrategy AS AlternativeItemStrategy,
  BOMItem.IsALE AS IsALE,
  BOMItem.UsageProbabilityPercent AS UsageProbabilityPercent,
  BOMItem.IsPMAssemblyRelevant AS IsPMAssemblyRelevant,
  BOMItem.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  BOMItem.DependencyObjectNumber AS DependencyObjectNumber,
  BOMItem.DiscontinuationGroup AS DiscontinuationGroup,
  BOMItem.LeadTimeOffset AS LeadTimeOffset,
  BOMItem.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  BOMItem.OpsLeadTimeOffsetUnit AS OpsLeadTimeOffsetUnit,
  BOMItem.DistrKeyCompConsumption AS DistrKeyCompConsumption,
  BOMItem.IsPhantomItem AS IsPhantomItem,
  BOMItem.PurchasingGroup AS PurchasingGroup,
  BOMItem.DeliveryDurationInDays AS DeliveryDurationInDays,
  BOMItem.Creditor AS Creditor,
  BOMItem.MaterialComponentPrice AS MaterialComponentPrice,
  BOMItem.Currency AS Currency,
  BOMItem.CostElement AS CostElement,
  BOMItem.MaterialGroup AS MaterialGroup,
  BOMItem.GoodsReceiptDuration AS GoodsReceiptDuration,
  BOMItem.PurchasingOrganization AS PurchasingOrganization,
  BOMItem.PreliminaryMaterial AS PreliminaryMaterial,
  BOMItem.Size1 AS Size1,
  BOMItem.Size2 AS Size2,
  BOMItem.Size3 AS Size3,
  BOMItem.UnitOfMeasureForSize1To3 AS UnitOfMeasureForSize1To3,
  BOMItem.QuantityVariableSizeItem AS QuantityVariableSizeItem,
  cast(BOMItem.NumberOfVariableSizeItem as pph_roanz preserving type) AS VariableSizeItemQuantity,
  BOMItem.UnitOfMeasureForVarSizeItem AS VariableSizeItemUnit,
  BOMItem.FormulaKey AS FormulaKey,
  BOMItem.VariableSizeCompUnitOfMeasure AS VariableSizeCompUnitOfMeasure,
  BOMItem.BOMItemDescription AS BOMItemDescription,
  BOMItem.BOMItemText2 AS BOMItemText2,
  BOMItem.DocumentType AS DocumentType,
  BOMItem.DocNumber AS DocNumber,
  BOMItem.DocumentVersion AS DocumentVersion,
  BOMItem.DocumentPart AS DocumentPart,
  BOMItem.ProdOrderIssueLocation AS ProdOrderIssueLocation,
  BOMItem.ProductionSupplyArea AS ProductionSupplyArea,
  BOMItem.ExplosionType AS ExplosionType,
  BOMItem.SpecialProcurementType AS SpecialProcurementType,
  BOMItem.ReferencePoint AS ReferencePoint,
  BOMItem.BillOfMaterialItemObjectType AS BillOfMaterialItemObjectType,
  BOMItem.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  BOMItem.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  BOMItem.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  BOMItem.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  OperationComponent.CreatedByUser AS CreatedByUser,
  OperationComponent.CreationDate AS CreationDate,
  OperationComponent.LastChangeDate AS LastChangeDate,
  OperationComponent.LastChangedByUser AS LastChangedByUser
FROM I_RoutingCompAllocSrchMod AS OperationComponent
INNER JOIN P_ProductionModelComponent AS BOMItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BOMItemOldChangeState AS DeleteItemInOpComponent ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_RoutingCompAllocSrchMod
;