Shsm_Sum_Jit_Call_Outbound

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 Shsm_Sum_Jit_Call_Outbound.
-- 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: SHSMSUMJITCALLOB

CREATE VIEW Shsm_Sum_Jit_Call_Outbound AS
SELECT
  jitoit.outpo AS outpo,
  jitoco.jcpos AS jcpos,
  jitoit.lifnr AS lifnr,
  pkhd.werks AS werks,
  pkhd.matnr AS matnr,
  pkhd.prvbe AS prvbe,
  pvbe.ablad AS ablad,
  pvbe.lgbzo AS lgbzo,
  pkhd.lifnr AS KanbanControlCycleSupplier
FROM jitoit
INNER JOIN jitoco ON /* join condition not captured in parsed metadata */
INNER JOIN pkhd ON /* join condition not captured in parsed metadata */
INNER JOIN pvbe ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON lifnr = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON lifnr = _SupplierCompanyByPlant.Supplier AND werks = _SupplierCompanyByPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _KanbanControlCycleSupplier ON KanbanControlCycleSupplier = _KanbanControlCycleSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _KnbnCtrlCycSupplierCoByPlnt ON KanbanControlCycleSupplier = _KnbnCtrlCycSupplierCoByPlnt.Supplier AND werks = _KnbnCtrlCycSupplierCoByPlnt.Plant  -- association [0..1]
;