I_OpActyInstanceAssembledComp

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_OpActyInstanceAssembledComp.
-- 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.
-- SQL view name: IMPEOAIAAMAT

CREATE VIEW I_OpActyInstanceAssembledComp AS
SELECT
  OpActyInstanceAssembledComp.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstanceAssembledComp.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstanceAssembledComp.Reservation AS Reservation,
  OpActyInstanceAssembledComp.ReservationItem AS ReservationItem,
  OpActyInstanceAssembledComp.RecordType AS RecordType,
  OpActyInstanceAssembledComp.Material AS Material,
  OpActyInstanceAssembledComp.StorageLocation AS StorageLocation,
  OpActyInstanceAssembledComp.BaseUnit AS MaterialBaseUnit,
  cast(round(fltp_to_dec( OpActyInstanceAssembledComp.RequiredQuantity as abap.dec(13,4) ), 3) as co_menge ) as RequiredQuantity AS dec1343asco_mengeasRequiredQuantity,
  OpActyInstanceAssembledComp.MaterialComponentQuantity AS MaterialComponentQuantity,
  OpActyInstanceAssembledComp.ResvnItmWithdrawnQtyInBaseUnit AS ResvnItmWithdrawnQtyInBaseUnit,
  OpActyInstanceAssembledComp.EntryUnit AS EntryUnit,
  OpActyInstanceAssembledComp.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  OpActyInstanceAssembledComp.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OpActyInstanceAssembledComp.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyInstanceAssembledComp.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyInstanceAssembledComp.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstanceAssembledComp.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  OpActyInstanceAssembledComp.MfgOrderOperationText AS MfgOrderOperationText,
  OpActyInstanceAssembledComp.OperationActivity AS OperationActivity,
  OpActyInstanceAssembledComp.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyInstanceAssembledComp.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyInstanceAssembledComp.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OpActyInstanceAssembledComp.BillOfOperationsType AS BillOfOperationsType,
  OpActyInstanceAssembledComp.BillOfOperationsGroup AS BillOfOperationsGroup,
  OpActyInstanceAssembledComp.MatlCompAssembleControl AS MatlCompAssembleControl,
  OpActyInstanceAssembledComp.SerialNumberProfile AS SerialNumberProfile,
  OpActyInstanceAssembledComp.SerialNumberIsRqdForAssembly AS SerialNumberIsRqdForAssembly,
  OpActyInstanceAssembledComp.IsBatchManagementRequired AS IsBatchManagementRequired,
  OpActyInstanceAssembledComp.StockCheckMessageType AS StockCheckMessageType,
  OpActyInstanceAssembledComp.BillOfMaterialCategory AS BillOfMaterialCategory,
  OpActyInstanceAssembledComp.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyInstanceAssembledComp.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyInstanceAssembledComp.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyInstanceAssembledComp.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  OpActyInstanceAssembledComp.BOMItem AS BOMItem,
  OpActyInstanceAssembledComp.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstanceAssembledComp.BOMItemCategory AS BOMItemCategory,
  OpActyInstanceAssembledComp.FormulaKey AS FormulaKey,
  OpActyInstanceAssembledComp.VariableSizeDimension1 AS VariableSizeDimension1,
  OpActyInstanceAssembledComp.VariableSizeDimension2 AS VariableSizeDimension2,
  OpActyInstanceAssembledComp.VariableSizeDimension3 AS VariableSizeDimension3,
  OpActyInstanceAssembledComp.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  OpActyInstanceAssembledComp.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OpActyInstanceAssembledComp.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OpActyInstanceAssembledComp.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyInstanceAssembledComp.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyInstanceAssembledComp.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstanceAssembledComp._OrderComponent AS _OrderComponent,
  OpActyInstanceAssembledComp._BOMItemCategory AS _BOMItemCategory,
  OpActyInstanceAssembledComp._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstanceAssembledComp._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstanceAssembledComp._OperationActivityText AS _OperationActivityText,
  OpActyInstanceAssembledComp._Reservation AS _Reservation,
  OpActyInstanceAssembledComp._MfgOrder AS _MfgOrder,
  OpActyInstanceAssembledComp._Material AS _Material,
  OpActyInstanceAssembledComp._Plant AS _Plant,
  OpActyInstanceAssembledComp._StorageLocation AS _StorageLocation,
  OpActyInstanceAssembledComp._MatlCompAssembleControl AS _MatlCompAssembleControl,
  OpActyInstanceAssembledComp._OpActyCompInstceAssignment AS _OpActyCompInstceAssignment,
  OpActyInstanceAssembledComp._OpActyBOOOpBOMIndivItmAssgmt AS _OpActyBOOOpBOMIndivItmAssgmt,
  OpActyInstanceAssembledComp._MfgOrderCompAssemblyAggrgn AS _MfgOrderCompAssemblyAggrgn,
  OpActyInstanceAssembledComp._BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt,
  OpActyInstanceAssembledComp._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OpActyInstanceAssembledComp._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails
FROM P_OpActyInstanceAssembledComp2 AS OpActyInstanceAssembledComp
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]
;