I_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 I_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: IJITCHDTP

CREATE VIEW I_JITCallHeaderDataTP AS
SELECT
  InternalJITCallNumber,
  ExternalJITCallNumber,
  ExternalJITCallNumber AS ExternalJITCallNumberForFilter,
  ApplLogHighestMessageSeverity,
  JITScenario,
  CustomerUUID,
  ShipToParty,
  ShipToParty AS ShipToPartyForFilter,
  SoldToParty,
  JITLifecycleStatus,
  JITCallType,
  VehicleIdentificationNumber,
  VehicleModel,
  SalesOrganization,
  DistributionChannel,
  Division,
  UnloadingPointName,
  CustomerPartnerDescription,
  MatlUsageIndicator,
  ActiveSupplier,
  JITExtSequenceNumber,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  cast( ' ' as njit_int_stat) AS JITIntProcessingStatus,
  cast( _JITCallDate.DeliveryCreationDate as ledat) AS DeliveryCreationDate,
  cast(_JITCallDate.RequirementDateTime as njit_req_date_time ) AS RequirementDateTime,
  cast(_JITCallDate.PlannedShippingDateTime as njit_planned_shipping_date_tim) AS PlannedShippingDateTime,
  cast(_JITCallDate.MaterialAvailabilityDate as mbdat) AS MaterialAvailabilityDate,
  cast( ' ' as werks_d) AS Plant,
  cast( ' ' as njit_comp_grp_mat) AS CompGrpMatl,
  cast( ' ' as matnr) AS Material,
  cast( ' ' as spart) AS ActiveDivision,
  cast( ' ' as njit_refty) AS JITRefType,
  cast( ' ' as njit_btd_id) AS OutboundDelivery,
  cast( ' ' as exidv) AS HandlingUnitExternalID,
  cast( ' ' as njit_ref_text) AS JITRefText,
  JITCallProcessingLogID,
  NumberOfAlerts,
  JITComponentIsReordered
LEFT OUTER JOIN I_JITCallCompGrpDataTP AS _JITCallCompGrpDataTP ON InternalJITCallNumber = _JITCallCompGrpDataTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITCallRefTextHdrTP AS _JITCallRefTextHdrTP ON InternalJITCallNumber = _JITCallRefTextHdrTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITCallDate AS _JITCallDate ON InternalJITCallNumber = _JITCallDate.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN E_JITCall AS _JITCallExtension ON InternalJITCallNumber = _JITCallExtension.InternalJITCallNumber  -- association [0..1]
LEFT OUTER JOIN I_JITCallRefTextBasic AS _JITCallRefTextTP ON InternalJITCallNumber = _JITCallRefTextTP.InternalJITCallNumber  -- association [0..*]
;