Direct entry to SAP tables through SE16N_INTERFACE or theft of favorites
In the work of the SAP ERP consultant, the SAP often wants to correct a value in the table directly. This desire arises, as a rule, in three cases either from laziness of reversal (deletion) of documents, or from ignorance of the process, or, conversely, from an excellent understanding of the processes, relationships of tables and the possible consequences of such intervention in the database. Although here I forgot to mention one more case - because of stupidity, but I sincerely believe that there are only a few such consultants.
On one project I had a key user who can be set as an example to all users. Excellent understanding of the processes, adequate and rare questions, the ability to train end-users and the presence of well-chosen favorites that answered all the processes of the user. I decided to borrow this list. Of course, the simplest thing is to ask the user to upload them and transfer them as a file, but why should we ask the user when we can take it and not tell anyone about it.
Rolling up the story is not about how I stole favorites, but an example of direct writing to the table.
')
Each consultant has his own levers for finding the name of the desired table. Someone is using F1, someone is googling, and the pros remember them by heart (of course). In this section, I will not describe how to look for the right tables, just let you know what we will write to the table SMEN_BUFFC. It is she who keeps the favorites of the user.
I want to immediately say that this table stores favorites in a completely different format compared to uploaded favorites in a local file. That is, my attempt to simply upload this table to excel and convert to the correct format for upload failed.
We start transaction SE37 “ABAP-functional modules” and execute FM SE16N_INTERFACE.
In FMke itself, you only need to write the name of our table SMEN_BUFFC and put the “X” opposite I_EDIT.
Run our FMku.
At this stage it is better to stop and think again, and give an account of your actions. I will not speak about the consequences of such interference in the tables, and so it is clear that this may cause the collapse of the entire system. But if you know exactly what you are doing, then go ahead, but I warned .
As a result of the work of FMki, we open our table for editing. Here you can add, delete lines or adjust values.
In the end, I just took all the favorites of the user from the SMEN_BUFFC table and inserted them into the same table, but first changing the login to my own.
Do not be afraid, consultant, I did all this not in a productive way, but on a home server. After all, after I received well-structured transactions, I simply unloaded them into a local file and loaded them into the necessary system.
There are other ways to edit tables that may be easier, but in my story I used FMko SE16N_INTERFACE.
As I said at the beginning, everything could be done much faster, and most importantly safer, but it would not be interesting.
On one project I had a key user who can be set as an example to all users. Excellent understanding of the processes, adequate and rare questions, the ability to train end-users and the presence of well-chosen favorites that answered all the processes of the user. I decided to borrow this list. Of course, the simplest thing is to ask the user to upload them and transfer them as a file, but why should we ask the user when we can take it and not tell anyone about it.
Rolling up the story is not about how I stole favorites, but an example of direct writing to the table.
')
Define the table to be edited.
Each consultant has his own levers for finding the name of the desired table. Someone is using F1, someone is googling, and the pros remember them by heart (of course). In this section, I will not describe how to look for the right tables, just let you know what we will write to the table SMEN_BUFFC. It is she who keeps the favorites of the user.
I want to immediately say that this table stores favorites in a completely different format compared to uploaded favorites in a local file. That is, my attempt to simply upload this table to excel and convert to the correct format for upload failed.
Function module
We start transaction SE37 “ABAP-functional modules” and execute FM SE16N_INTERFACE.
In FMke itself, you only need to write the name of our table SMEN_BUFFC and put the “X” opposite I_EDIT.
Run our FMku.
You haven't done anything yet. There is a chance to stop
At this stage it is better to stop and think again, and give an account of your actions. I will not speak about the consequences of such interference in the tables, and so it is clear that this may cause the collapse of the entire system. But if you know exactly what you are doing, then go ahead, but I warned .
Add, remove, change
As a result of the work of FMki, we open our table for editing. Here you can add, delete lines or adjust values.
In the end, I just took all the favorites of the user from the SMEN_BUFFC table and inserted them into the same table, but first changing the login to my own.
Do not be afraid, consultant, I did all this not in a productive way, but on a home server. After all, after I received well-structured transactions, I simply unloaded them into a local file and loaded them into the necessary system.
Epilogue
There are other ways to edit tables that may be easier, but in my story I used FMko SE16N_INTERFACE.
As I said at the beginning, everything could be done much faster, and most importantly safer, but it would not be interesting.
Source: https://habr.com/ru/post/215833/
All Articles