Tddl_Api_Trdir

DDL: TDDL_API_TRDIR SQL: TDDLAPITRDIR Type: view
29 Fields 1 Data Sources

Tddl_Api_Trdir is a CDS View in SAP S/4HANA. It reads from 1 data source (trdir) and exposes 29 fields with key field name.

Data Sources (1)

SourceAliasJoin Type
trdir trdir from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName TDDLAPITRDIR view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY name name Zone name
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

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 Tddl_Api_Trdir.
-- 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: TDDLAPITRDIR

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

Learn More