CNV_PE_MC_STEP_INFO_T

DDL: CNV_PE_MC_STEP_INFO_T SQL: CNV_PE_STEP_T Type: view
11 Fields 1 Data Sources

Step full information

CNV_PE_MC_STEP_INFO_T is a CDS View that provides data about "Step full information" in SAP S/4HANA. It reads from 1 data source (CNV_PE_MC_STEP_INFO) and exposes 11 fields.

Data Sources (1)

SourceAliasJoin Type
CNV_PE_MC_STEP_INFO CNV_PE_MC_STEP_INFO from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CNV_PE_STEP_T view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
EndUserText.label Step full information view

Fields (11)

KeyFieldSource TableSource FieldDescription
area_id area_id Scope Area
option_id option_id
option_descr option_descr
option_num option_num
step_id step_id WF Step ID
step_seq step_seq
step_descr step_descr
step_full
step_num step_num
with_result with_result
nav_valid nav_valid

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 CNV_PE_MC_STEP_INFO_T.
-- 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: CNV_PE_STEP_T

CREATE VIEW CNV_PE_MC_STEP_INFO_T AS
SELECT
  area_id,
  option_id,
  option_descr,
  option_num,
  step_id,
  step_seq,
  step_descr,
  concat(concat(concat(concat(concat(step_descr,'('), step_seq),'/'),step_num),')') AS step_full,
  step_num,
  with_result,
  nav_valid
FROM CNV_PE_MC_STEP_INFO
;

Learn More