I_JITOutbCallHeader

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_JITOutbCallHeader.
-- 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: IJITOUTBHDR

CREATE VIEW I_JITOutbCallHeader AS
SELECT
  db_key AS JITHeaderUUID,
  int_call_num AS InternalJITCallNumber,
  ext_call_num AS ExternalJITCallNumber,
  kunnr AS ShipToParty,
  cast( kunag as abap.char(10) ) AS SoldToParty,
  lifecycle_stat AS JITLifecycleStatus,
  call_type AS JITCallType,
  vhvin AS VehicleIdentificationNumber,
  vhcle_model AS VehicleModel,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  ablad AS UnloadingPointName,
  knref AS CustomerPartnerDescription,
  abrvw AS MatlUsageIndicator,
  cast( lifnr as abap.char( 10 ) ) AS ActiveSupplier,
  log_severity AS ApplLogHighestMessageSeverity,
  immediate_request AS JITCallImmediateRequest,
  missing_parts AS JITMissingPartFlag,
  priority_type AS JITCallPriorityType,
  priority_id AS JITCallPriorityID,
  concat('JIT-TOLR',int_call_num) AS JITCallProcessingLogID,
  int_sequence_num AS JITIntSequenceNumber,
  ext_sequence_num AS JITExtSequenceNumber,
  call_creation_mode AS JITCallCreationMode,
  planned_order AS JITPlannedOrderNumber,
  sequence_date AS JITVehicleSeqDateTime,
  crea_date_time AS CreationDateTime,
  crea_uname AS CreatedByUser,
  lchg_date_time AS LastChangeDateTime,
  lchg_uname AS LastChangedByUser
FROM njit_call_d_hdr
LEFT OUTER JOIN I_JITOutbCallCompGrp AS _JITOutbCallCompGroup ON JITHeaderUUID = _JITOutbCallCompGroup.ParentDraftKey AND InternalJITCallNumber = _JITOutbCallCompGroup.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN I_JITLifecycleStatus AS _JITLifecycleStatus ON JITLifecycleStatus = _JITLifecycleStatus.JITLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_JITCallType AS _JITCallType ON JITCallType = _JITCallType.JITCallType  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_JITCallCreationMode AS _JITCallCreationMode ON JITCallCreationMode = _JITCallCreationMode.JITCallCreationMode  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON JITCallPriorityID = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_JITOutbMissingFlag AS _JITOutbMissingPartFlag ON JITMissingPartFlag = _JITOutbMissingPartFlag.JITMaterialStockIsMissing  -- association [0..1]
;