sedt_func

DDL: SEDT_FUNC SQL: SEDT_FUNC_VIEW Type: view Package: SEDI_PROGDIR

Function Module Include - Function Module

sedt_func is a CDS View that provides data about "Function Module Include - Function Module" in SAP S/4HANA. It reads from 2 data sources (sedt_fugr, tfdir) and exposes 4 fields with key fields funcname, state. Part of development package SEDI_PROGDIR.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
sedt_fugr sedt_fugr left_outer
tfdir tfdir from

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName SEDT_FUNC_VIEW view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY funcname tfdir funcname
KEY state sedt_fugr state
pname tfdir pname
fugr_with_ns sedt_fugr fugr_with_ns 
@AbapCatalog.sqlViewName: 'SEDT_FUNC_VIEW'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view sedt_func
  as select from    tfdir
    left outer join sedt_fugr on sedt_fugr.fugr_include = tfdir.pname
{
  key tfdir.funcname,
  key sedt_fugr.state,
      tfdir.pname,
      sedt_fugr.fugr_with_ns,
      sedt_fugr.is_customer_exit,
      case
        when sedt_fugr.ns_splitter_pos = 02 then substring(tfdir.pname,1, 03)
        when sedt_fugr.ns_splitter_pos = 03 then substring(tfdir.pname,1, 04)
        when sedt_fugr.ns_splitter_pos = 04 then substring(tfdir.pname,1, 05)
        when sedt_fugr.ns_splitter_pos = 05 then substring(tfdir.pname,1, 06)
        when sedt_fugr.ns_splitter_pos = 06 then substring(tfdir.pname,1, 07)
        when sedt_fugr.ns_splitter_pos = 07 then substring(tfdir.pname,1, 08)
        when sedt_fugr.ns_splitter_pos = 08 then substring(tfdir.pname,1, 09)
        when sedt_fugr.ns_splitter_pos = 09 then substring(tfdir.pname,1, 10)
        when sedt_fugr.ns_splitter_pos = 10 then substring(tfdir.pname,1, 11)
        else ''
      end as namespace,
      case
        when sedt_fugr.ns_splitter_pos = 02 then substring(tfdir.pname,08, 26)
        when sedt_fugr.ns_splitter_pos = 03 then substring(tfdir.pname,09, 26)
        when sedt_fugr.ns_splitter_pos = 04 then substring(tfdir.pname,10, 26)
        when sedt_fugr.ns_splitter_pos = 05 then substring(tfdir.pname,11, 26)
        when sedt_fugr.ns_splitter_pos = 06 then substring(tfdir.pname,12, 26)
        when sedt_fugr.ns_splitter_pos = 07 then substring(tfdir.pname,13, 26)
        when sedt_fugr.ns_splitter_pos = 08 then substring(tfdir.pname,14, 26)
        when sedt_fugr.ns_splitter_pos = 09 then substring(tfdir.pname,15, 26)
        when sedt_fugr.ns_splitter_pos = 10 then substring(tfdir.pname,16, 26)
        else substring(tfdir.pname,5, 26)
      end as fugr,
      case
        when sedt_fugr.ns_splitter_pos > 0 then concat(concat(replace(tfdir.pname, '/SAPL', '/L'),'U'),tfdir.include)
        else concat(concat(concat('L',substring(tfdir.pname, 5, 40)),'U'),tfdir.include)
      end as func_include,
      case
        when sedt_fugr.ns_splitter_pos > 0 then concat(concat(replace(tfdir.pname, '/SAPL', '/L'),'$'),tfdir.include)
        else concat(concat(concat('L',substring(tfdir.pname, 5 , 40)),'$'),tfdir.include)
      end as func_intf_include,
      case
        when sedt_fugr.ns_splitter_pos > 0 then concat(concat(replace(tfdir.pname, '/SAPL', '/L'),'V'),tfdir.include)
        else concat(concat(concat('L',substring(tfdir.pname, 5, 40)),'V'),tfdir.include)
      end as func_v_include
}

Learn More