ABAP Keyword Documentation → ABAP - Dictionary → Classic Objects in ABAP Dictionary → Database Tables → Dictionary DDL for Defining Database Tables → DEFINE TABLE

DEFINE TABLE - table_annos

Other versions: ~~7.31~~ | ~~7.40~~ | 7.54

Syntax


@AbapCatalog.tableCategory : table_cat 
@AbapCatalog.dataMaintenance : data_maint 

@AbapCatalog.deliveryClass : deliv_class 
 
[@AbapCatalog.activationType : act_type] 
[@AbapCatalog.replacementObject : '...']

Effect

Annotations for specifying table properties in the definition of a database table using the statement DEFINE TABLE in the Dictionary DDL.

Mandatory Definitions

@AbapCatalog.tableCategory defines the table category. table_cat can be specified as:

#TRANSPARENT - transparent table

#GLOBAL_TEMPORARY - global temporary table (GTT)

@AbapCatalog.dataMaintenance defines how the database table is displayed and edited. data_maint can be specified as:

#NOT_ALLOWED - no display/editing

#LIMITED - limited display/editing

#ALLOWED - display/editing allowed

@AbapCatalog.deliveryClass defines the delivery class of the database table. deliv_class can be specified as:

#A - delivery class A

#C - delivery class C

#L - delivery class L

#G - delivery class G

#E - delivery class E

#S - delivery class S

#W - delivery class W

Optional Definitions

@AbapCatalog.tableCategory defines the activation type of the database table. This setting is not relevant for database tables in application programming. act_type can be specified as:

#NOT_CLASSIFIED - activation type 00

#NAMETAB_GENERATION_OFFLINE - activation type 01

#ADAPT_C_STRUCTURES - activation type 02

#INITIAL_TABLE_REQUIRED - activation type 10

@AbapCatalog.replacementObject defines the name of a replacement object in quotation marks.

Example

Annotations in the definition of the database table DEMO_SUMDIST in the Dictionary DDL of the ABAP Development Tools. This table has the CDS view DEMO_CDS_SUMDIST as its replacement object.

@EndUserText.label : 'Aggregation Table with Replacement Object'
@AbapCatalog.enhancementCategory : #NOT_EXTENSIBLE
@AbapCatalog.tableCategory : #TRANSPARENT
@AbapCatalog.deliveryClass : #A
@AbapCatalog.dataMaintenance : #LIMITED
@AbapCatalog.replacementObject : 'demo_cds_sumdist'
define table demo_sumdist {
  key client   : mandt not null;
  key carrname : s_carrname not null;
  key distid   : s_distid not null;
  @Semantics.quantity.unitOfMeasure : 'demo_sumdist.distid'
  sum_distance : s_distance; }