/APE/I_TSTPARASSIGN_TP

DDL: /APE/I_TSTPARASSIGN_TP SQL: /APE/I_TSTPARAS Type: view TRANSACTIONAL
11 Fields 1 Data Sources 2 Associations

Test Parameter Assignment

/APE/I_TSTPARASSIGN_TP is a Transactional CDS View that provides data about "Test Parameter Assignment" in SAP S/4HANA. It reads from 1 data source (/APE/I_TestParAssign) and exposes 11 fields with key fields CONFIG_KEY, APE_PARENT_KEY. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_TestParAssign /APE/I_TestParAssign from

Associations (2)

CardinalityTargetAliasCondition
[1..1] /APE/I_TSTPARGROUP_TP _group $projection.APE_PARENT_KEY = _group.CONFIG_KEY
[1..1] /APE/I_TSTPARAMETER_TP _param $projection.PARAM_UUID = _param.CONFIG_KEY

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName /APE/I_TSTPARAS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Test Parameter Assignment view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.writeActivePersistence /APE/TSTPARAS view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence /APE/TSTPARAS_DR view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CONFIG_KEY CONFIG_KEY Char
KEY APE_PARENT_KEY APE_PARENT_KEY
SEQ_NO SEQ_NO Value Number
PARAM_UUID PARAM_UUID UUID
PARAM_ID _param PARAM_ID Report param id
PARAM_PARENT_PATH PARAM_PARENT_PATH
PARAM_PATH PARAM_PATH
PARAM_FIELD PARAM_FIELD
PARAM_VALUE PARAM_VALUE Value
INPUT_FLAG INPUT_FLAG
_group _group

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_TSTPARASSIGN_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.
-- SQL view name: /APE/I_TSTPARAS

CREATE VIEW /APE/I_TSTPARASSIGN_TP AS
SELECT
  CONFIG_KEY,
  APE_PARENT_KEY,
  SEQ_NO,
  PARAM_UUID,
  _param.PARAM_ID AS PARAM_ID,
  PARAM_PARENT_PATH,
  PARAM_PATH,
  PARAM_FIELD,
  PARAM_VALUE,
  INPUT_FLAG
FROM /APE/I_TestParAssign
LEFT OUTER JOIN /APE/I_TSTPARGROUP_TP AS _group ON APE_PARENT_KEY = _group.CONFIG_KEY  -- association [1..1]
LEFT OUTER JOIN /APE/I_TSTPARAMETER_TP AS _param ON PARAM_UUID = _param.CONFIG_KEY  -- association [1..1]
;

Learn More