How to enter a record in SAP table using SE16
I want to know what is there a simple way to maintain an entry in a SAP standard table.
Basically it is one of the CRM table. Where there was only one entry was available.
By mistake I went and deleted the 1 record from the table using debugg and CODE = DELE.
Now I realized that I need to maintain back that entry in that table. However I realized that
using debug mode it is not possible. Debugg method is possible only when atleast one
record exist in the table.
Could some one suggest a simple way to maintain the entry. However I want to mention
that I don't have developer access.Which will take another 1 week to get.So pl. don't suggest
to write a program for inserting the record.
I know there is another complex method available using SAP - Query and Infoset(we can write the ABAP
program). Using that we can mange this situation without developer access. However I am not good in that.
So if some know how to do , it will be good.
I really appreciate if any one who can suggest simple and nice solution.
Thanks & Br
Vishnu Tallapragada replied
Right now, I don't have access to a CRM 7.0 box but since SE16 belongs to basis component, its behavior should be uniform whether it is CRM 7.0 or ECC 6.0
I created a test table ZTV_TEST in my ECC 6.0 sandbox with two fields MANDT and VKORG and when I enter this table in SE16, it automatically generated a program with name /1BCDWB/DBZTV_TEST. Inside this program, there is this SELECT statement
SELECT * FROM ZTV_TEST
APPENDING TABLE IZTV_TEST
UP TO RSEUMOD-TBMAXSEL ROWS BYPASSING BUFFER
WHERE VKORG IN I1.
So in your case, there should be a program by name similar to /1BCDWB/DB<your table name>. You can open this program in SE38 put a break point on this SELECT statement and execute SE16 to trigger the debugger and follow my instructions as above.