/APE/I_TransHeader_TP

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/I_TransHeader_TP.
-- 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 /APE/I_TransHeader_TP AS
SELECT
  db_key,
  trans_doc_no,
  client_uuid,
  trans_tstmp,
  trans_status,
  trans_direct,
  aggr_type,
  sender_id,
  sender_cl_id,
  receiver_id,
  payload_ext,
  payload_int,
  asynchronous,
  execute_prio,
  auth_grp,
  log_level,
  blocked,
  test,
  bo_status,
  tech_msg_id,
  bus_msg_id,
  com_acc_uuid,
  doc_tags,
  doc_size,
  bo_ext_uuid,
  response_cat,
  service_type,
  proc_cluster,
  archived,
  compressed,
  created_at,
  created_by,
  changed_at,
  changed_by
FROM /APE/I_TransHeader
LEFT OUTER JOIN /APE/I_TransBOHeader_TP AS _bo_header ON db_key = _bo_header.parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/I_TransLink_TP AS _TransLink ON db_key = _TransLink.parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/E_TransHeader_TP AS _Extension ON db_key = _Extension.db_key  -- association [1..1]
;