I_JITCustHeaderTP

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_JITCustHeaderTP.
-- 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: IJITCUSTHDRTP1

CREATE VIEW I_JITCustHeaderTP AS
SELECT
  CustomerUUID,
  ShipToParty,
  case when _Customer.CityName = '' then _Customer._StandardAddress._Country._Text[1: Language=$session.system_language].CountryName else concat( _Customer.CityName,concat(', ', _Customer._StandardAddress._Country._Text[1: Language=$session.system_language].CountryName)) end as JITCustomerAddress AS CountryNameendasJITCustomerAddress,
  JITCustomerStatus,
  IsJITRelevant,
  cast(0 as abap.int2( 5 )) AS NumberOfSupplyAreas,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  DaysForIntJITNumberGeneration,
  cast('' as abap.char( 90 )) AS JITContactPerson,
  JITDeliveryHdrSplitCriterion,
  JITDeliveryItemSplitCriterion,
  JITSequenceNumberProfileID,
  cast('0' as njit_call_type) AS SummarizedJITCallType,
  cast('1' as njit_call_type) AS SequencedJITCallType,
  JITDelivHdrSpltCritrnForPckg,
  JITDelivConfIsUsed,
  JITDelivConfForReorder
FROM I_JITCustData AS JITCustHeader_with_draft
LEFT OUTER JOIN I_JITCustSupplyAreaTP AS _JITCustSupplyAreaTP ON CustomerUUID = _JITCustSupplyAreaTP.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN I_JITCustExternalStatusTP AS _JITCustExternalStatusTP ON CustomerUUID = _JITCustExternalStatusTP.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN I_JITCustReferenceTypeTP AS _JITCustReferenceTypeTP ON CustomerUUID = _JITCustReferenceTypeTP.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN E_JITCustomer AS _JITCustomerExtension ON CustomerUUID = _JITCustomerExtension.CustomerUUID  -- association [0..1]
;