Creation of table in DD.

[Former Member]

Can I have the example of how to create a table in DD with screenshots.

thank u.

[Former Member]

Hi,

Procedure

...

...

1. Select Database Tables in the Dictionary Explorer.

2. Choose Create Table from the context menu.

3. Enter a name for the table.

The following rules apply to table names:

○ Table names must begin with a prefix (for example, the name of a component u201AFI_*u2019).

○ The name of a table can be up to 18 characters long (inclusive of the prefix).

○ Open SQL Keywords are not permitted. SELECT, INSERT, UPDATE, MODIFY and DELETE are some of the Open SQL Keywords.

○ The permitted characters are: letters, numbers, and underscores.

Name reservation takes place when the Dictionary object is assigned to an activity (checked in to the Design Time Repository). If the name is already reserved, you can create the table, but you cannot save it in the DTR.

4. In the field Description, enter a short description for the table.

5. To create new columns, choose Add Column.

6. To define one of the built-in data types as the type of the column, choose Built-in Type.

...

a. Enter a name for the column in the Column Name field.

The name may only contain letters, digits, and underscores. The name must begin with a letter.

b. In the Built-in Type field, choose a data type. The JDBC Type field is automatically set and provides information about the underlying, database-independent JDBC type that results from the selected built-in type and from the length entered for the field.

c. Complete the Length, Decimals (decimal point precision), and Description fields if necessary.

d. To enter a default value for the database, enter the value in the DB Default field. For more information, see Initial Values.

e. If the field is part of a primary key, choose Key.

f. If the field cannot accept and store null values, choose Not Null. For more information, see Initial Values.

7. To define a type defined in the Java Dictionary as the data type of the column, choose Simple Type.

a. Enter a name for the column in the Column name field.

b. Choose Browse and select the simple type to use from the Simple Type Selection dialog. Choose OK. The SAP NetWeaver Developer Studio completes the Simple type package, Built-in type, JDBC type, and Length fields automatically.

8. If necessary, create indices for the table. For more information, see Creating Indexes.

9. Choose the Table Buffering tab. Here you can define the buffering type for the table. The table can be buffered entirely or row by row. If the table contains more than one key field, generic areas can be buffered. For more information, see Buffering Type.

To exclude databases you are not using, choose Advanced. When you create a table, different checks are carried out. If no database is excluded, the checks will be based on all the specified databases.

[Former Member]

Hi Naresh

thank u very much for the reply.

Can I find screenshot example that wud b more easier for me..?

[Former Member]

Thank u all for the prompt replies..

[Former Member]

Hi,

please check this link

Creation of Transparent Table ( with Screenshots)

http://www.saptechnical.com/Tutorials/ABAP/TableCreate/page1.htm

Best regards,

raam