Create an sm30 maintenance view [go]

In SAP, you often need to customize database tables. In addition, you may need to manually maintain the data in the database table. You can use sm30 to maintain the data. However, the permissions of sm30 transactions are too large to be assigned directly to sm30. Therefore, you can assign transaction code to the maintenance table to control permissions. The following example shows the general maintenance process; 1First, create a self-built table through SE11. In the 'delimitery' and Maintenance tab, maintain 'date Browser/table view Maint. ', 1; (figure 1) If this option is not set here, 1.1 cannot be created when SE16 is used. When sm30 is used, you cannot perform the corresponding operation, as shown in Figure 1.2. (Figure 1.1) 2After the basic data is maintained, you need to maintain the 'table builder'. The maintenance steps are as follows: (Figure 2) (Figure 3) (Figure 4) (figure 5) after the preceding steps, the 'table maintenance generator' is created. 3And se93 maintain and create the transaction code. Select 'transaction with parameters (parameter transaction) '. On the maintenance page, enter 'sm30' In the 'transaction' field ', select the 'skip start screen' check box, select 'initit GUI bubutes 'in 'classification', and enter the values of two variables in 'default values: update = 'x', viewname = custom database table name. After saving, you can use the generated transaction code to directly maintain the data, as shown in the following figure. (figure 6) (Figure 7) 4Add code to the maintenance object. It is best to unify a function group in a project. If multiple tables need to be maintained, you only need to increment the 'Overview screen' number accordingly, (Figure 8) If You Need to enhance the known table fields during maintenance, such as describe auto-take-out, perform the following steps: 4.1 click 'source' in the upper left corner of the table maintenance generator, and double-click the corresponding function in the 'Program component part' pop-up. The function name is 'sapl + function group ', for example: (figure 9) 4.2 After double-clicking the program name, the system jumps to se38 to enter the program and click 'show listobject ', you can find the corresponding screen number in the 'screen' drop-down on the left. Double-click the screen number to enter the corresponding screen and logic design, as shown in Figure 10 (note: when maintaining the Table Builder, select 'step' as the maintenance type. Otherwise, a request number is generated during data maintenance, such as: (figure 11)