table

[Former Member]

Can anyone give me the steps for the following.......detailed steps

1. Create a table called employees.

The table should contain:

• employee id type numc10 (primary key)

• first name type char40

• last name type char40

• occupation type char40

• date of joining type date

• monthly salary type currency

2. All data elements and domains need to be created

3. Create a maintenance view for the table

4. Enter 10 records into the table

How to do this........

Thanks In advance.........

[Former Member]

from se11 u can each and every thing,

Regards

peram

[che_eky]

Ravindar,

Why not have a go at it yourself its really not that difficult. If you come across any real issue then post your question here.

C

[Former Member]

hi

<b>Steps to Creating domains, Data Elements, Tables

To give you the steps for creating table:.</b>

There are two approach in creating a table.

1. Bottom-up approach

2. Top-down approach.

Both are valid and you can choose which approach is suitable for you. I always use the bottom-up approach. Here are the steps to create the tables with this approach.

1. SE11 will take you to the DDIC and enter the name of the new table to be created. Let us say Zname. Click create.

2. Enter the short discription of the table and enter the field of the table. If it is primary key and you have to check the box.

3. Enter the data element and double click it, you will be asked to save and will take you to data element discription page. Enter the short discription of the data element and enter the information of domain like the length of field and type of field.

4. If you wanted to use the existing domain then its fine, or else, you have to create one. Enter the domain name in the data element page and double click it. Page will ask to save and jump to domain creation page.

5. In the domain page, you have to save the information which you have already given in the data elements page and check it. Before going to data element page, you have to activate the domain.

6. Go to data element page and save, check and activate.

7. Go to main table page and save, check, and activate.

8. Also, you have to save the technical settings of the table.

The table is now ready for operation. You can use it in your program or you can use it to enter information.

<b>Check table:</b> It is the table which will have all the information about the Foreign keys which are the primary keys in the check table.

It can be created by creating the foreign key from the main table. Click foreign key in the main table and it will take you to a page which will ask for table name and field to which foreign key relation has to be associated. Enter the information and you can create the check table automatically.

SM30 is used for maintenance of the table, that is to realease the errors occured during the creation of the table.

<b>check this thread, it will help you:</b>

<b>reward points for useful ans</b>

Regards

Vivek

[Former Member]

hi

good

use the tcode SE11 to create a table and you can use two process to create a table

1-Bottom up(data element,domain,table)

2-Top Down(table,domain,data element)

i would suggest you to go for the bottom up method.

Thanks

mrutyun^