SEDT_PROGRAM
Programs with state and name length
SEDT_PROGRAM is a CDS View in S/4HANA. Programs with state and name length. It contains 1 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| sedt_ddl_programs_view | view | from | Available programs with shorttext |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | name | name | 1 |
@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
}