sedt_ddl_programs_view

DDL: SEDT_DDL_PROGRAMS_VIEW SQL: SEDT_PROG_VIEW Type: view Package: SEDT

Available programs with shorttext

sedt_ddl_programs_view is a CDS View that provides data about "Available programs with shorttext" in SAP S/4HANA. It reads from 3 data sources (sedt_program, t002, trdirt) and exposes 3 fields with key field name. Part of development package SEDT.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
sedt_program sedt_program from
t002 t002 cross
trdirt trdirt left_outer

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName SEDT_PROG_VIEW view
EndUserText.label Available programs with shorttext view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY name sedt_program name
language t002 spras
description trdirt text 
@AbapCatalog.sqlViewName: 'SEDT_PROG_VIEW'
@EndUserText.label: 'Available programs with shorttext'
define view sedt_ddl_programs_view
  as select from    sedt_program
    cross join      t002
    left outer join trdirt on  sedt_program.name = trdirt.name
                           and t002.spras        = trdirt.sprsl
{
  key sedt_program.name                 as name,
      t002.spras                        as language,
      trdirt.text                       as description
}
where
       sedt_program.name_length <= 30
  and  sedt_program.state       =  'A'

Learn More