/APE/C_ExceptionHeader

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_ExceptionHeader.
-- 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/C_ExceptionHeader AS
SELECT
  db_key AS excp_uuid,
  excp_doc_no,
  client_uuid,
  com_acc_uuid,
  excp_code,
  coalesce( proc_cluster, 'APE' ) AS proc_cluster,
  excp_status,
  bus_status,
  bo_type,
  bo_uuid,
  owner_uuid,
  bo_character,
  priority,
  processor,
  note,
  remote,
  test,
  blocked,
  auth_grp,
  archived,
  log_level,
  created_at,
  created_by,
  changed_at,
  changed_by,
  _ProcDoc.PDoc_CLuster AS PDoc_CLuster
FROM /APE/I_ExceptionHeader_TP
LEFT OUTER JOIN /APE/C_ExceptionParameter AS _ExcpPara ON excp_uuid = _ExcpPara.excp_uuid  -- association [0..*]
LEFT OUTER JOIN /APE/C_ExceptionSolution AS _ExcpSolv ON excp_uuid = _ExcpSolv.excp_uuid  -- association [0..*]
LEFT OUTER JOIN /APE/C_EXCEPTIONLINKBO AS _ExcpLinkBO ON excp_uuid = _ExcpLinkBO.excp_uuid  -- association [0..*]
LEFT OUTER JOIN /APE/C_ExceptionCode AS _ExcpCode ON excp_config_uuid = _ExcpCode.config_key  -- association [0..1]
LEFT OUTER JOIN /APE/I_ProcessDocument_Cluster AS _ProcDoc ON bo_uuid = _ProcDoc.proc_uuid AND bo_type = 'PDoc'  -- association [0..1]
;