STCDT_CFG_VAL_CDS

DDL: STCDT_CFG_VAL_CDS Type: view_entity Package: STC_CONT_DT

Technical Configuration CFG Validation (Runtime)

STCDT_CFG_VAL_CDS is a CDS View that provides data about "Technical Configuration CFG Validation (Runtime)" in SAP S/4HANA. It reads from 3 data sources (STCDT_TCSET_CDS, stcdt_tcset_cfg, stcdt_tcset_par) and exposes 12 fields with key fields LAYER, LM_SCENARIO_ID, LM_SCENARIO_STEP, CCU_LOGNAME, CCU_LOGNAME_ROOT. Part of development package STC_CONT_DT.

Data Sources (3)

SourceAliasJoin Type
STCDT_TCSET_CDS A from
stcdt_tcset_cfg B inner
stcdt_tcset_par C inner

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Technical Configuration CFG Validation (Runtime) view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LAYER STCDT_TCSET_CDS LAYER TC Layer
KEY LM_SCENARIO_ID STCDT_TCSET_CDS LM_SCENARIO_ID LM Scenario
KEY LM_SCENARIO_STEP STCDT_TCSET_CDS LM_SCENARIO_STEP LM Scenario Step
KEY CCU_LOGNAME STCDT_TCSET_CDS CCU_LOGNAME TC Set
KEY CCU_LOGNAME_ROOT STCDT_TCSET_CDS CCU_LOGNAME_ROOT
KEY CFG_ID stcdt_tcset_cfg cfg_id Configuration ID
KEY FIELDNAME stcdt_tcset_par fieldname UI Group FieldName
CC_ID STCDT_TCSET_CDS CC_ID Content ID
CCU_TYPE STCDT_TCSET_CDS CCU_TYPE TC Set Type
CCP_MODE stcdt_tcset_par ccp_mode Mode
VALUE stcdt_tcset_par value Value from table
TEMPLATE_TYPE STCDT_TCSET_CDS TEMPLATE_TYPE Template Type

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 STCDT_CFG_VAL_CDS.
-- 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 STCDT_CFG_VAL_CDS AS
SELECT
  A.LAYER AS LAYER,
  A.LM_SCENARIO_ID AS LM_SCENARIO_ID,
  A.LM_SCENARIO_STEP AS LM_SCENARIO_STEP,
  A.CCU_LOGNAME AS CCU_LOGNAME,
  A.CCU_LOGNAME_ROOT AS CCU_LOGNAME_ROOT,
  B.cfg_id AS CFG_ID,
  C.fieldname AS FIELDNAME,
  A.CC_ID AS CC_ID,
  A.CCU_TYPE AS CCU_TYPE,
  C.ccp_mode AS CCP_MODE,
  C.value AS VALUE,
  A.TEMPLATE_TYPE AS TEMPLATE_TYPE
FROM STCDT_TCSET_CDS AS A
INNER JOIN stcdt_tcset_cfg AS B ON /* join condition not captured in parsed metadata */
INNER JOIN stcdt_tcset_par AS C ON /* join condition not captured in parsed metadata */
;