In the production system, end-users will not be having access to transaction codes like SE11 and SE16. Developers will not be having access to many transaction codes including the above two. To view the contents of the database table, we will use SE16n in Production system. Please find out the difference between SE16 and SE16n. All these authorizations will be maintained by BASIS team, by creating access profiles.
So in order to edit or create the contents of a database table, we should go for Table Maintenance Generator(TMG). In real time, authorizations will be maintained in production system. (even in development and Test systems to some extent). There is an audit like Sarbanes-Oxley Act for American clients, where everything will be audited by Government agency.
The second reason is, we can edit or create multiple entries at a time, using table maintenance generator. Apart from that we have options like 'Enter conditions' in table maintenance screen SM30. Please try to find out the use of those, by creating an example.
Table Maintenance generator: Difference between one step and two steps while creating table maintenance generator, we find below options:
1) When we choose one step, we have to give the screen number in Overview Screen field.
2) When we choose two step, we have to give both overview screen number and single screen number.
You can give any number for screen. Don’t give 1000 screen number. As this number is reserved for selection screen.
When we choose two step, two screens will be created for table maintenance. For single step only one screen will be created.
When we choose two-step, table maintenance will work as follows:
Go to SM30, give the table name for which you have created table maintenance-
Overview screen will be displayed. To create entries, when you click on ‘new entries’. Another screen will be displayed, where you give input and save. You can enter one record at a time.
When we choose single step, table maintenance will work as follows:
Go to SM30; give table name for which you have created table maintenance-
Overview screen will be displayed; To create entries click on ‘new entries’, you can enter the records on the same screen. You can enter multiple records at a time.
Note: We use single step generally, as it is user-friendly.
To completely understand the difference and above points please do exercise by creating table maintenance generator in both ways (using single step and two step).