/APE/C_PDoc_LinkedDocuments_UI

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_PDoc_LinkedDocuments_UI.
-- 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_PDoc_LinkedDocuments_UI AS
SELECT
  Gra.ProcessDocumentKey AS ProcessDocumentKey,
  Gra.LinkedProcessDocumentKey AS LinkedDocumentKey,
  cast( LPdoc.proc_doc_no as abap.char( 32 ) ) AS LinkedDocumentNumber,
  cast( concat_with_space(PTxt.description, concat('(', concat(LPdoc.proc_id,')') ), 1 ) as abap.char(200) ) as ProcessDescription AS char200asProcessDescription,
  cast( 'PDoc' as /ape/de_bo_type ) AS BusinessObjectType,
  bo.BusinessObjectTypeDescription AS BusinessObjectTypeDescription,
  LPdoc.proc_status AS DocumentStatus,
  DocSts.Text AS DocumentStatusDescription,
  LinkT.Text AS LinkTypeDescription,
  cast( '' as abap.char( 60 ) ) AS Direction,
  PSt.StepSeqNo AS TriggerStep,
  bo.SemanticObject AS SemanticObject,
  bo.SemanticAction AS SemanticAction,
  bo.KeyFieldName AS KeyFieldName,
  cast( LPdoc.created_at as timestampl ) AS CreatedAt,
  PSt.ApplicationTableUUID AS TriggerStepKey,
  case when BusMsg.BusinessMessageIDDescription is not null then concat_with_space(BusMsg.BusinessMessageIDDescription, concat('(', concat(BusinessObject.bus_msg_id,')') ), 1 ) else BusinessObject.bus_msg_id end as ProcessDescription AS bus_msg_idendasProcessDescription,
  case Srt.location when 'P' then Srt.ib_if_name when 'C' then Srt.ob_if_name end as ProcessDescription AS ob_if_nameendasProcessDescription,
  concat_with_space(EXID.ExceptionIDDescription, concat('(', concat(EXID.ExceptionID,')') ), 1 ) as ProcessDescription AS ExceptionID1asProcessDescription
FROM /APE/C_LinkedProcesses_UI AS Gra
INNER JOIN /APE/C_ProcDataHeader AS LPdoc ON /* join condition not captured in parsed metadata */
INNER JOIN /APE/C_TransHeader AS LTdoc ON /* join condition not captured in parsed metadata */
INNER JOIN /APE/C_TransBOHeader AS BusinessObject ON /* join condition not captured in parsed metadata */
INNER JOIN srt_mmaster AS Srt ON /* join condition not captured in parsed metadata */
INNER JOIN /APE/C_ExceptionHeader AS LEXdoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /APE/C_ProcStepHeader_PDM_UI AS _TriggerStepIntNav ON _TriggerStepIntNav.ProcessHeaderUUID = ProcessDocumentKey AND _TriggerStepIntNav.ApplicationTableUUID = TriggerStepKey  -- association [0..1]
-- UNION with additional select branch(es): /APE/C_ProcEvent_TOBINCONV, /APE/C_ProcStep_TOBINCONV
;