A_JITOutbCallCompMatl

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 A_JITOutbCallCompMatl.
-- 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: APIJITCOMPMAT

CREATE VIEW A_JITOutbCallCompMatl AS
SELECT
  InternalJITCallNumber AS JITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  Material,
  ProductName,
  RequestedQuantity,
  QuantityUnit,
  ActualDeliveredQuantity,
  JITOutbTransferredQuantity,
  JITOutbMinimumQuantity,
  JITOutbPickedQuantity,
  JITOutbOpenQuantity,
  ShortfallQuantity,
  cast ('' as njit_action ) AS JITAction,
  JITIntProcessingStatus,
  JITOutbStockTransferSts
FROM I_JITOutbCallCompMatlDataTP AS _JITOutbCallCompMatlDataTP
LEFT OUTER JOIN A_JITOutbCallRefTextCompMatl AS _JITOutbCallRefTextCompMatl ON JITCallNumber = _JITOutbCallRefTextCompMatl.JITCallNumber AND CompGrpNumber = _JITOutbCallRefTextCompMatl.CompGrpNumber AND JITCallItemNumber = _JITOutbCallRefTextCompMatl.JITCallItemNumber  -- association [1..*]
LEFT OUTER JOIN E_JITCompMatl AS _CompMaterial_extenstion ON JITCallNumber = _CompMaterial_extenstion.InternalJITCallNumber AND CompGrpNumber = _CompMaterial_extenstion.CompGrpNumber AND JITCallItemNumber = _CompMaterial_extenstion.JITCallItemNumber  -- association [0..1]
;