sfunc_ddl_modules_view

DDL: SFUNC_DDL_MODULES_VIEW SQL: SFUNC_FB_VIEW Type: view Package: SFUNC
3 Fields 3 Data Sources

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. Part of development package SFUNC.

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 Sel.Type: Funct.Name
language t002 spras Off. Language
description tftit stext Text

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 sfunc_ddl_modules_view.
-- 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: SFUNC_FB_VIEW

CREATE VIEW sfunc_ddl_modules_view AS
SELECT
  tfdir.funcname AS name,
  t002.spras AS language,
  tftit.stext AS description
FROM tfdir
CROSS JOIN t002
LEFT OUTER JOIN tftit ON /* join condition not captured in parsed metadata */
;

Learn More