Monday, December 15, 2008

Creating Tables

Creating Tables

Tcode: SE11

Steps in Creating a table:

1.Create domain – technical characteristics-Field type, No. of characters, Value range

2.Create data element – semantic char-Short,Medium,Long labels, Search help

3.Create table

ABAP Dictionary-SE11

Enter the name of the custom table to be created.
The name should begin from 'Z' .

Table Creation

Specify the Delivery Class and Table Maintenance.


Technical Settings

Specify the Data class , Size category ,Buffering parameters.

Adding Fields
Add fields alongwith data elements or directly.
You can also specify the foreign key relationship between linked tables.
Table types:
Client Dependant Tables:
If the first field of the table is 'mandt', it is client dependant table and the data type is 'clnt'.
Client Independant Tables:
If the first field is not 'mandt' it is client independant table.





No comments:

Post a Comment