How can I modify data from a Transparent Table without ABAP code.

[Former Member]

Hi,All

How can I modify data from a Transparent Table (like TCURR), and important thing is I want do all that with no ABAP code here. It is like that we always do that in a Oracle database use TOAD or PLSQL third party tools, with no script code here.

I had fond that there is a way can do that:

1, type 'se11',and Display Database table 'TCURR', click Contents, then click Execute to display all data

2, type '/h' and let debugging on

3, select one of this data then click 'Display',enter in debugging system.

4, then make a breakpoint in the code. But... display a dialog let I type a 'ABAP Cmnds', I want to know what can be type in for that?

and, My system is ECC6.

thank you all

Edited by: xuehui li on Aug 20, 2008 6:30 PM

[Former Member]

you need to change CODE value.

code value will be SHOW

change to EDIT.

But it is not Advisable to follow this approach. Check any maintenance view for this use that modify the values which you want.

[Former Member]

One more option is:

Goto se16n

Enter table name

Type &sap_edit in the command line

Hit Enter

Hit F8.

PS. Direct update to tables is not advisable and the side effects are unknown

[Former Member]

Hello,

Your approach (with Vijay's suggestion) MAY work. However, depending on how tight security is at the company that you are working at you may or may not be able to acutaly change the value of the SHOW field to EDIT. This will be especially true if you are working in a Production environment. Vijay's other comment is true as well. This is not a recommended approach to change data (especially data with a financial impact like TCURR) in a production environment. The auditors will not be impressed.

Explore the option of a maintenace view or look at tcode TBDM to upload a file which includes daily rates from providers like Reuters or try tcode s_bce_68000174 which is a maintenance view on TCURR.

Regards

Greg Kern

[Former Member]

Thank you all, it is very helpfull.