SEDT_FUNC

CDS View

SEDT_FUNC is a CDS View in S/4HANA. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
sedt_prog_tadir view left_outer

Fields (2)

KeyField CDS FieldsUsed in Views
func_include object_name 1
funcname alias_name,func_name,object_name 3 
@AbapCatalog.sqlViewName: 'SEDT_FUNC_VIEW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: 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',replace(tfdir.pname, 'SAPL', '')),'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',replace(tfdir.pname, 'SAPL', '')),'$'),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',replace(tfdir.pname, 'SAPL', '')),'V'),tfdir.include)
      end as func_v_include
}

Learn More