/APE/C_TESTPARAMETERAS

DDL: /APE/C_TESTPARAMETERAS SQL: /APE/C_VTSTPARAS Type: view CONSUMPTION
16 Fields 1 Data Sources 2 Associations

Test Parameter Assign

/APE/C_TESTPARAMETERAS is a Consumption CDS View that provides data about "Test Parameter Assign" in SAP S/4HANA. It reads from 1 data source (/APE/I_TSTPARASSIGN_TP) and exposes 16 fields with key field CONFIG_KEY. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_TSTPARASSIGN_TP /APE/I_TSTPARASSIGN_TP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] /APE/C_TestParameter _para $projection.PARAM_UUID = _para.CONFIG_KEY
[1..1] /APE/C_TestParGroup _paragp $projection.APE_PARENT_KEY = _paragp.CONFIG_KEY

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_VTSTPARAS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Test Parameter Assign view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CONFIG_KEY CONFIG_KEY Char
APE_PARENT_KEY APE_PARENT_KEY
PARAM_UUID PARAM_UUID UUID
SEQ_NO SEQ_NO Value Number
PARAM_PARENT_PATH PARAM_PARENT_PATH
PARAM_PATH PARAM_PATH
PARAM_FIELD PARAM_FIELD
PARAM_VALUE PARAM_VALUE Value
INPUT_FLAG INPUT_FLAG
BO_TYPE_UUID _para BO_TYPE_UUID
PARAM_ID _para PARAM_ID Report param id
PARAM_GROUP_CAT _paragp PARAM_GROUP_CAT
PARAM_GROUP_TYPE _paragp PARAM_GROUP_TYPE
PARAM_GROUP_ID _paragp PARAM_GROUP_ID
_para _para
_paragp _paragp

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_TESTPARAMETERAS.
-- 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_VTSTPARAS

CREATE VIEW /APE/C_TESTPARAMETERAS AS
SELECT
  CONFIG_KEY,
  APE_PARENT_KEY,
  PARAM_UUID,
  SEQ_NO,
  PARAM_PARENT_PATH,
  PARAM_PATH,
  PARAM_FIELD,
  PARAM_VALUE,
  INPUT_FLAG,
  _para.BO_TYPE_UUID AS BO_TYPE_UUID,
  _para.PARAM_ID AS PARAM_ID,
  _paragp.PARAM_GROUP_CAT AS PARAM_GROUP_CAT,
  _paragp.PARAM_GROUP_TYPE AS PARAM_GROUP_TYPE,
  _paragp.PARAM_GROUP_ID AS PARAM_GROUP_ID
FROM /APE/I_TSTPARASSIGN_TP
LEFT OUTER JOIN /APE/C_TestParameter AS _para ON PARAM_UUID = _para.CONFIG_KEY  -- association [1..1]
LEFT OUTER JOIN /APE/C_TestParGroup AS _paragp ON APE_PARENT_KEY = _paragp.CONFIG_KEY  -- association [1..1]
;

Learn More