Skip to Content

How to mass change tables T095 & T095B ?

Dear all,

I need to replace about 700 G/L account numbers in the tables T095 and T095B.

Am I bound to use the customizing transactions AO88 and AO90 to do this manually?

Or are there any ideas to realize a more automated way? E.g. how to solve this with an ABAP report (table dependencies etc.)?

Looking forward to your kind help!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 09 at 04:22 PM

    Hi,

    Well, you can directly update the tables via SE16N. But, I wonder how many asset classes accounts determination patterns you have that mass update of accounts is such a problematic task.

    Regards,

    Eli

    Add comment
    10|10000 characters needed characters exceeded

    • These are misleading messages. In SE16N you can receive this type of errors, even if the value for what the system is complaining is perfectly OK and exists in the relevant reference table. This is due to the fact that certain checks, which are applied in direct tables update in SAP, are not performed in the right order.

      For future, you can use function module SE16_INTERFACE with parameter I_CHECKKEY put to 'X'. In this way, you would have the same thing as with SE16N, but no check on the key values will be performed and you won't encounter an issue.

      Another trick is to hide the 'problematic' field in SE16N output. Of course, it will work only if you don't need to modify this particular field.

      If your issue is solved, you can close the thread :)

  • avatar image
    Former Member
    Mar 14 at 04:03 PM

    Hi,

    for mass changing T095 see note 2457480

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22 at 04:24 PM

    Hi D.W.

    LSMW works absolutely fine for configuration as well, just insert a TR and things shall be fine. This way you would be able to move this change to Quality and Production through Transport Request.

    I have used LSMW for various bulk customization.

    Regards

    Shakeel

    Add comment
    10|10000 characters needed characters exceeded