sedt_program

DDL: SEDT_PROGRAM SQL: SEDT_VIEW_PROG Type: view

Programs with state and name length

sedt_program is a CDS View that provides data about "Programs with state and name length" in SAP S/4HANA. It reads from 1 data source (progdir) and exposes 31 fields with key fields name, state.

1 data source(s) 31 fields

Data Sources (1)

SourceAliasJoin Type
progdir progdir from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName SEDT_VIEW_PROG view
EndUserText.label Programs with state and name length view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY name name
KEY state state
sqlx sqlx
edtx edtx
varcl varcl
dbapl dbapl
dbna dbna
clas clas
type type
occurs occurs
subc subc
appl appl
secu secu
cnam cnam
cdat cdat
unam unam
udat udat
vern vern
levl levl
rstat rstat
rmand rmand
rload rload
fixpt fixpt
sset sset
sdate sdate
stime stime
idate idate
itime itime
ldbname ldbname
uccheck uccheck
name_length 
@AbapCatalog.sqlViewName: 'SEDT_VIEW_PROG'
@EndUserText.label: 'Programs with state and name length'
define view sedt_program
  as select from progdir
{
  key name,
  key state,
      sqlx,
      edtx,
      varcl,
      dbapl,
      dbna,
      clas,
      type,
      occurs,
      subc,
      appl,
      secu,
      cnam,
      cdat,
      unam,
      udat,
      vern,
      levl,
      rstat,
      rmand,
      rload,
      fixpt,
      sset,
      sdate,
      stime,
      idate,
      itime,
      ldbname,
      uccheck,
      length( name )          as name_length,
      substring( name,31,10 ) as name_extension

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PROGDIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More