P_UnspltSFITrcblPlndCompAssy

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_UnspltSFITrcblPlndCompAssy.
-- 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_UnspltSFITrcblPlndCompAssy AS
SELECT
  MfgOrderComponentAssembly.AssemblyDocument AS AssemblyDocument,
  MfgOrderComponentAssembly.AssemblyDocumentItem AS AssemblyDocumentItem,
  cast(hextobin('00000000000000000000000000000000') as dmu_guid16 preserving type) AS OriglDgtlMockUpCharcsUUID,
  MfgOrderComponentAssembly.Reservation AS Reservation,
  MfgOrderComponentAssembly.ReservationItem AS ReservationItem,
  MfgOrderComponentAssembly.RecordType AS RecordType,
  MfgOrderComponentAssembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderComponentAssembly.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOrderComponentAssembly.AssemblyShopFloorItem AS OriginalReplacedShopFloorItem,
  MfgOrderComponentAssembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  MfgOrderComponentAssembly.ShopFloorItem AS AssembledShopFloorItem,
  MfgOrderComponentAssembly.Batch AS Batch,
  MfgOrderComponentAssembly.Material AS Material,
  MfgOrderComponentAssembly.Plant AS Plant,
  MfgOrderComponentAssembly.StorageLocation AS StorageLocation,
  MfgOrderComponentAssembly.InventoryUsabilityCode AS InventoryUsabilityCode,
  cast(hextobin('00000000000000000000000000000000') as dmu_guid16 preserving type) AS DgtlMockUpCharcsUUID,
  OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyComponentAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyComponentAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  MfgOrderComponentAssembly.MaterialComponentQuantity AS MaterialComponentQuantity,
  MfgOrderComponentAssembly.MaterialBaseUnit AS MaterialBaseUnit,
  MfgOrderComponentAssembly.QuantityInEntryUnit AS QuantityInEntryUnit,
  MfgOrderComponentAssembly.EntryUnit AS EntryUnit,
  MfgOrderComponentAssembly.DebitCreditCode AS DebitCreditCode,
  OpActyComponentAssignment.ComponentAssemblyType AS ComponentAssemblyType,
  OpActyComponentAssignment.LeadingReservation AS LeadingReservation,
  OpActyComponentAssignment.LeadingReservationItem AS LeadingReservationItem,
  OpActyComponentAssignment.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyComponentAssignment.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyComponentAssignment.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  MfgOrderComponentAssembly._Material AS _Material
FROM I_ShopFloorItem AS AssemblyShopFloorItem
INNER JOIN I_MfgOrderComponentAssembly AS MfgOrderComponentAssembly 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]
;