/APE/A_TransBOHeader

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/A_TransBOHeader.
-- 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/A_TransBOHeader AS
SELECT
  db_key AS bo_uuid,
  parent_key AS trans_uuid,
  bo_ext_uuid,
  bo_status,
  operation,
  com_acc_uuid,
  proc_cluster,
  tech_msg_id,
  bus_msg_id,
  response_cat,
  user_uuid,
  blocked,
  client_uuid,
  trans_direct,
  sender_id,
  receiver_id,
  auth_grp
FROM /APE/I_TransBOHeader_TP
LEFT OUTER JOIN /APE/A_TransactionService AS _trans_header ON trans_uuid = _trans_header.trans_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/A_TransBOIdentify AS _bo_id ON bo_uuid = _bo_id.bo_uuid  -- association [0..*]
LEFT OUTER JOIN /APE/A_TransBOData AS _bo_data ON bo_uuid = _bo_data.bo_uuid  -- association [0..*]
LEFT OUTER JOIN /APE/A_TransBORelation AS _bo_rel ON bo_uuid = _bo_rel.bo_uuid  -- association [0..*]
;