CREATE DB TABLE USING DIRECT METHOD :
1. Execute SE11.
2. Select the radio button database table.
3. Provide the table name ( Eg: ZDB_DIRECT ) and click on create.
4. Provide short description ( Eg: Employee details )
5. Provide delivery class is 'A'.
6. Select Display / maintenance allowed.
7. Click on fields tab.
8. Click on pre-defined type.
9. Provide the field names, data types, lengths and short descriptions.
10. Click on save ( ctrl + S ).
11. Click on local object.
12. Check the table ( ctrl + F2 ).
13. If you get the warning message then click on back.
14. Click on Technical settings.
15. Select the data class 'APPL0'
16. Select the size category '0'.
17. Click on save and click on back.
18. Activate the table ( Ctrl + F3 ).
Steps to provide data to the table:
1. In the menu bar click on Utilities. Select table contents. Select create entries.
2. Provide the data and click on save.
3. Repeat the same steps for other entries.
Steps to Display data in the table:
1. In the menu bar click on Utilities. Select table contents. Click on Display.
2. Execute ( F8 ).
Note: In the real time we never create the database table by using direct method or pre-defined type bcz, if you want to establish the relationship between any two tables then we must maintain the same domain name in both the tables. In the direct method there is no domain concept so, we go for data element type.
1. Execute SE11.
2. Select the radio button database table.
3. Provide the table name ( Eg: ZDB_DIRECT ) and click on create.
4. Provide short description ( Eg: Employee details )
5. Provide delivery class is 'A'.
6. Select Display / maintenance allowed.
7. Click on fields tab.
8. Click on pre-defined type.
9. Provide the field names, data types, lengths and short descriptions.
10. Click on save ( ctrl + S ).
11. Click on local object.
12. Check the table ( ctrl + F2 ).
13. If you get the warning message then click on back.
14. Click on Technical settings.
15. Select the data class 'APPL0'
16. Select the size category '0'.
17. Click on save and click on back.
18. Activate the table ( Ctrl + F3 ).
Steps to provide data to the table:
1. In the menu bar click on Utilities. Select table contents. Select create entries.
2. Provide the data and click on save.
3. Repeat the same steps for other entries.
Steps to Display data in the table:
1. In the menu bar click on Utilities. Select table contents. Click on Display.
2. Execute ( F8 ).
Note: In the real time we never create the database table by using direct method or pre-defined type bcz, if you want to establish the relationship between any two tables then we must maintain the same domain name in both the tables. In the direct method there is no domain concept so, we go for data element type.