FndEI_C_TableAndTableFieldInfo

DDL: FNDEI_C_TABLEANDTABLEFIELDINFO SQL: FNDEITABFLDSINFO Type: view

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.

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 Table/Constant Value
TableShortDescription dd02t ddtext Short text
TableFieldName dd03m fieldname UI Group FieldName
TableFieldShortDescription dd03m ddtext Short text
TableFieldKeyFieldIndicator dd03m keyflag Key field

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 FndEI_C_TableAndTableFieldInfo.
-- 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: FNDEITABFLDSINFO

CREATE VIEW FndEI_C_TableAndTableFieldInfo AS
SELECT
  TableInfos.tabname AS TableName,
  TableTextInfos.ddtext AS TableShortDescription,
  FieldInfos.fieldname AS TableFieldName,
  FieldInfos.ddtext AS TableFieldShortDescription,
  FieldInfos.keyflag AS TableFieldKeyFieldIndicator
FROM dd02l AS TableInfos
INNER JOIN dd02t AS TableTextInfos ON /* join condition not captured in parsed metadata */
INNER JOIN dd03m AS FieldInfos ON /* join condition not captured in parsed metadata */
;