I_JITDelivConfItemBasic

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 I_JITDelivConfItemBasic.
-- 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 I_JITDelivConfItemBasic AS
SELECT
  JITDeliveryConfirmationItmUUID,
  JITDeliveryConfirmationUUID,
  JITCompMatl,
  JITDelivConfItemNumber,
  MaterialByCustomer,
  SalesSchedulingAgreement,
  SalesSchedulingAgreementItem,
  ReasonCode,
  JITDelivConfMatchingStatus,
  JITDelivConfIntProcgSts,
  ConfirmedQuantity,
  TotalConfirmedQuantity,
  TotalDeliveredQuantity,
  BaseUnitofMeasure,
  JITApplicationLogSeverity,
  JITApplicationLogHandle
FROM njit_d_dcnf_item
LEFT OUTER JOIN I_JITDelivConfMatchingStatus AS _JITDelivConfMatchingStatus ON JITDelivConfMatchingStatus = _JITDelivConfMatchingStatus.JITDelivConfMatchingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITApplicationLogSeverity AS _JITApplicationLogSeverity ON JITApplicationLogSeverity = _JITApplicationLogSeverity.JITApplicationLogSeverity  -- association [0..1]
LEFT OUTER JOIN I_SalesSchedgAgrmt AS _SalesSchedgAgrmt ON SalesSchedulingAgreement = _SalesSchedgAgrmt.SalesSchedulingAgreement  -- association [0..1]
LEFT OUTER JOIN I_SalesSchedgAgrmtItem AS _SalesSchedgAgrmtItem ON SalesSchedulingAgreement = _SalesSchedgAgrmtItem.SalesSchedulingAgreement AND SalesSchedulingAgreementItem = _SalesSchedgAgrmtItem.SalesSchedulingAgreementItem  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON JITCompMatl = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_JITDelivConfRelReasonCode AS _JITDelivConfRelReasonCode ON ReasonCode = _JITDelivConfRelReasonCode.ReasonCode  -- association [0..1]
LEFT OUTER JOIN I_JITDelivConfProcgSts AS _JITDelivConfProcgSts ON JITDelivConfIntProcgSts = _JITDelivConfProcgSts.JITDelivConfIntProcgSts  -- association [0..1]
LEFT OUTER JOIN I_JITDelivConfRefDocBasic AS _JITDelivConfRefDocBasic ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITDelivConfReltdDocBasic AS _JITDelivConfReltdDocBasic ON /* condition not available in parsed metadata */  -- association [0..*]
;