Wednesday, 11 May 2022

How to change database table entries in any environment?

Introduction:

This blog post will help you to change database entry in any environment with ease, but remember this is very powerful technique and may leads to data inconsistency if any wrong key data changed.

Also after this blog post you will be able to update the entries.

“This is very useful technique which can be used to change database tables data in any environment (if you have CHANGE access in Debugger).

The changes which can be taken out through this process cannot be tracked so may leads to inconsistencies. Think twice before using this….”

How to Process with Debug?

Go to SE16N, as usual, and type the table for which you want to make modifications.

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

For demonstrate we have created ZKNA1 table as shown in below snapshot

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

There are 3 entries available in table

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

Go Back & Enter /H in command bar and press “Enter” key to activate debugging.

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

Input data as per highlighted box and press F8

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

Now you will be able to Create / Change the Data

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

i have created new record with Cust No 1040

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

and click on save

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

Now you will be able to find one more entry get added to table

SAP ABAP Development, SAP ABAP Testing and Analysis, SAP ABAP Career, SAP ABAP Skills, SAP ABAP Jobs, SAP ABAP Prep, ABAP Preparation Guides

Source: sap.com

No comments:

Post a Comment