Ansicht
Dokumentation

ABENDDICDDL_DEFINE_TABLE_COMPS - DDICDDL DEFINE TABLE COMPS

ROGBILLS - Synchronize billing plans   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

- DEFINE TABLE, field

$[component_annos$]
$[foreign_key_annos$]
$[geo_annos$]
$[KEY$] field : ${data_element $[foreign_key$]
$[value_help$]$}
              $|abap.type$[(n)$|(n,m)$]
              $[NOT NULL$];

Effect

Defines a single database field in the definition of a DDIC database table using the Dictionary DDL statement DEFINE TABLE.

• In front of the field, annotations component_annos can be used to specify the same optional component properties as in the definition of a structure using DEFINE STRUCTURE.

• foreign_key_annos can be used to specify the properties of a foreign key dependency defined with foreign_key.

• geo_annos is used to specify special properties of a component with the geodata type GEOM_EWKB.

• The addition KEY defines the table field as a key field.

• field indicates the name of the database field.

• data_element or abap.type is used to define the data type of the table field. The same rules apply as in the definition of a structure component, except that only elementary types can be specified here.

• The addition NOT NULL is used to set the flag for initial values.

• The addition foreign_key can be used to define a foreign key dependency for a table field whose data type is defined using a data element.

• The addition value_help can be used to assign a search help to a table field whose data type is defined using a data element. This is only applicable to table fields used for input fields of dynpros or Web Dynpros (which is not recommended) and the same applies as in the definition of a structure component.

Example

Defines the DDIC database table DEMO_EXPRESSIONS in the Dictionary DDL of the ABAP Development Tools. The types of all fields are determined directly using built-in data types in the ABAP Dictionary.

@EndUserText.label : 'Database table for Expression Examples'
@AbapCatalog.enhancementCategory : #NOT_EXTENSIBLE
@AbapCatalog.tableCategory : #TRANSPARENT
@AbapCatalog.deliveryClass : #A
@AbapCatalog.dataMaintenance : #ALLOWED
define table demo_expressions {
  key mandt  : mandt not null;
  key id     : char1 not null;
  num1       : abap.int4;
  num2       : abap.int4;
  numlong1   : abap.int8;
  numlong2   : abap.int8;
  dec1       : abap.dec(31,0);
  dec2       : abap.dec(31,10);
  dec3       : abap.dec(10,3);
  fltp1      : abap.fltp;
  fltp2      : abap.fltp;
  decf1      : abap.df34_dec(31,0);
  decf2      : abap.df34_dec(31,0);
  char1      : abap.char(10);
  char2      : abap.char(10);
  numc1      : abap.numc(10);
  numc2      : abap.numc(10);
  string1    : abap.string(0);
  string2    : abap.string(0);
  raw1       : abap.raw(10);
  raw2       : abap.raw(10);
  xstring1   : abap.rawstring(0);
  xstring2   : abap.rawstring(0);
  dats1      : abap.dats;
  dats2      : abap.dats;
  tims1      : abap.tims;
  tims2      : abap.tims;
  timestamp1 : abap.dec(15,0);
  timestamp2 : abap.dec(15,0); }

General Data in Customer Master   General Material Data  
This documentation is copyright by SAP AG.

Length: 7716 Date: 20240419 Time: 214441     sap01-206 ( 56 ms )