/APE/C_TRANS_HDR_BO

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 /APE/C_TRANS_HDR_BO.
-- 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: /APE/C_TRHDRBO

CREATE VIEW /APE/C_TRANS_HDR_BO AS
SELECT
  trans_uuid,
  _trans_header.trans_status AS trans_status,
  _trans_header.trans_direct AS trans_direct,
  _trans_header.sender_id AS sender_id,
  _trans_header.receiver_id AS receiver_id,
  _trans_header.trans_tstmp AS trans_tstmp,
  tstmp_to_dats(_trans_header.trans_tstmp, 'UTC', $session.client, 'NULL' ) AS trans_date,
  tstmp_to_dats(_trans_header.trans_status_tstmp, 'UTC', $session.client, 'NULL' ) AS status_date,
  tstmp_to_dats(_trans_header.created_at, 'UTC', $session.client, 'NULL' ) AS create_date,
  tstmp_to_dats(_trans_header.changed_at, 'UTC', $session.client, 'NULL' ) AS change_date,
  _trans_header.trans_doc_no AS trans_doc_no,
  com_acc_uuid,
  blocked,
  tech_msg_id,
  bus_msg_id,
  proc_cluster,
  _trans_header.auth_grp AS auth_grp,
  _trans_header.client_uuid AS client_uuid,
  _trans_header.archived AS archived,
  _trans_header.compressed AS compressed,
  _trans_header.log_level AS log_level,
  _trans_header.created_at AS created_at,
  _trans_header.changed_at AS changed_at
FROM /APE/C_TransBOHeader
LEFT OUTER JOIN /APE/C_TransHeader AS _trans_header ON trans_uuid = _trans_header.trans_uuid  -- association [1..1]
;