I_TableFieldDefinition

DDL: I_TABLEFIELDDEFINITION SQL: ITABLEFLDDEF Type: view BASIC

Basic layer for Table Fields Data

I_TableFieldDefinition is a Basic CDS View that provides data about "Basic layer for Table Fields Data" in SAP S/4HANA. It reads from 1 data source (dd03l) and exposes 6 fields with key fields ObjectName, DatabaseTableFieldName, DomainActivationState, ACMFieldVersion, ACMFieldPosition.

Data Sources (1)

SourceAliasJoin Type
dd03l dd03l from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ITABLEFLDDEF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
EndUserText.label Basic layer for Table Fields Data view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ObjectName dd03l tabname
KEY DatabaseTableFieldName dd03l fieldname
KEY DomainActivationState dd03l as4local
KEY ACMFieldVersion dd03l as4vers
KEY ACMFieldPosition dd03l position
ABAPDataElement dd03l rollname
/*---------------------------------------------------------------------*
* Copyright  2012 SAP AG. All rights reserved                          *
*----------------------------------------------------------------------*
* CDS Name                : I_TableFieldDefinition                     *
* CDS Description         : Basic View For Fetching Table Fields       *
*                           Definition                                 *
*---------------------------------------------------------------------*/
@AbapCatalog.sqlViewName: 'ITABLEFLDDEF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
@EndUserText.label: 'Basic layer for Table Fields Data'
define view I_TableFieldDefinition as select from dd03l
{
  key dd03l.tabname   as ObjectName,
  key dd03l.fieldname as DatabaseTableFieldName,
  key dd03l.as4local  as DomainActivationState,
  key dd03l.as4vers   as ACMFieldVersion,
  key dd03l.position  as ACMFieldPosition,
  dd03l.rollname as ABAPDataElement
} where dd03l.as4local = 'A'

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