P_OpActyInstcePlndComponent

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_OpActyInstcePlndComponent.
-- 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_OpActyInstcePlndComponent AS
SELECT
  OpActyComponentAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceOpActyNtwkBasic.ManufacturingOrder AS ManufacturingOrder,
  cast(OrderOperation.Plant as pwwrk preserving type) AS ProductionPlant,
  MfgOrderOperationComponent.StorageLocation AS StorageLocation,
  cast('2' as mpe_oan_segment_type preserving type) AS OpActyNtwkSegmentType,
  MfgOrderOperationComponent.BaseUnit AS BaseUnit,
  cast(round(fltp_to_dec( case MfgOrderOperationComponent.QuantityIsFixed when 'X' then OpActyComponentAssignment.MfgOrderComponentUsageNetQty else cast( OrderOperation.OpPlannedTotalQuantity * OrderOperation.OpQtyToBaseQtyNmrtr as esmng ) / cast( OrderOperation.OpQtyToBaseQtyDnmntr as esmng ) * OpActyComponentAssignment.MfgOrderComponentUsageNetQty end as abap.dec(13,4) ), 3) as co_menge ) as RequiredQuantity AS dec1343asco_mengeasRequiredQuantity,
  MatlPlntCompAssembleControl.SerialNumberProfile AS SerialNumberProfile,
  MatlPlntCompAssembleControl.StockCheckMessageType AS StockCheckMessageType,
  MatlPlntCompAssembleControl.IsBatchManagementRequired AS IsBatchManagementRequired,
  MfgOrderOperationComponent.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  MfgOrderOperationComponent.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  MfgOrderOperationComponent.EffectivityParameterVariant AS EffectivityParameterVariant,
  MfgOrderOperationComponent.Assembly AS Assembly,
  MfgOrderOperationComponent.VariableSizeCompFormulaKey AS FormulaKey,
  MfgOrderOperationComponent.VariableSizeDimension1 AS VariableSizeDimension1,
  MfgOrderOperationComponent.VariableSizeDimension2 AS VariableSizeDimension2,
  MfgOrderOperationComponent.VariableSizeDimension3 AS VariableSizeDimension3,
  MfgOrderOperationComponent.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  MfgOrderOperationComponent.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  MfgOrderOperationComponent.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  MfgOrderOperationComponent.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  MfgOrderOperationComponent.AlternativeItemGroup AS AlternativeItemGroup,
  MfgOrderOperationComponent.AlternativeItemStrategy AS AlternativeItemStrategy,
  MfgOrderOperationComponent.AlternativeItemPriority AS AlternativeItemPriority,
  MfgOrderOperationComponent.UsageProbabilityPercent AS UsageProbabilityPercent,
  MfgOrderOperationComponent.AlternativeMstrReservationItem AS AlternativeMstrReservationItem,
  MfgOrderOperationComponent.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  MfgOrderOperationComponent.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  MfgOrderOperationComponent.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  OpActyComponentAssignment.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyComponentAssignment.MatlCompAssemblyIsNotRequired AS MatlCompAssemblyIsNotRequired,
  MfgOrderOperationComponent.BOMItemCategory AS BOMItemCategory,
  OpActyComponentAssignment.RelatedReservationItem AS RelatedReservationItem,
  OpActyComponentAssignment.RelatedRecordType AS RelatedRecordType,
  OpActyComponentAssignment.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OpActyComponentAssignment.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OpActyComponentAssignment.LeadingReservation AS LeadingReservation,
  OpActyComponentAssignment.LeadingReservationItem AS LeadingReservationItem,
  OpActyComponentAssignment.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyComponentAssignment.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyComponentAssignment.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  cast( MfgOrderOperationComponent.BillOfMaterialInternalID as mpe_exec_stnum preserving type ) AS BillOfMaterialInternalID,
  MfgOrderOperationComponent.BillOfMaterialVersion AS BillOfMaterialVersion,
  MfgOrderOperationComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  MfgOrderOperationComponent.InheritedBOMItemNode AS InheritedBOMItemNode,
  MfgOrderOperationComponent.BOMItem AS BOMItem,
  MfgOrderOperationComponent.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstceOpActyNtwkBasic.BillOfOperationsType AS BillOfOperationsType,
  OpActyInstceOpActyNtwkBasic.BillOfOperationsGroup AS BillOfOperationsGroup,
  OpActyComponentAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyComponentAssignment.LogicalComponent AS LogicalComponent,
  OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyComponentAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyComponentAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstceOpActyNtwkBasic.OrderInternalID AS OrderInternalID,
  OpActyInstceOpActyNtwkBasic.OrderOperationInternalID AS OrderOperationInternalID,
  OpActyInstceOpActyNtwkBasic._MfgOrder AS _MfgOrder,
  OpActyInstceOpActyNtwkBasic._MfgOrderOperation AS _MfgOrderOperation,
  OpActyComponentAssignment._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OpActyComponentAssignment._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails,
  OpActyComponentAssignment._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic
FROM I_OpActyComponentAssignment AS OpActyComponentAssignment
INNER JOIN I_OrderComponentBasic AS MfgOrderOperationComponent ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperation AS OrderOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_EAMMaterialItemCategory AS MaterialItemCategory ON /* join condition not captured in parsed metadata */
INNER JOIN I_MatlPlntCompAssembleControl AS MatlPlntCompAssembleControl ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyInstceOpActyNtwkBasic AS OpActyInstceOpActyNtwkBasic 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_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BillOfMaterialItem ON BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterialInternalID = _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 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_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]
;