RSRTS_FUNCLIST

DDL: RSRTS_FUNCLIST Type: view_entity

List of functions

RSRTS_FUNCLIST is a CDS View that provides data about "List of functions" in SAP S/4HANA. It reads from 6 data sources and exposes 5 fields with key field functionViewName.

6 data source(s) 5 fields

Data Sources (6)

SourceAliasJoin Type
ddheadanno _list from
ddheadanno _multi left_outer
ddheadanno _rs_elem left_outer
ddheadanno _rs_elem_h left_outer
ddddlsrc02bt _text left_outer
ddheadanno _type left_outer

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label List of functions view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY functionViewName ddheadanno strucobjn
functionType
resultElement ddheadanno value
resultElementHigh ddheadanno value
description ddddlsrc02bt ddtext 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'List of functions'

define view entity RSRTS_FUNCLIST as select from ddheadanno as _list
                                  
  left outer join ddheadanno as _type on _type.strucobjn = _list.strucobjn
                                      and _type.name = 'OBJECTMODEL.DERIVATIONFUNCTION.RESULT.TYPE'
                                      
  left outer join ddheadanno as _multi on _multi.strucobjn = _list.strucobjn
                                      and _multi.name = 'OBJECTMODEL.DERIVATIONFUNCTION.RESULT.MULTIPLERECORDS' 
                                      
left outer join ddheadanno as _rs_elem on _rs_elem.strucobjn = _list.strucobjn
                                      and _rs_elem.name = 'OBJECTMODEL.DERIVATIONFUNCTION.RESULT.ELEMENT' 
                                      
left outer join ddheadanno as _rs_elem_h on _rs_elem_h.strucobjn = _list.strucobjn
                                      and _rs_elem_h.name = 'OBJECTMODEL.DERIVATIONFUNCTION.RESULT.ELEMENTHIGH'                                      
  
left outer join ddddlsrc02bt          as _text  on  _text.strucobjn  =  _list.strucobjn
                                                and _text.as4local   = 'A'
                                                and _text.ddlanguage = $session.system_language                                     

 {

  key  _list.strucobjn as functionViewName,
  
  cast( _type.value as abap.char( 14 ) ) as functionType,
  
  case when _multi.value = ' ' 
        or _multi.value = 'true'
        or _multi.value = 'TRUE' 
       then 'X'
       when _multi.value is null
       then ' '
       else ' '  end                     as MultiRecords,
       
  _rs_elem.value                         as resultElement,
  _rs_elem_h.value                       as resultElementHigh,
  
  _text.ddtext                           as description
  
}
where // _list.name = 'OBJECTMODEL.DERIVATIONFUNCTION'

  _list.name like 'OBJECTMODEL.SUPPORTEDCAPABILITIES%'
  and _list.value = '#DERIVATION_FUNCTION'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDDDLSRC02BT",
"DDHEADANNO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More