P_SpltSFITrcblPlndCompAssy

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_SpltSFITrcblPlndCompAssy.
-- 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_SpltSFITrcblPlndCompAssy 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,
  GenealogyShopFloorItem.ShopFloorItem AS ActiveReplaceShopFloorItem,
  GenealogyShopFloorItem.OriginalReplacedShopFloorItem 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 GenealogyShopFloorItem
INNER JOIN I_ShopFloorItem AS AssemblyShopFloorItem ON /* join condition not captured in parsed metadata */
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]
;