CREATE DB TABLE BY USING DATA ELEMENT TYPE
( TOP DOWN APPROACH ) :
1. Execute SE11.
2. Select the radio button database table.
3. Provide the table name ( Eg: ZDB_TOP_DOWN ) and click on Create.
4. Provide short description ( Eg: Employee table ).
5. Provide delivery class as "A".
6. Select Display / Maintenance Allowed.
7. Click on Fields tab.
7. Provide the field name and if the field is key field then select the check box of key.
8. Provide the data element ( Eg: ZDE_TD_EMP_ID ) which you want to create.
9. Double click on data element. Click on Yes. Save and Enter. Click on Yes.
10. Provide short description ( Eg: Employee Id ).
11. Provide the Domain name ( Eg: ZDM_TD_EMP_ID ) which you want to create.
12. Double click on Domain name. Click on Yes. Save. Click on Yes.
13. Provide the short description ( Eg: Employee Id ).
14. Provide data type ( Eg: CHAR ) and length ( Eg: 10 ).
15. Save, check and Activate the domain.
16. Click on back.
17. Save, check and Activate the data element.
18. Click on back.
19. Repeat the same steps for all other fields.
20. Save and Check the table.
21. Display the warning message enhancement category for table missing.
22. Click on back.
23. In the menu bar click on Extras. Select Enhancement category.
Select the radio button Can be enhanced ( Character type or numeric ). Click on Copy.
24. Now click on Technical Settings in the application tool bar.
25. Provide the data class as 'APPL0' and size category as '0'.
26. Click on Save. Click on back.
27. Save, Check and Activate the table.
Steps to create Entries in the table:
1. In the menu bar click on Utilities. Select table contents. Select create entries.
2. Provide the data and click on save.
Steps to Display the data in the table:
In the menu bar click on Utilities. Select table contents. Click on Display.
Note : We can't delete the domain which is already attached to any data element.
Note : We can't delete the data element which is already attached to any data base table.
( TOP DOWN APPROACH ) :
1. Execute SE11.
2. Select the radio button database table.
3. Provide the table name ( Eg: ZDB_TOP_DOWN ) and click on Create.
4. Provide short description ( Eg: Employee table ).
5. Provide delivery class as "A".
6. Select Display / Maintenance Allowed.
7. Click on Fields tab.
7. Provide the field name and if the field is key field then select the check box of key.
8. Provide the data element ( Eg: ZDE_TD_EMP_ID ) which you want to create.
9. Double click on data element. Click on Yes. Save and Enter. Click on Yes.
10. Provide short description ( Eg: Employee Id ).
11. Provide the Domain name ( Eg: ZDM_TD_EMP_ID ) which you want to create.
12. Double click on Domain name. Click on Yes. Save. Click on Yes.
13. Provide the short description ( Eg: Employee Id ).
14. Provide data type ( Eg: CHAR ) and length ( Eg: 10 ).
15. Save, check and Activate the domain.
16. Click on back.
17. Save, check and Activate the data element.
18. Click on back.
19. Repeat the same steps for all other fields.
20. Save and Check the table.
21. Display the warning message enhancement category for table missing.
22. Click on back.
23. In the menu bar click on Extras. Select Enhancement category.
Select the radio button Can be enhanced ( Character type or numeric ). Click on Copy.
24. Now click on Technical Settings in the application tool bar.
25. Provide the data class as 'APPL0' and size category as '0'.
27. Save, Check and Activate the table.
Steps to create Entries in the table:
1. In the menu bar click on Utilities. Select table contents. Select create entries.
2. Provide the data and click on save.
Steps to Display the data in the table:
In the menu bar click on Utilities. Select table contents. Click on Display.
Note : We can't delete the domain which is already attached to any data element.
Note : We can't delete the data element which is already attached to any data base table.