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.
-- SQL view name: CJITCUSTHDRTP1

CREATE VIEW C_JITCustHeaderTP AS
SELECT
  CustomerUUID,
  ShipToParty,
  ShipToParty AS Customer,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _Customer._StandardAddress._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  _Customer.CityName AS CityName,
  JITCustomerAddress,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  JITCustomerStatus,
  _JITCustomerStatus._Text[1: Language=$session.system_language].JITCustomerStatusText AS JITCustomerStatusText,
  IsJITRelevant,
  _Customer._StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _JITCustSupplyAreaInfo.NumberOfSupplyAreas AS NumberOfSupplyAreas,
  _Customer._StandardAddress.AddressTimeZone AS AddressTimeZone,
  CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserDescription,
  _CreatedByUser.FirstName AS CreatedByUserFirstName,
  _CreatedByUser.LastName AS CreatedByUserLastName,
  CreationDateTime,
  _LastChangedByUser.FullName AS LastChangedByUserDescription,
  _LastChangedByUser.FirstName AS FirstName,
  _LastChangedByUser.LastName AS LastName,
  LastChangedByUser,
  LastChangeDateTime,
  JITContactPerson,
  DaysForIntJITNumberGeneration,
  JITLifeCycleStatusCriticality,
  SummarizedJITCallType,
  SequencedJITCallType,
  JITDeliveryHdrSplitCriterion,
  _JITSplitCriteriaValueHelp.JITDeliverySplitCriteriaDesc AS JITDeliverySplitCriteriaDesc,
  JITDeliveryItemSplitCriterion,
  JITDelivHdrSpltCritrnForPckg,
  _JITSplitCriteriaForPckgVH.JITDeliverySplitForPckgDesc AS JITDeliverySplitForPckgDesc,
  JITSequenceNumberProfileID,
  JITDelivConfIsUsed,
  _JITDelivConfIsUsed._Text[1:Language = $session.system_language].JITDelivConfIsUsedText AS JITDelivConfIsUsedText,
  JITDelivConfForReorder,
  _JITDelivConfForReorder._Text[1:Language = $session.system_language].JITDelivConfForReorderText AS JITDelivConfForReorderText
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]
;