P_SFIOpActyUnplndCompAssmblAgg

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_SFIOpActyUnplndCompAssmblAgg.
-- 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: PMPESFIUPCMPASAG

CREATE VIEW P_SFIOpActyUnplndCompAssmblAgg AS
SELECT
  MfgOrderComponentAssembly.Reservation AS Reservation,
  MfgOrderComponentAssembly.ReservationItem AS ReservationItem,
  MfgOrderComponentAssembly.RecordType AS RecordType,
  MfgOrderComponentAssembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderComponentAssembly.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOrderComponentAssembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  MfgOrderComponentAssembly.Material AS Material,
  MfgOrderComponentAssembly.Plant AS Plant,
  count(*) AS NumberOfAssembledMaterials,
  cast(sum(MfgOrderComponentAssembly.MaterialComponentQuantity) as kmpmg preserving type) AS MaterialComponentQuantity,
  cast(max(MfgOrderComponentAssembly.MaterialBaseUnit) as meins preserving type) AS MaterialBaseUnit,
  cast(sum(MfgOrderComponentAssembly.QuantityInEntryUnit) as erfmgv preserving type) AS QuantityInEntryUnit,
  cast(max(MfgOrderComponentAssembly.EntryUnit) as erfme preserving type) AS EntryUnit,
  cast(max(MfgOrderComponentAssembly.ShopFloorItem) as mpe_sfi_id preserving type) AS ShopFloorItem,
  cast(max(MfgOrderComponentAssembly.Batch) as charg_d preserving type) AS Batch,
  MfgOrderComponentAssembly._Reservation AS _Reservation,
  MfgOrderComponentAssembly._ReservationItem AS _ReservationItem,
  MfgOrderComponentAssembly._OpActyNtwkInstance AS _OpActyNtwkInstance,
  MfgOrderComponentAssembly._OperationActivityInstance AS _OperationActivityInstance,
  MfgOrderComponentAssembly._ParentShopFloorItem AS _ParentShopFloorItem,
  MfgOrderComponentAssembly._Material AS _Material
FROM I_MfgOrderComponentAssembly AS MfgOrderComponentAssembly
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [0..1]
;