P_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 P_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: PMPEOAIAMAT

CREATE VIEW P_OpActyInstanceAssembledComp AS
SELECT
  MfgOrderComponentAssembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderComponentAssembly.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOrderComponentAssembly.Reservation AS Reservation,
  MfgOrderComponentAssembly.ReservationItem AS ReservationItem,
  MfgOrderComponentAssembly.RecordType AS RecordType,
  MfgOrderComponentAssembly.Material AS Material,
  MfgOrderComponentAssembly.Plant AS Plant,
  cast(max(ReservationItem.StorageLocation) as lgort_d preserving type ) AS StorageLocation,
  cast(max(OpActyComponentAssignment.BOOOpBOMItemInternalID) as cim_zuord preserving type ) AS BOOOpBOMItemInternalID,
  cast(max(OpActyComponentAssignment.MfgOrderComponentUsageNetQty) as esmng preserving type ) AS MfgOrderComponentUsageNetQty,
  cast(sum(MfgOrderComponentAssembly.MaterialComponentQuantity) as kmpmg preserving type ) AS MaterialComponentQuantity,
  cast(max(MfgOrderComponentAssembly.MaterialBaseUnit) as meins preserving type ) AS BaseUnit,
  cast(sum(MfgOrderComponentAssembly.QuantityInEntryUnit) as erfmgv preserving type ) AS QuantityInEntryUnit,
  cast(max(MfgOrderComponentAssembly.EntryUnit) as erfme preserving type ) AS EntryUnit,
  cast('' as mpe_comp_is_for_backflush preserving type) AS MatlCompIsMarkedForBackflush,
  cast(coalesce(ReservationItem.GoodsMovementIsAllowed, 'X') as xwaok preserving type ) AS GoodsMovementIsAllowed,
  cast(max(OpActyComponentAssignment.MatlCompInstceAssyIsRequired) as mpe_instce_assembly_rqd preserving type) AS MatlCompInstceAssyIsRequired,
  OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyComponentAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyComponentAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstanceStatus._OperationActivityInstance AS _OperationActivityInstance
FROM I_MfgOrderComponentAssembly AS MfgOrderComponentAssembly
INNER JOIN I_OpActyComponentAssignment AS OpActyComponentAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderComponent AS OrderComponent ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrderBasic AS LogisticsOrderBasic ON /* join condition not captured in parsed metadata */
;