sedt_program

DDL: SEDT_PROGRAM SQL: SEDT_VIEW_PROG Type: view
31 Fields 1 Data Sources

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.

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 Zone name
KEY state state Vehicle Region
sqlx sqlx Source code protection
edtx edtx Editor lock flag
varcl varcl Case-Sensitive
dbapl dbapl Application database
dbna dbna Logical database
clas clas Program class
type type Worklist Type
occurs occurs Main Memory Size
subc subc Program type
appl appl Rep. Model
secu secu Authorization Group
cnam cnam User Name
cdat cdat Created On
unam unam User Name
udat udat Updated Date
vern vern Version number
levl levl Level
rstat rstat Status of the RunID
rmand rmand Client
rload rload Master Language
fixpt fixpt Fixed point arithmetic
sset sset Start Using Variant Only
sdate sdate Valid From
stime stime Time
idate idate Single-Character Flag
itime itime Single-Character Flag
ldbname ldbname LDB name
uccheck uccheck ABAP Version
name_length

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view sedt_program.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SEDT_VIEW_PROG

CREATE VIEW sedt_program AS
SELECT
  name,
  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
FROM progdir
;

Learn More