It is sometimes necessary to create a table that can be maintained in a production system. For example, you may have a requirement to map certain old characteristic values to a new value. If the mapping list is not static, it would be better to create a mapping table that can be maintained in production and read this table in a transformation routine instead of changing code and transporting the new mapping every time. Here are the steps to create a table with a maintenance screen:
1. Go to SE11. Type in your table name and click on create.
2. Type in the description and delivery class (this is usually set to A). Select “Display/Maintenance Allowed”.
3. Click on the fields tab and enter in the fields and data elements/types. Don’t forget to mark the relevant key fields.
4. Click on Technical Settings and enter in the relevant logical storage parameters.
5. Click on Save.
6. Then go back to the “Maintain Table” screen and click on activate. The table has now been successfully created. The next task is to create a maintenance screen to capture data into this table.
7. From the “Maintain Table” screen select “Utilities”, “Table Maintenance Generator”.
8. Select and Authorization Group, Function Group and choose “one step” under Maintenance type
9. Click on the “Find Scr. Number(s)” at the top and choose “Propose screen number(s) from the screen shot below.
10. Click on the create icon in the upper left corner.
11. Your table is now ready for data capture. Go to transaction SM30, enter in your table name and click “Maintain”.
12. Click on “New Entries” to capture new data.
13. Click on “Save” when you are done.
No comments:
Post a Comment