I_CashChainTrace

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_CashChainTrace.
-- 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_CashChainTrace AS
SELECT
  trace_uuid AS ChainTraceUUID,
  origin_bukrs AS CompanyCode,
  origin_gjahr AS FiscalYear,
  origin_belnr AS AccountingDocument,
  job_name AS ApplicationJobName,
  job_count AS ApplicationJob,
  job_status AS ApplicationJobStatus,
  trace_log AS DocumentChainTraceLog,
  expiration_date AS ExpirationDate,
  tstmp_seconds_between( tstmp_current_utctimestamp(), tstmp_add_seconds(cast(last_changed_at as abap.dec(15, 0)), cast( expired_at *3600 as abap.dec( 15, 0) ), 'INITIAL'), 'INITIAL') AS ExpiredAt,
  local_created_by AS LocalCreatedBy,
  local_created_at AS LocalCreatedAtDateTime,
  local_last_changed_by AS LocalLastChangedBy,
  local_last_changed_at AS LocalLastChangedAtDateTime,
  last_changed_at AS LastChangedAtDateTime
FROM fclm_fb2_trace
LEFT OUTER JOIN I_CashDocumentChainTraceResult AS _Result ON ChainTraceUUID = _Result.ChainTraceUUID  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JobStatusText AS _JobStatusText ON ApplicationJobStatus = _JobStatusText.ApplicationJobStatus  -- association [0..*]
;