/APE/C_TstDoc_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_TstDoc_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.
-- SQL view name: /APE/C_TSTDOCUI

CREATE VIEW /APE/C_TstDoc_UI AS
SELECT
  db_key AS TestDocumentKey,
  test_case_uuid AS TestCaseKey,
  test_case_id AS TestCaseID,
  test_doc_no AS TestDocNo,
  _TestCaseVH.TestCaseDescription AS TestCaseDescription,
  test_case_status AS TestCaseStatus,
  _TestCaseStatusVH.Description AS TestCaseStatusDescription,
  _TestCaseVH.ProcessIDKey AS ProcessIdKey,
  _TestCaseVH.ProcessKey AS ProcessKey,
  _TestCaseVH.ProcessID AS ProcessID,
  _TestCaseVH.ProcessIDDescription AS ProcessIDDescriptionLi,
  _TestCaseVH.ProcessIDDescription AS ProcessIDDescription,
  _TestCaseVH.VersionKey AS VersionKey,
  _TestCaseVH._ProcessVH.Version AS Version,
  _TestCaseVH._ProcessVH.VersionDescription AS VersionDescriptionLi,
  _TestCaseVH._ProcessVH.VersionDescription AS VersionDescription,
  _TestCaseVH._ProcessVH.ProcessClusterKey AS ProcessClusterKey,
  _TestCaseVH.ProcCluster AS ProcCluster,
  _TestCaseVH.ProcessClusterDescription AS ProcessClusterDescriptionLi,
  _TestCaseVH.ProcessClusterDescription AS ProcessClusterDescription,
  tstmp_to_dats( changed_at, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as ExecutionTimeStamp AS clientNULLasExecutionTimeStamp,
  proc_cluster,
  auth_grp,
  Archived,
  log_level AS LogLevel,
  created_by AS CreateBy,
  tstmp_to_dats( created_at, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as CreateAtFt AS clientNULLasCreateAtFt,
  changed_by AS ChangeBy,
  tstmp_to_dats( changed_at, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as ChangeAtFt AS clientNULLasChangeAtFt,
  _TestAggrList.test_step_seq_no AS LastExecutedStep,
  test_case_id
FROM /APE/I_TSTDOC_TP
LEFT OUTER JOIN /APE/C_TstDocStep_UI AS _TestStep ON TestDocumentKey = _TestStep.TestDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_TestCase_VH AS _TestCaseVH ON TestCaseKey = _TestCaseVH.TestCaseKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_TstDocProcess_UI AS _TestProc ON TestDocumentKey = _TestProc.TestDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_TstCaseStatus_VH AS _TestCaseStatusVH ON TestCaseStatus = _TestCaseStatusVH.Value  -- association [0..1]
LEFT OUTER JOIN /APE/C_TstDocParameter_UI AS _TstDocParameter ON TestDocumentKey = _TstDocParameter.TestDocumentKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_LogLevel_VH AS _LogLevel ON _LogLevel.Value = LogLevel  -- association [0..1]
LEFT OUTER JOIN /APE/C_DomainValueTexts AS _Archived ON _Archived.Domname = '/APE/D_ARCHIVE_INDICATOR' AND _Archived.Domvalue = Archived  -- association [0..*]
LEFT OUTER JOIN /APE/C_TESTDOCAGGRLIST AS _TestAggrList ON TestDocumentKey = _TestAggrList.TestDocumentKey  -- association [0..1]
;