/CFG/CCP_STEP_TIME_CDS

DDL: /CFG/CCP_STEP_TIME_CDS SQL: /CFG/CCP_STEP_TM Type: view

step runtime duration CDS

/CFG/CCP_STEP_TIME_CDS is a CDS View that provides data about "step runtime duration CDS" in SAP S/4HANA. It reads from 2 data sources (/CFG/CCP_STEP_RUN_ID, /cfg/ccp_log_i) and exposes 10 fields with key fields pro_id, step, run_id.

Data Sources (2)

SourceAliasJoin Type
/CFG/CCP_STEP_RUN_ID /CFG/CCP_STEP_RUN_ID inner
/cfg/ccp_log_i log from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /CFG/CCP_STEP_TM view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.dataClass TRANSACTIONAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label step runtime duration CDS view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY pro_id runs pro_id CCP Pro ID
KEY step runs step Step Number
KEY run_id runs run_id UUID
job_name /cfg/ccp_log_i job_name Job No.
job_count /cfg/ccp_log_i job_count Job No.
duration /cfg/ccp_log_i duration Tot.Duration in Days
test_sysid /cfg/ccp_log_i test_sysid System ID
test_client /cfg/ccp_log_i test_client Client
start_dt /cfg/ccp_log_i start_dt Start Date
start_tm /cfg/ccp_log_i start_tm Execution Date

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 /CFG/CCP_STEP_TIME_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.
-- SQL view name: /CFG/CCP_STEP_TM

CREATE VIEW /CFG/CCP_STEP_TIME_CDS AS
SELECT
  runs.pro_id AS pro_id,
  runs.step AS step,
  runs.run_id AS run_id,
  log.job_name AS job_name,
  log.job_count AS job_count,
  log.duration AS duration,
  log.test_sysid AS test_sysid,
  log.test_client AS test_client,
  log.start_dt AS start_dt,
  log.start_tm AS start_tm
FROM /cfg/ccp_log_i AS log
INNER JOIN /CFG/CCP_STEP_RUN_ID ON /* join condition not captured in parsed metadata */
;