/APE/C_TstDocParameter_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_TstDocParameter_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_TSTCSEPUI

CREATE VIEW /APE/C_TstDocParameter_UI AS
SELECT
  _TstDocPar.db_key AS TstDocParametersKey,
  _TstDocPar.parent_key AS TestDocumentKey,
  _TstDocPar.param_assign_uuid AS ParameterAssignKey,
  ParaAss.APE_PARENT_KEY AS ParameterGroupIDKey,
  ParaGroup.TestParameterGroupID AS ParameterGroupID,
  ParaGroup.Description AS TestParaGroupDesc,
  ParaGroup.TestParameterGroupType AS ParameterGroupType,
  ParaGroup.TestParameterGroupTypeDescr AS TestParameterGroupTypeDescr,
  ParaGroup.TestParameterGroupCategory AS ParameterGroupCategory,
  ParaGroup.TestParameterGroupCateDescr AS TestParameterGroupCateDescr,
  ParaAss.PARAM_ID AS ParameterID,
  ParaText.TestParameterIDDescription AS TestParameterIDDescription,
  ParaAss.SEQ_NO AS seq_no,
  ParaAss.PARAM_FIELD AS param_field,
  _TstDocPar.param_value AS param_value
FROM /APE/I_TSTDOCPARAMETER_TP AS _TstDocPar
LEFT OUTER JOIN /APE/C_TstDoc_UI AS _TestDoc ON TestDocumentKey = _TestDoc.TestDocumentKey  -- association [1..1]
LEFT OUTER JOIN /APE/C_TestParaGroup_VH AS ParaGroup ON ParameterGroupIDKey = ParaGroup.TestParameterGroupKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_TSTPARAMETER_VH AS ParaText ON ParameterID = ParaText.TestParameterID  -- association [0..1]
;