sfunc_ddl_modules_view

DDL: SFUNC_DDL_MODULES_VIEW SQL: SFUNC_FB_VIEW Type: view

View on available function modules

sfunc_ddl_modules_view is a CDS View that provides data about "View on available function modules" in SAP S/4HANA. It reads from 3 data sources (t002, tfdir, tftit) and exposes 3 fields.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
t002 t002 cross
tfdir tfdir from
tftit tftit left_outer

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName SFUNC_FB_VIEW view
EndUserText.label View on available function modules view

Fields (3)

KeyFieldSource TableSource FieldDescription
name tfdir funcname
language t002 spras
description tftit stext 
@AbapCatalog.sqlViewName: 'SFUNC_FB_VIEW'
@EndUserText.label: 'View on available function modules'
define view sfunc_ddl_modules_view
  as select from    tfdir
    cross join      t002
    left outer join tftit on  tfdir.funcname = tftit.funcname
                          and t002.spras     = tftit.spras
{
  tfdir.funcname as name,
  t002.spras     as language,
  tftit.stext    as description
}

Learn More