CDR_I_TABLE_INFO

DDL: CDR_I_TABLE_INFO Type: view_entity

Table info view for TSD

CDR_I_TABLE_INFO is a CDS View that provides data about "Table info view for TSD" in SAP S/4HANA. It reads from 4 data sources (dd02l, df14l, tadir, tdevc) and exposes 10 fields with key field tabname.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
dd02l dd02l from
df14l df14l inner
tadir tadir inner
tdevc tdevc inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Table info view for TSD view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY tabname dd02l tabname
tabclass dd02l tabclass
applclass dd02l applclass
clidep dd02l clidep
contflag dd02l contflag
devclass tdevc devclass
packtype tdevc packtype
dlvunit tdevc dlvunit
pdevclass tdevc pdevclass
ps_posid df14l ps_posid 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Table info view for TSD'
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #M,
  dataClass: #MIXED
}

define view entity CDR_I_TABLE_INFO
  as select from dd02l as dd02l
    inner join   tadir as tadir on dd02l.tabname = tadir.obj_name
    inner join   tdevc as tdevc on tadir.devclass = tdevc.devclass
    inner join   df14l as df14l on tdevc.component = df14l.fctr_id
{
  key dd02l.tabname,
      dd02l.tabclass,
      dd02l.applclass,
      dd02l.clidep,
      dd02l.contflag,
      tdevc.devclass,
      tdevc.packtype,
      tdevc.dlvunit,
      tdevc.pdevclass,
      df14l.ps_posid
}
where
      tadir.pgmid    = 'R3TR'
  and tadir.object   = 'TABL'
  and dd02l.as4local = 'A'
  and dd02l.tabclass = 'TRANSP'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD02L",
"DF14L",
"TADIR",
"TDEVC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More