Http://scnblogs.techweb.com.cn/frankyue2001/archives/tag/se16?se16nFrankyue
All logs containing the 'se16, se16n' labels. SAP directly modifies the table.
Sunday, December February 5, 2012
1.1.1 sap table modification Overview
The tables in SAP are classified into configuration tables and business data tables. Normally
If an error occurs in the background table, modify the configuration.
If an error occurs in the front-end table, modify the corresponding document. If the document cannot be modified, use the offset document and recreate the new document.
However, in some cases, we may need to use brute force means to directly modify the table. The most typical case is in an IDES system that is used by countless people and is not managed in a standardized manner, in this IDES system, there are sometimes some errors. For example, in an IDES system that I use, After MRP runs, 541 of the reserved 69014 is generated. when viewing the reserved, the system has an error.
Normally, the transaction code omjj is used to configure the mobile type, but the field reservation cannot be modified. In this case, only the brute force method can be used.
The most important principle for directly modifying a table is to ensure that the modified value is accurate before using brute force means. Otherwise, unpredictable results may occur, first, we need to check the correct value of this field in another SAP server. We can see that the correct value of this field is U.
1.2 table modification method
In SAP, you can directly modify the table by using the following three methods:
In this example, the table field reserved for the move type parameter is T156-rstyp, and the move type is 541.
1.2.1 Method 1: Use se16n to directly modify table records with & sap_edit
Reference Source: Using se16n to directly modify table records with & sap_edit
Se16n: Enter the table name, movement type, and select the corresponding field. Then, enter & sap_edit and press Enter. The prompt is displayed. Click execute (F8)
The system is editable.
Values can be directly modified, and values can be inserted or deleted.
1.2.2 Method 2: The transaction code SE16 enters the debug interface and directly modifies the table field value.
Transaction code SE16, input table t156, move type 541, run, in the command input box, input/h, the system will go to debug, a prompt appears
In line 5 of the debug interface, set the breakpoint and then execute it to the breakpoint. Modify the field code value from show to edit ).
After the code value is modified, continue to execute. You can modify the value of the table field. When the field value is modified later, click Save.
1.2.3 method 3 use the ABAP program to change the table
For example, in this example, you can directly modify the table field value through the following program.
Report zchange_t156_rstyp.
Tables t156.
Update t156 set rstyp = 'U'
Where bits = '000000 ′.
If sy-subrc is initial.
Write/'field T156-RSTYP changed from "to" U "'.
Else.
Write/'field T156-RSTYP cocould not be changed '.
Endif.