sdsh_cds_table_fields_info

DDL: SDSH_CDS_TABLE_FIELDS_INFO Type: view_entity

Detailed Information about Table/View fields

sdsh_cds_table_fields_info is a CDS View that provides data about "Detailed Information about Table/View fields" in SAP S/4HANA. It reads from 2 data sources (dd02l, dd03l) and exposes 5 fields.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
dd02l dd02l from
dd03l dd03l inner

Annotations (1)

NameValueLevelField
EndUserText.label Detailed Information about Table/View fields view

Fields (5)

KeyFieldSource TableSource FieldDescription
tabname dd02l tabname
fieldname dd03l fieldname
tabclass dd02l tabclass
shlporigin dd03l shlporigin
checktable dd03l checktable 
@EndUserText.label: 'Detailed Information about Table/View fields'
define view entity sdsh_cds_table_fields_info as select from
  dd02l inner join dd03l 
  on dd02l.tabname = dd03l.tabname
  {
    dd02l.tabname as tabname,
    dd03l.fieldname as fieldname,
    dd02l.tabclass as tabclass,
    dd03l.shlporigin as shlporigin,
    dd03l.checktable as checktable
  } where dd02l.as4local = 'A' and 
          dd03l.as4local = 'A' and
          dd03l.shlporigin = 'F' or // Domain-fixed values

          ( dd03l.shlporigin = 'P' and 
            dd03l.checktable <> ' ' and
            dd03l.checktable <> '*' and
            dd03l.checktable <> '0') // Check tables

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

Learn More