I_JITCallActionLog

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_JITCallActionLog.
-- 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 I_JITCallActionLog AS
SELECT
  db_key AS JITCallActionLogUUID,
  root_key AS JITHeaderUUID,
  parent_key AS JITCallCompGrpUUID,
  object AS ApplicationLogObject,
  subobject AS ApplicationLogSubobject,
  ltrim( lognumber , '0') AS JITCallProcessingLogID,
  fiori_application_name AS JITFioriApplicationName,
  action_source AS JITCallActionSource,
  action_code AS JITAction,
  action_status AS JITCallActionStatus,
  JITFioriID,
  aluser AS IsProcessedByUser,
  crea_date_time AS CreationDateTime,
  JITApplicationLogHandle
FROM njit_call_d_alog
LEFT OUTER JOIN I_UserContactCard AS _ProcessedByUser ON IsProcessedByUser = _ProcessedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_JITActionText AS _JITActionText ON JITAction = _JITActionText.JITAction AND _JITActionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JITCallActionSource AS _JITCallActionSource ON JITCallActionSource = _JITCallActionSource.JITCallActionSource  -- association [0..1]
LEFT OUTER JOIN I_JITCallActionStatus AS _JITCallActionStatus ON JITCallActionStatus = _JITCallActionStatus.JITCallActionStatus  -- association [0..1]
LEFT OUTER JOIN I_JITApplicationID AS _JITApplicationID ON JITFioriID = _JITApplicationID.JITFioriID  -- association [0..1]
;