cnv_pe_mc_tranlst_parameter

DDL: CNV_PE_MC_TRANLST_PARAMETER Type: view_entity Package: CNV_PE_MC
13 Fields 5 Data Sources

Transfer List Parameter

cnv_pe_mc_tranlst_parameter is a CDS View that provides data about "Transfer List Parameter" in SAP S/4HANA. It reads from 5 data sources (cnv_pe_if_par, cnv_pe_if_par, cnv_pe_object_t, cnv_pe_object_t, cnv_pe_if_par) and exposes 13 fields. Part of development package CNV_PE_MC.

Data Sources (5)

SourceAliasJoin Type
cnv_pe_if_par grand_par left_outer
cnv_pe_if_par par from
cnv_pe_object_t par_t_en left_outer
cnv_pe_object_t par_t_logon left_outer
cnv_pe_if_par parent_par left_outer

Annotations (6)

NameValueLevelField
EndUserText.label Transfer List Parameter view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
ParameterID cnv_pe_if_par id WorklistID
InterfaceID cnv_pe_if_par if_id InterfaceID
ParameterName cnv_pe_if_par name Zone name
Parameterkind cnv_pe_if_par kind Usage Data Source
ParameterType cnv_pe_if_par type Worklist Type
IsKey cnv_pe_if_par is_key Key field
IntType cnv_pe_if_par inttype Interest Type
ParameterTypeName cnv_pe_if_par typename Type Name
ParameterNumber
parent_idendasParentID
inttextendasParameterDescription
type11thenXelseendasis_table_structure
type11thenXelseendasis_table

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_tranlst_parameter.
-- 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 cnv_pe_mc_tranlst_parameter AS
SELECT
  par.id AS ParameterID,
  par.if_id AS InterfaceID,
  par.name AS ParameterName,
  par.kind AS Parameterkind,
  par.type AS ParameterType,
  par.is_key AS IsKey,
  par.inttype AS IntType,
  par.typename AS ParameterTypeName,
  cast( par.par_nr as abap.int4 ) AS ParameterNumber,
  case when parent_par.type = '02' and ( grand_par.type = '03' or grand_par.type = '06' or grand_par.type = '10' or grand_par.type = '11' ) then grand_par.id else par.parent_id end as ParentID AS parent_idendasParentID,
  case when par_t_logon.descr is not initial then par_t_logon.descr when par_t_en.descr is not initial then par_t_en.descr else par.inttext end as ParameterDescription AS inttextendasParameterDescription,
  case when par.type = '02' and ( parent_par.type = '03' or parent_par.type = '06' or parent_par.type = '10' or parent_par.type = '11' ) then 'X' else '' end as is_table_structure AS type11thenXelseendasis_table_structure,
  case when par.type = '03' or par.type = '06' or par.type = '10' or par.type = '11' then 'X' else '' end as is_table AS type11thenXelseendasis_table
FROM cnv_pe_if_par AS par
LEFT OUTER JOIN cnv_pe_object_t AS par_t_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_object_t AS par_t_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_if_par AS parent_par ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_if_par AS grand_par ON /* join condition not captured in parsed metadata */
;

Learn More