CDR_I_FILE_ARC_U

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 CDR_I_FILE_ARC_U.
-- 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: CDR_FILE_ARC_U

CREATE VIEW CDR_I_FILE_ARC_U AS
SELECT
  File.packid AS packid,
  File.appl_comp AS appl_comp,
  File.tabname AS tabname,
  File.file_seqno AS file_seqno,
  File.filename AS filename,
  File.filesize AS filesize,
  File.failed AS failed,
  File.in_process AS in_process,
  File.dwn_finish AS dwn_finish,
  File.dwn_user AS dwn_user,
  case when File.in_process = 'X' then '12' when File.failed = 'X' then '16' when File.dwn_finish = 'X' then '13' else ' ' end as status AS dwn_finishXthen13elseendasstatus,
  tstmp_to_dats( dwn_timestamp, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS dwn_date,
  tstmp_to_dats( dwn_timestamp, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS dwn_time,
  File.lognumber AS lognumber
FROM cdr_file AS File
;