C_OperationActivityComponent

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 C_OperationActivityComponent.
-- 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 C_OperationActivityComponent AS
SELECT
  OperationActivityComponent.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceNtwkElmntBasic.ManufacturingOrder AS ManufacturingOrder,
  OperationActivityComponent.ProductionPlant AS ProductionPlant,
  OperationActivityComponent.StorageLocation AS StorageLocation,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  cast('2' as mpe_oan_segment_type preserving type) AS OpActyNtwkSegmentType,
  needed for DCL OperationActivityComponent.AssemblySequenceNumber AS AssemblySequenceNumber,
  OperationActivityComponent.BaseUnit AS BaseUnit,
  OperationActivityComponent.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  OperationActivityComponent.RequiredQuantity AS RequiredQuantity,
  OperationActivityComponent.MaterialComponentQuantity AS MaterialComponentQuantity,
  case when OperationActivityComponent.MaterialComponentQuantity = 0 or OperationActivityComponent.MaterialComponentQuantity is null then 0 AS RequiredQuantitythen1red,
  because overfilled when OperationActivityComponent.MaterialComponentQuantity = OperationActivityComponent.RequiredQuantity then 3 AS RequiredQuantitythen3greenelse2yellow,
  OperationActivityComponent.SerialNumberProfile AS SerialNumberProfile,
  OperationActivityComponent.StockCheckMessageType AS StockCheckMessageType,
  OperationActivityComponent.IsBatchManagementRequired AS IsBatchManagementRequired,
  cast (OperationActivityComponent.Batch as vdm_charg_plan preserving type ) AS Batch,
  cast( OperationActivityComponent.MatlCompIsMarkedForBackflush as boolean preserving type ) AS MatlCompIsMarkedForBackflush,
  OperationActivityComponent.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  OperationActivityComponent.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OperationActivityComponent.FormulaKey AS FormulaKey,
  OperationActivityComponent.VariableSizeDimension1 AS VariableSizeDimension1,
  OperationActivityComponent.VariableSizeDimension2 AS VariableSizeDimension2,
  OperationActivityComponent.VariableSizeDimension3 AS VariableSizeDimension3,
  OperationActivityComponent.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  cast('' as mpe_vsi_formatted_formula) AS VarblSizeCompFrmtdFormulaVal,
  OperationActivityComponent.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OperationActivityComponent.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OperationActivityComponent.MatlCompAssembleControl AS MatlCompAssembleControl,
  OperationActivityComponent._MatlCompAssembleControl._Text[1: Language=$session.system_language].MatlCompAssembleControlName AS MatlCompAssembleControlName,
  OperationActivityComponent.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OperationActivityComponent.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  OperationActivityComponent.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  OperationActivityComponent.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OperationActivityComponent.MatlCompAssemblyIsNotRequired AS MatlCompAssemblyIsNotRequired,
  OperationActivityComponent.BOMItemCategory AS BOMItemCategory,
  OperationActivityComponent._BOMItemCategory._ItemCategoryT[1: Language=$session.system_language].BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  OperationActivityComponent.RelatedReservationItem AS RelatedReservationItem,
  OperationActivityComponent.RelatedRecordType AS RelatedRecordType,
  OperationActivityComponent.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OperationActivityComponent.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OperationActivityComponent.LeadingReservation AS LeadingReservation,
  OperationActivityComponent.LeadingReservationItem AS LeadingReservationItem,
  OperationActivityComponent.LeadingReservationRecordType AS LeadingReservationRecordType,
  OperationActivityComponent.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OperationActivityComponent.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  OperationActivityComponent.AlternativeItemGroup AS AlternativeItemGroup,
  OperationActivityComponent.AlternativeItemStrategy AS AlternativeItemStrategy,
  OperationActivityComponent.AlternativeItemPriority AS AlternativeItemPriority,
  OperationActivityComponent.UsageProbabilityPercent AS UsageProbabilityPercent,
  OperationActivityComponent.OriginalReservation AS OriginalReservation,
  OperationActivityComponent.OriginalReservationItem AS OriginalReservationItem,
  OperationActivityComponent.BillOfMaterial AS BillOfMaterial,
  OperationActivityComponent.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  OperationActivityComponent.BillOfMaterialVersion AS BillOfMaterialVersion,
  OperationActivityComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  OperationActivityComponent.InheritedBOMItemNode AS InheritedBOMItemNode,
  OperationActivityComponent.BOMItem AS BOMItem,
  OperationActivityComponent.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstceNtwkElmntBasic.BillOfOperationsType AS BillOfOperationsType,
  OpActyInstceNtwkElmntBasic.BillOfOperationsGroup AS BillOfOperationsGroup,
  OperationActivityComponent.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OperationActivityComponent.LogicalComponent AS LogicalComponent,
  OperationActivityComponent.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OperationActivityComponent.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OperationActivityComponent.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstceNtwkElmntBasic.OperationActivity AS OperationActivity,
  OpActyInstceNtwkElmntBasic.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyInstceNtwkElmntBasic.OrderInternalID AS OrderInternalID,
  OpActyInstceNtwkElmntBasic.OrderOperationInternalID AS OrderOperationInternalID,
  OpActyInstceNtwkElmntBasic._MfgOrder AS _MfgOrder,
  OpActyInstceNtwkElmntBasic._MfgOrderOperation AS _MfgOrderOperation,
  OperationActivityComponent._StorageLocation AS _StorageLocation
FROM P_OperationActivityComponent AS OperationActivityComponent
INNER JOIN I_OpActyInstceNtwkElmntBasic AS OpActyInstceNtwkElmntBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND ProductionPlant = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BillOfMaterialItem ON BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BOMItem = _BillOfMaterialItem.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItem.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN C_MfgOrderCompAssemblyAggrgn AS _MfgOrderCompAssemblyAggrgn ON Reservation = _MfgOrderCompAssemblyAggrgn.Reservation AND ReservationItem = _MfgOrderCompAssemblyAggrgn.ReservationItem AND RecordType = _MfgOrderCompAssemblyAggrgn.RecordType AND OpActyNtwkInstance = _MfgOrderCompAssemblyAggrgn.OpActyNtwkInstance AND OpActyNtwkElement = _MfgOrderCompAssemblyAggrgn.OpActyNtwkElement AND Material = _MfgOrderCompAssemblyAggrgn.Material AND _MfgOrderCompAssemblyAggrgn.AssemblyShopFloorItem = 0  -- association [0..*]
LEFT OUTER JOIN I_OpActyCompInstceAssignment AS _OpActyCompInstceAssignment ON Reservation = _OpActyCompInstceAssignment.Reservation AND ReservationItem = _OpActyCompInstceAssignment.ReservationItem AND RecordType = _OpActyCompInstceAssignment.RecordType AND OpActyNtwkInstance = _OpActyCompInstceAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyCompInstceAssignment.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_OpActyBOOOpBOMIndivItmAssgmt AS _OpActyBOOOpBOMIndivItmAssgmt ON OperationActivity = _OpActyBOOOpBOMIndivItmAssgmt.OperationActivity AND OperationActyVersionCounter = _OpActyBOOOpBOMIndivItmAssgmt.OperationActyVersionCounter AND BillOfOperationsType = _OpActyBOOOpBOMIndivItmAssgmt.BillOfOperationsType AND BillOfOperationsGroup = _OpActyBOOOpBOMIndivItmAssgmt.BillOfOperationsGroup AND BOOOpBOMItemInternalID = _OpActyBOOOpBOMIndivItmAssgmt.BOOOpBOMItemInternalID  -- association [0..*]
LEFT OUTER JOIN I_MfgBOMItemWithPhantomHier AS _MfgBOMItemWithPhantomHier ON BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory AND BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial AND BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant AND BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion AND InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr  -- association [0..1]
LEFT OUTER JOIN E_BillOfMaterialItemTP AS _BillOfMaterialItemExtension ON BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory AND BillOfMaterialInternalID = _BillOfMaterialItemExtension.BillOfMaterial AND BOMItem = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN E_ReservationDocumentItem AS _ReservationDocumentItem ON Reservation = _ReservationDocumentItem.Reservation AND ReservationItem = _ReservationDocumentItem.ReservationItem AND RecordType = _ReservationDocumentItem.RecordType  -- association [1..1]
;