cross_relation_func_intf

DDL: CROSS_RELATION_FUNC_INTF SQL: CROSS_REL_F_I_V Type: view

Source code relation function module interface

cross_relation_func_intf is a CDS View that provides data about "Source code relation function module interface" in SAP S/4HANA. It reads from 5 data sources (dd02l, ddtypes, cross_fupararef, cross_fupararef, sedt_type) and exposes 5 fields.

5 data source(s) 5 fields

Data Sources (5)

SourceAliasJoin Type
dd02l dd02l left_outer
ddtypes ddtypes left_outer
cross_fupararef relation from
cross_fupararef relation union_all
sedt_type type_groups left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CROSS_REL_F_I_V view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Source code relation function module interface view

Fields (5)

KeyFieldSource TableSource FieldDescription
include cross_fupararef include
used_object cross_fupararef used_object
fullname
used_object sedt_type type_group_name
used_type 
@AbapCatalog.sqlViewName: 'CROSS_REL_F_I_V'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Source code relation function module interface'
define view cross_relation_func_intf

  //ddic stuff without type groups

  as select from    cross_fupararef as relation
    left outer join ddtypes on ddtypes.typename = relation.used_object
    left outer join dd02l   on  dd02l.tabname  = relation.used_object
                            and dd02l.tabclass = 'INTTAB'
{
  relation.include     as include,
  case
    when relation.used_object_1 = '''' or relation.used_object_1 = '0' or relation.used_object_1 = '1'
      or relation.used_object_1 = '2' or relation.used_object_1 = '3' or relation.used_object_1 = '4'
      or relation.used_object_1 = '5' or relation.used_object_1 = '6' or relation.used_object_1 = '7'
      or relation.used_object_1 = '8' or relation.used_object_1 = '9' or relation.used_object_1 = '-'
     then ''
    else concat('\TY:', relation.used_object )
                    end  as fullname,
  relation.used_object as used_object,
  case dd02l.tabclass
    when 'INTTAB' then 'STRU'
    else ddtypes.typekind
  end                  as used_type
}

union all

// type groups

select from       cross_fupararef as relation
  left outer join sedt_type       as type_groups on  relation.type_group = type_groups.type_group_include
                                                 and type_groups.state   = 'A'
{
  relation.include            as include,
  ''                          as fullname,
  type_groups.type_group_name as used_object,
  'TYPE'                      as used_type
}
where
  type_groups.type_group_include is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CROSS_FUPARAREF",
"SEDT_TYPE",
"DD02L",
"DDTYPES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More