FM SE16N_INTERFACE to Update SAP Database Table

To change the value in the SAP database table, go to Function builder (SE37) and enter the FM name as SE16N_INTERFACE. Press execute (F8).

SAP-UPDATE-DATABASE-TABLE-SE16N-1

Enter the name of the table that you want to edit in I_TAB import parameter. Also set I_EDIT and I_SAPEDIT parameters as ‘X’. Press execute.

SAP-UPDATE-DATABASE-TABLE-SE16N-2

The table will open in edit mode. Make the necessary changes and press save.

SAP-UPDATE-DATABASE-TABLE-SE16N-3

Suppose if you want to filter the number of records displayed. Just go back to previous screen and enter the filter conditions in IT_SELFIELDS table parameter.

SAP-UPDATE-DATABASE-TABLE-SE16N-4

Suppose if you want to display only carrier ID “DL” and Flight date “23.04.2012”, then maintain the below entries in IT_SELFIELDS. The structure of IT_SELFIELDS will be similar to SELECT-OPTIONS.

SAP-UPDATE-DATABASE-TABLE-SE16N-5

Now go back and execute the FM SE16N_INTERFACE again. Now it displays the records that matches the selection criteria maintained in IT_SELFIELDS table parameter.

SAP-UPDATE-DATABASE-TABLE-SE16N-6

Note: Changes made using FM SE16N_INTERFACE can be tracked using SE16N_CD_KEY and SE16N_CD_DATA tables.


1 Comment

Leave a Reply

Your email address will not be published.


*