P_SFOTrcblPlndCompAssembly

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_SFOTrcblPlndCompAssembly.
-- 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_SFOTrcblPlndCompAssembly AS
SELECT
  MfgOrderComponentAssembly.AssemblyDocument AS AssemblyDocument,
  MfgOrderComponentAssembly.AssemblyDocumentItem AS AssemblyDocumentItem,
  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.ShopFloorItem AS ShopFloorItem,
  MfgOrderComponentAssembly.Batch AS Batch,
  MfgOrderComponentAssembly.Material AS Material,
  MfgOrderComponentAssembly.Plant AS Plant,
  MfgOrderComponentAssembly.StorageLocation AS StorageLocation,
  MfgOrderComponentAssembly.InventoryUsabilityCode AS InventoryUsabilityCode,
  OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyComponentAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyComponentAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  cast(LogisticsOrder.OrderPlannedTotalQty as esmng) * OpActyComponentAssignment.MfgOrderComponentUsageNetQty AS RequiredQuantity,
  MfgOrderComponentAssembly.MaterialComponentQuantity AS MaterialComponentQuantity,
  MfgOrderComponentAssembly.MaterialBaseUnit AS MaterialBaseUnit,
  MfgOrderComponentAssembly.QuantityInEntryUnit AS QuantityInEntryUnit,
  MfgOrderComponentAssembly.EntryUnit AS EntryUnit,
  MfgOrderComponentAssembly.DebitCreditCode AS DebitCreditCode,
  OpActyComponentAssignment.ComponentAssemblyType AS ComponentAssemblyType,
  OpActyNtwkInstanceBasic.ManufacturingOrder AS ManufacturingOrder,
  OpActyComponentAssignment.LeadingReservation AS LeadingReservation,
  OpActyComponentAssignment.LeadingReservationItem AS LeadingReservationItem,
  OpActyComponentAssignment.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyComponentAssignment.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyComponentAssignment.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  OpActyComponentAssignment.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  MfgOrderComponentAssembly._Material AS _Material,
  OpActyNtwkInstanceBasic._ManufacturingOrder AS _ManufacturingOrder
FROM I_MfgOrderComponentAssembly AS MfgOrderComponentAssembly
INNER JOIN I_OpActyNtwkInstanceBasic AS OpActyNtwkInstanceBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrder AS LogisticsOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlantBasic ON Material = _ProductPlantBasic.Product AND Plant = _ProductPlantBasic.Plant  -- association [0..1]
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]
;