C_JITDelivConfItemTP

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 C_JITDelivConfItemTP.
-- 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 C_JITDelivConfItemTP AS
SELECT
  JITDeliveryConfirmationItmUUID,
  JITDeliveryConfirmationUUID,
  _JITDelivConfTP.JITDeliveryConfirmationID AS JITDeliveryConfirmationID,
  _JITDelivConfTP.ShipToParty AS ShipToParty,
  JITCompMatl AS Material,
  JITComponentMaterialPosNmbr,
  JITDelivConfItemNumber,
  cast( JITDelivConfItemNumber as njit_btd_item_id ) AS BusinessTransactionDocItem,
  MaterialByCustomer,
  SalesSchedulingAgreement,
  SalesSchedulingAgreementItem,
  ReasonCode,
  JITApplicationLogSeverity,
  _JITApplicationLogSeverity._Text[1:Language = $session.system_language].JITApplicationLogSeverityTxt AS JITApplicationLogSeverityTxt,
  _JITDelivConfRelReasonCodeVH.JITDelivConfRelReasonCodeText AS JITDelivConfRelReasonCodeText,
  JITDelivConfMatchingStatus,
  _JITDelivConfMatchingStatus._Text[1:Language = $session.system_language].JITDelivConfMatchingStatusTxt AS JITDelivConfMatchingStatusTxt,
  ConfirmedQuantity,
  TotalConfirmedQuantity,
  TotalDeliveredQuantity,
  MinimumQuantityVolume,
  MaximumQuantityVolume,
  BaseUnitofMeasure,
  DeltaQuantity,
  JITDelivConfDelivQtyCritlty,
  JITMatchingStatusCriticality,
  JITDelivConfIntProcgSts,
  _JITDelivConfProcgSts._Text[1:Language = $session.system_language].JITDelivConfIntProcgStsTxt AS JITDelivConfIntProcgStsTxt,
  cast( _ConsignmentIssueOrder.BusinessTransactionDocument as vdm_sales_order ) AS SalesOrder,
  _SalesSchedgAgrmt.SalesOrganization AS SalesOrganization,
  cast(JITApplicationLogHandle as char22) AS JITApplicationLogHandle,
  _SalesSchedgAgrmt._SalesOrganization AS _SalesOrganization
FROM I_JITDelivConfItemTP
LEFT OUTER JOIN C_JITDelivConfTP AS _JITDelivConfTP ON JITDeliveryConfirmationUUID = _JITDelivConfTP.JITDeliveryConfirmationUUID  -- association [1..1]
LEFT OUTER JOIN C_JITDelivConfRefDocTP AS _JITDelivConfRefDocTP ON JITDeliveryConfirmationItmUUID = _JITDelivConfRefDocTP.JITDeliveryConfirmationItmUUID AND _JITDelivConfRefDocTP.BusinessTransactionDocType = 'C'  -- association [0..*]
LEFT OUTER JOIN C_JITDelivConfReltdDocTP AS _JITDelivConfReltdDocTP ON JITDeliveryConfirmationItmUUID = _JITDelivConfReltdDocTP.JITDeliveryConfirmationItmUUID  -- association [0..*]
LEFT OUTER JOIN I_SalesSchedgAgrmt AS _SalesSchedgAgrmt ON SalesSchedulingAgreement = _SalesSchedgAgrmt.SalesSchedulingAgreement  -- association [0..1]
LEFT OUTER JOIN C_JITDelivConfRefDocTP AS _ConsignmentIssueOrder ON JITDeliveryConfirmationItmUUID = _ConsignmentIssueOrder.JITDeliveryConfirmationItmUUID AND _ConsignmentIssueOrder.BusinessTransactionDocType = 'O'  -- association [0..1]
LEFT OUTER JOIN C_JITDelivConfRelReasonCodeVH AS _JITDelivConfRelReasonCodeVH ON ReasonCode = _JITDelivConfRelReasonCodeVH.ReasonCode  -- association [0..1]
;