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
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.
Check table: 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.