C_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 C_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.

CREATE VIEW C_JITCustHeaderTP AS
SELECT
  CustomerUUID,
  ShipToParty,
  ShipToParty AS Customer,
  _Customer.CustomerName AS BusinessPartnerName,
  _Customer._AddressRepresentation._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  _Customer.CityName AS CityName,
  JITCustomerAddress,
  _Customer.Customer AS BusinessPartner,
  JITCustomerStatus,
  _JITCustomerStatus._Text[1: Language=$session.system_language].JITCustomerStatusText AS JITCustomerStatusText,
  IsJITRelevant,
  _Customer._AddressRepresentation.AddressTimeZone AS AddressTimeZone,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  CreatedByUser,
  _CreatedByUserDescription.UserDescription AS CreatedByUserDescription,
  CreationDateTime,
  _LastChangedByUserDescription.UserDescription AS LastChangedByUserDescription,
  LastChangedByUser,
  LastChangeDateTime,
  JITContactPerson,
  DaysForIntJITNumberGeneration,
  JITLifeCycleStatusCriticality,
  JITDeliveryHdrSplitCriterion,
  JITDeliveryItemSplitCriterion,
  JITDelivHdrSpltCritrnForPckg,
  JITSequenceNumberProfileID,
  JITDelivConfIsUsed,
  JITDelivConfForReorder
FROM I_JITCustHeaderTP
LEFT OUTER JOIN C_JITCustSupplyAreaTP AS _JITCustSupplyAreaTP ON CustomerUUID = _JITCustSupplyAreaTP.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN C_JITCustExternalStatusTP AS _JITCustExternalStatusTP ON CustomerUUID = _JITCustExternalStatusTP.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN C_JITCustReferenceTypeTP AS _JITCustReferenceTypeTP ON CustomerUUID = _JITCustReferenceTypeTP.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN C_JITCustomerValueHelp AS _JITCustomerValueHelp ON CustomerUUID = _JITCustomerValueHelp.CustomerUUID  -- association [0..1]
LEFT OUTER JOIN C_JITCustPartFunc AS _JITCustomerPartnerFunction ON CustomerUUID = _JITCustomerPartnerFunction.BusinessPartnerUUID AND Customer = _JITCustomerPartnerFunction.Customer  -- association [0..*]
LEFT OUTER JOIN C_JITCustContactPersonTP AS _JITContactPerson ON CustomerUUID = _JITContactPerson.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN C_JITDelivHdrSplitCriteriaVH AS _JITSplitCriteriaValueHelp ON JITDeliveryHdrSplitCriterion = _JITSplitCriteriaValueHelp.JITDeliverySplitCriteria  -- association [0..1]
LEFT OUTER JOIN C_JITDelivHdrSplitForPckgVH AS _JITSplitCriteriaForPckgVH ON JITDeliveryHdrSplitCriterion = _JITSplitCriteriaForPckgVH.JITDeliverySplitCriteria  -- association [0..1]
LEFT OUTER JOIN I_UserDescription AS _CreatedByUserDescription ON CreatedByUser = _CreatedByUserDescription.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserDescription AS _LastChangedByUserDescription ON LastChangedByUser = _LastChangedByUserDescription.UserID  -- association [0..1]
;