FndEI_C_TableAndTableFieldInfo

DDL: FNDEI_C_TABLEANDTABLEFIELDINFO SQL: FNDEITABFLDSINFO Type: view Package: FNDEI_VR_CDS_COMPOSITE

External info of Tables and TableFields

FndEI_C_TableAndTableFieldInfo is a CDS View that provides data about "External info of Tables and TableFields" in SAP S/4HANA. It reads from 3 data sources (dd03m, dd02l, dd02t) and exposes 5 fields with key field TableName. Part of development package FNDEI_VR_CDS_COMPOSITE.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
dd03m FieldInfos inner
dd02l TableInfos from
dd02t TableTextInfos inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FNDEITABFLDSINFO view
ObjectModel.usageType.dataClass #META view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label External info of Tables and TableFields view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TableName dd02l tabname
TableShortDescription dd02t ddtext
TableFieldName dd03m fieldname
TableFieldShortDescription dd03m ddtext
TableFieldKeyFieldIndicator dd03m keyflag 
@AbapCatalog.sqlViewName: 'FNDEITABFLDSINFO'
@ObjectModel.usageType.dataClass: #META
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:  #L
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'External info of Tables and TableFields'
define view FndEI_C_TableAndTableFieldInfo
  as select from dd02l as TableInfos
    inner join   dd02t as TableTextInfos on TableInfos.tabname = TableTextInfos.tabname
    inner join   dd03m as FieldInfos     on TableInfos.tabname = FieldInfos.tabname
{
  key TableInfos.tabname    as TableName,
      TableTextInfos.ddtext as TableShortDescription,
      FieldInfos.fieldname  as TableFieldName,
      FieldInfos.ddtext     as TableFieldShortDescription,
      FieldInfos.keyflag    as TableFieldKeyFieldIndicator
}

where
        TableInfos.tabclass       =  'TRANSP'
  and   TableInfos.as4local       =  'A' //Repository Object Activation Status

  and   FieldInfos.fldstat        =  'A' //Repository Object Activation Status

  and   TableTextInfos.ddlanguage =  'E'
  and   FieldInfos.ddlanguage     =  'E'

  and(
        FieldInfos.fieldname      <> 'MANDT'
    and FieldInfos.fieldname      <> 'CLIENT'
  )

Learn More