C_JITCallHeaderDataTP

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_JITCallHeaderDataTP.
-- 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: CJITCHDTP

CREATE VIEW C_JITCallHeaderDataTP AS
SELECT
  InternalJITCallNumber,
  ExternalJITCallNumber,
  ExternalJITCallNumber AS ExternalJITCallNumberForFilter,
  ApplLogHighestMessageSeverity,
  ShipToParty,
  ShipToParty AS ShipToPartyForFilter,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  SoldToParty,
  JITLifecycleStatus,
  _JITLifecycleStatus._Text[1:Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  JITCallType,
  _JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  LastChangeDateTime,
  LastChangedByUser,
  CreationDateTime,
  VehicleIdentificationNumber,
  VehicleModel,
  JITExtSequenceNumber,
  SalesOrganization,
  DistributionChannel,
  Division,
  UnloadingPointName,
  CustomerPartnerDescription,
  MatlUsageIndicator,
  _MatlUsageIndicator._Text[1: Language = $session.system_language ].MatlUsageIndicatorText AS MatlUsageIndicatorText,
  ActiveSupplier,
  JITLifeCycleStatusCriticality,
  CompGrpMatl,
  Plant,
  JITIntProcessingStatus,
  Material,
  ActiveDivision,
  DeliveryCreationDate,
  RequirementDateTime,
  PlannedShippingDateTime,
  MaterialAvailabilityDate,
  OutboundDelivery,
  HandlingUnitExternalID,
  JITRefType,
  JITRefText,
  JITCallProcessingLogID,
  NumberOfAlerts,
  CustomerUUID,
  JITComponentIsReordered,
  _JITComponentIsReordered._Text[1:Language = $session.system_language].JITComponentIsReorderedText AS JITComponentIsReorderedText,
  cast('' as njit_dcnf_id) AS JITDeliveryConfirmationID,
  _LastChangedByUser.FullName AS UserDescription,
  _LastChangedByUser.FirstName AS FirstName,
  _LastChangedByUser.LastName AS LastName
FROM I_JITCallHeaderDataTP
LEFT OUTER JOIN C_JITCallCompGrpDataTP AS _JITCallCompGrpDataTP ON InternalJITCallNumber = _JITCallCompGrpDataTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallRefTextHdrTP AS _JITCallRefTextHdrTP ON InternalJITCallNumber = _JITCallRefTextHdrTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN C_JITContactPerson AS _JITContactPerson ON ShipToParty = _JITContactPerson.ShipToParty  -- association [0..*]
LEFT OUTER JOIN C_JITCallDelivConfRefDoc AS _JITCallDelivConfRefDoc ON InternalJITCallNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocument  -- association [0..*]
;