/APE/I_OPPROC_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_OPPROC_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_OPPROC_TP AS
SELECT
  db_key,
  doc_type,
  client_uuid,
  _Client.name AS client_name,
  _ProcCluster.proc_cluster AS proc_cluster,
  version_uuid,
  _Version.version AS version,
  proc_id_uuid,
  _ProcessID.proc_id AS proc_id,
  priority,
  bus_msg_id,
  tech_msg_id,
  bo_type_uuid,
  _BOType.bo_type AS bo_type,
  _ExcpCode.exception_code AS excp_code,
  op_category,
  locked,
  ignore_ddl,
  _PeriodType.period_type AS period_type,
  _PeriodType.version AS PeriodType_Version,
  _PeriodType.proc_cluster AS PeriodType_proccluster,
  log_level,
  trans_direct,
  auth_grp,
  created_at,
  created_by,
  changed_at,
  changed_by
FROM /APE/I_OPPROC
LEFT OUTER JOIN /APE/I_ProcessCluster_TP AS _ProcCluster ON proc_cluster_uuid = _ProcCluster.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_Version_TP AS _Version ON version_uuid = _Version.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_ProcessID_TP AS _ProcessID ON proc_id_uuid = _ProcessID.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_PeriodType_TP AS _PeriodType ON archive_period = _PeriodType.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_Client_TP AS _Client ON client_uuid = _Client.client_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/I_BusObjType_TP AS _BOType ON bo_type_uuid = _BOType.config_key  -- association [0..1]
LEFT OUTER JOIN /APE/I_ExceptionID_TP AS _ExcpCode ON excp_code_uuid = _ExcpCode.config_key  -- association [0..1]
;