I_ProdnModOpActyComponent

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_ProdnModOpActyComponent.
-- 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 I_ProdnModOpActyComponent AS
SELECT
  BOMItem.ProductionModelUUID AS ProductionModelUUID,
  BOMItem.BillOfOperationsVersion AS BillOfOperationsVersion,
  BOOOperationDetails.BOOOperationInternalID AS BOOOperationInternalID,
  OperationActivityComponent.OperationActivity AS OperationActivity,
  OperationActivityComponent.OperationActyVersionCounter AS OperationActyVersionCounter,
  OperationActivityComponent.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  BOOOperationDetails.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  BOMItem.BillOfMaterial AS BillOfMaterial,
  BOMItem.BillOfMaterialVariant AS BillOfMaterialVariant,
  BOMItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  BOMItem.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOMItem.Plant AS Plant,
  BOMItem.BillOfOperationsGroup AS BillOfOperationsGroup,
  BOMItem.BillOfOperationsType AS BillOfOperationsType,
  BOMItem.BillOfOperationsVariant AS BillOfOperationsVariant,
  BOMItem.Material AS Material,
  BOMItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpactivityNetworkElement.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  BOMItem.ProductionModelComponentUUID AS ProductionModelComponentUUID,
  BOMItem.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  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,
  OperationActivityComponent.BillOfMaterialItemQuantity AS ProdnModBOMCompAssgdQuantity,
  OperationActivityComponent.BillOfMaterialItemUnit AS ProdnModBOMCompAssgdQtyUnit,
  BOMItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  BOMItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  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,
  _MaterialPlant.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  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,
  OperationActivityComponent.AssemblySequenceNumber AS AssemblySequenceNumber,
  BOMItem.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  BOMItem.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  BOMItem.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  BOMItem.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  OperationActivityComponent.CreatedByUser AS CreatedByUser,
  OperationActivityComponent.CreationDateTime AS CreationDateTime,
  OperationActivityComponent.ChangedBy AS ChangedBy,
  OperationActivityComponent.LastChangeDateTime AS LastChangeDateTime
FROM I_OpActyBOOOpBOMItmAssgmt AS OperationActivityComponent
INNER JOIN I_OpActyNtwkElement AS OpactivityNetworkElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOOperationChgStOANBasic AS BOOOperationDetails ON /* join condition not captured in parsed metadata */
INNER JOIN I_RoutingCompAllocSrchMod AS OperationComponent ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProductionModelComponent AS BOMItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = BOMItem.BillOfMaterialComponent AND _MaterialText.Language = $session.system_language  -- association [0..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_MRPQuantityDistrKeyText AS _DistrKeyText ON Plant = _DistrKeyText.Plant AND DistrKeyCompConsumption = _DistrKeyText.QuantityDistributionKey AND _DistrKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ExplosionTypeVH AS _ExplosionTypeText ON ExplosionType = _ExplosionTypeText.ExplosionType  -- association [0..1]
LEFT OUTER JOIN I_SpecialProcurementType AS _SpecialProcTypeText ON Plant = _SpecialProcTypeText.Plant AND SpecialProcurementType = _SpecialProcTypeText.SpecialProcurementType  -- association [0..1]
LEFT OUTER JOIN I_AltItemStrategyVH AS _AltItemStrategyText ON AlternativeItemStrategy = _AltItemStrategyText.AlternativeItemStrategy AND _AltItemStrategyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ReferencePointVH AS _ReferencePointText ON ReferencePoint = _ReferencePointText.ReferencePoint  -- association [0..1]
LEFT OUTER JOIN I_BOMItemCostingRelevant AS _CostingRelevantText ON MaterialCompCostingRelevancy = _CostingRelevantText.BOMItemIsCostingRelevant  -- association [0..1]
LEFT OUTER JOIN I_MatProvisionIndicatorVH AS _MatProvisionIndText ON MaterialProvisionType = _MatProvisionIndText.IsMaterialProvision  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _IssueLocationText ON Plant = _IssueLocationText.Plant AND ProdOrderIssueLocation = _IssueLocationText.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyAreaText AS _ProdSupplyAreaText ON Plant = _ProdSupplyAreaText.Plant AND ProductionSupplyArea = _ProdSupplyAreaText.ProductionSupplyArea AND _ProdSupplyAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BOMItemSparePart AS _SparePartText ON MatlComponentSparePartType = _SparePartText.BOMItemIsSparePart  -- association [0..1]
LEFT OUTER JOIN I_BOMItemSalesRelevant AS _SalesRelevantText ON BOMItemSalesRelevancy = _SalesRelevantText.BOMItemIsSalesRelevant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrgText ON PurchasingOrganization = _PurchasingOrgText.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroupText ON PurchasingGroup = _PurchasingGroupText.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Creditor = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CostElementText AS _CostElementText ON CostElement = _CostElementText.CostElement AND _CostElementText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _MaterialPlant ON BillOfMaterialComponent = _MaterialPlant.Product AND Plant = _MaterialPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProdnModOpActyCompInstance AS _OpActivityComponentInstance ON ProductionModelUUID = _OpActivityComponentInstance.ProductionModelUUID AND BillOfOperationsVersion = _OpActivityComponentInstance.BillOfOperationsVersion AND BOOOperationInternalID = _OpActivityComponentInstance.BOOOperationInternalID AND OperationActivity = _OpActivityComponentInstance.OperationActivity AND OperationActyVersionCounter = _OpActivityComponentInstance.OperationActyVersionCounter AND BOOOpBOMItemInternalID = _OpActivityComponentInstance.BOOOpBOMItemInternalID  -- association [0..*]
;