P_SFOTrcblComponentAssembly

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_SFOTrcblComponentAssembly.
-- 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_SFOTrcblComponentAssembly AS
SELECT
  SFOTrcblPlndCompAssembly.AssemblyDocument AS AssemblyDocument,
  SFOTrcblPlndCompAssembly.AssemblyDocumentItem AS AssemblyDocumentItem,
  cast(hextobin('00000000000000000000000000000000') as dmu_guid16 preserving type) AS OriglDgtlMockUpCharcsUUID,
  SFOTrcblPlndCompAssembly.Reservation AS Reservation,
  SFOTrcblPlndCompAssembly.ReservationItem AS ReservationItem,
  SFOTrcblPlndCompAssembly.RecordType AS RecordType,
  SFOTrcblPlndCompAssembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFOTrcblPlndCompAssembly.OpActyNtwkElement AS OpActyNtwkElement,
  SFOTrcblPlndCompAssembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  SFOTrcblPlndCompAssembly.ShopFloorItem AS ShopFloorItem,
  SFOTrcblPlndCompAssembly.Batch AS Batch,
  SFOTrcblPlndCompAssembly.Material AS Material,
  SFOTrcblPlndCompAssembly.Plant AS Plant,
  SFOTrcblPlndCompAssembly.StorageLocation AS StorageLocation,
  SFOTrcblPlndCompAssembly.InventoryUsabilityCode AS InventoryUsabilityCode,
  cast(hextobin('00000000000000000000000000000000') as dmu_guid16 preserving type) AS DgtlMockUpCharcsUUID,
  SFOTrcblPlndCompAssembly.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  SFOTrcblPlndCompAssembly.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  SFOTrcblPlndCompAssembly.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  SFOTrcblPlndCompAssembly.RequiredQuantity AS RequiredQuantity,
  SFOTrcblPlndCompAssembly.MaterialComponentQuantity AS MaterialComponentQuantity,
  SFOTrcblPlndCompAssembly.MaterialBaseUnit AS MaterialBaseUnit,
  SFOTrcblPlndCompAssembly.QuantityInEntryUnit AS QuantityInEntryUnit,
  SFOTrcblPlndCompAssembly.EntryUnit AS EntryUnit,
  SFOTrcblPlndCompAssembly.DebitCreditCode AS DebitCreditCode,
  SFOTrcblPlndCompAssembly.ComponentAssemblyType AS ComponentAssemblyType,
  SFOTrcblPlndCompAssembly.ManufacturingOrder AS ManufacturingOrder,
  SFOTrcblPlndCompAssembly.LeadingReservation AS LeadingReservation,
  SFOTrcblPlndCompAssembly.LeadingReservationItem AS LeadingReservationItem,
  SFOTrcblPlndCompAssembly.LeadingReservationRecordType AS LeadingReservationRecordType,
  SFOTrcblPlndCompAssembly.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  SFOTrcblPlndCompAssembly.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  SFOTrcblPlndCompAssembly._Material AS _Material,
  SFOTrcblPlndCompAssembly._Plant AS _Plant,
  SFOTrcblPlndCompAssembly._ProductPlantBasic AS _ProductPlantBasic,
  SFOTrcblPlndCompAssembly._OpActyNtwkInstance AS _OpActyNtwkInstance,
  SFOTrcblPlndCompAssembly._OperationActivityInstance AS _OperationActivityInstance,
  SFOTrcblPlndCompAssembly._ManufacturingOrder AS AssemblyDocumentasAssemblyDocument,
  OpActyNtwkInstanceBasic._ManufacturingOrder AS _ManufacturingOrder
FROM P_SFOTrcblPlndCompAssembly AS SFOTrcblPlndCompAssembly
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]
;