I_OpActyInstanceComponent

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_OpActyInstanceComponent.
-- 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_OpActyInstanceComponent AS
SELECT
  OpActyComponentAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyComponentAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyComponentAssignment.Reservation AS Reservation,
  OpActyComponentAssignment.ReservationItem AS ReservationItem,
  OpActyComponentAssignment.RecordType AS RecordType,
  OpActyComponentAssignment.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  OpActyComponentAssignment.MfgOrderComponentUsageNetQty AS MfgOrderComponentUsageNetQty,
  OpActyComponentAssignment.AssemblySequenceNumber AS AssemblySequenceNumber,
  OpActyComponentAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyComponentAssignment.LogicalComponent AS LogicalComponent,
  OpActyComponentAssignment.ComponentAssemblyType AS ComponentAssemblyType,
  OpActyComponentAssignment.RelatedReservation AS RelatedReservation,
  OpActyComponentAssignment.RelatedReservationItem AS RelatedReservationItem,
  OpActyComponentAssignment.RelatedRecordType AS RelatedRecordType,
  OpActyComponentAssignment.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OpActyComponentAssignment.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OpActyComponentAssignment.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyComponentAssignment.PlannedInventoryUsabilityCode AS PlannedInventoryUsabilityCode,
  OpActyComponentAssignment.LeadingReservation AS LeadingReservation,
  OpActyComponentAssignment.LeadingReservationItem AS LeadingReservationItem,
  OpActyComponentAssignment.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyComponentAssignment.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyComponentAssignment.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyComponentAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyComponentAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyComponentAssignment.MatlCompAssemblyIsNotRequired AS MatlCompAssemblyIsNotRequired,
  resb.aufnr AS ManufacturingOrder,
  cast(resb.aufpl as pph_aufpl preserving type) AS OrderInternalBillOfOperations,
  cast(resb.aplzl as operationinternalid preserving type) AS OrderIntBillOfOperationsItem,
  resb.matnr AS Material,
  resb.werks AS Plant,
  resb.lgort AS StorageLocation,
  resb.meins AS BaseUnit,
  resb.charg AS Batch,
  resb.splkz AS BatchSplitType,
  resb.bdmng AS RequiredQuantity,
  cast(resb.nomng as pph_nomng preserving type) AS MaterialCompOriginalQuantity,
  resb.erfme AS EntryUnit,
  cast(resb.erfmg as pph_erfmg preserving type) AS GoodsMovementEntryQty,
  resb.kzear AS ReservationIsFinallyIssued,
  resb.fmeng AS QuantityIsFixed,
  cast(resb.xloek as pph_xloek preserving type) AS MatlCompIsMarkedForDeletion,
  resb.xfehl AS MaterialComponentIsMissing,
  resb.schgt AS IsBulkMaterialComponent,
  resb.rgekz AS MatlCompIsMarkedForBackflush,
  resb.txtps AS MatlCompIsTextItem,
  cast(resb.no_disp as vdm_no_disp preserving type) AS MaterialPlanningRelevance,
  resb.kfpos AS MatlCompIsConfigurable,
  cast(resb.shkzg as pph_shkzg preserving type) AS DebitCreditCode,
  resb.xwaok AS GoodsMovementIsAllowed,
  resb.kzaus AS MatlCompDiscontinuationType,
  resb.techs AS EffectivityParameterVariant,
  resb.baugr AS Assembly,
  resb.rohps AS MaterialCompIsVariableSized,
  cast(resb.roanz as pph_roanz preserving type) AS VariableSizeItemQuantity,
  cast(resb.rokme as pph_rokme preserving type) AS VariableSizeComponentUnit,
  cast(resb.romen as pph_romen preserving type) AS VariableSizeComponentQuantity,
  resb.romei AS VariableSizeDimensionUnit,
  resb.roms1 AS VariableSizeDimension1,
  resb.roms2 AS VariableSizeDimension2,
  resb.roms3 AS VariableSizeDimension3,
  resb.rform AS FormulaKey,
  cast(resb.stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  cast(resb.stlnr as pph_stnum preserving type) AS BillOfMaterialInternalID,
  resb.stlal AS BillOfMaterialVariant,
  cast(resb.stlkn as pph_stlkn preserving type) AS BOMItem,
  resb.bom_versn AS BillOfMaterialVersion,
  resb.stpoz AS BOMItemInternalChangeCount,
  resb.stvkn AS InheritedBOMItemNode,
  cast(resb.postp as pph_postp preserving type) AS BOMItemCategory,
  cast(resb.posnr as vdm_sposn preserving type) AS BillOfMaterialItemNumber,
  resb.potx1 AS BOMItemDescription,
  resb.potx2 AS BOMItemText2,
  resb.original_rsnum AS OriginalReservation,
  resb.original_rspos AS OriginalReservationItem,
  cast(resb.alpgr as pph_alpgr preserving type) AS AlternativeItemGroup,
  resb.alpos AS MaterialCompIsAlternativeItem,
  MfgBOMItemCategoryAddlParam.ComponentIsToBeReworked AS ComponentIsToBeReworked,
  OpActyComponentAssignment._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyComponentAssignment._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  OpActyComponentAssignment._OperationActivityInstance AS _OperationActivityInstance,
  OpActyComponentAssignment._ReservationHeader AS _ReservationHeader,
  OpActyComponentAssignment._ReltdOpActyCompAssignment AS _ReltdOpActyCompAssignment,
  OpActyComponentAssignment._PlannedInventoryUsblyCode AS _PlannedInventoryUsblyCode,
  OpActyComponentAssignment._BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt,
  OpActyComponentAssignment._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OpActyComponentAssignment._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails
FROM I_OpActyComponentAssignment AS OpActyComponentAssignment
INNER JOIN resb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND RecordType = _ReservationItem.RecordType  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocRecordType AS _ReservationDocRecordType ON RecordType = _ReservationDocRecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBasic AS _MfgOrderOperation ON OrderInternalBillOfOperations = _MfgOrderOperation.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _MfgOrderOperation.OrderIntBillOfOperationsItem  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlantBasic ON Material = _ProductPlantBasic.Product AND Plant = _ProductPlantBasic.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_Batch AS _Batch ON Plant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_BatchSplitType AS _BatchSplitType ON BatchSplitType = _BatchSplitType.BatchSplitType  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BOMItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EntryUnit ON EntryUnit = _EntryUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_MatlCompDiscontinuationType AS _MatlCompDiscontinuationType ON MatlCompDiscontinuationType = _MatlCompDiscontinuationType.MatlCompDiscontinuationType  -- association [0..1]
;