Skip to Content
0

FM to edit a PSA Table

May 05, 2017 at 01:27 PM

101

avatar image

Hi everyone,

I'd like to ask if there are function modules that can edit/modify a specific record in a PSA Table ( /BIC/XXXXXXXXX ) or are there any other ways we can edit them using an ABAP Program?

What I'm trying to do here is to remove Invalid Characters in BW using ABAP Program.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Thangaraj May 05, 2017 at 01:41 PM
1

You can do that - even we have table to keep all PSA technical names per data source/source system combination;

But I would suggest to do that in transformation from PSA -> targets, not to PSA table itself. If you have many targets to single PSA, then you can have write optimized DSO in between and correct all invalid records in routines before sending it to all targets.

Let me know if you are looking for exact code to correct it in routines.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

My solution was not to do any kind of routines in SAP BW rather running an abap program as a background job on the whole system.

Basically, this abap program is an automation of the whole fixing of the invalid characters - from deleting the requests, editing the fail records with invalid characters of the PSA, up to the activation/update scheduling immediately the request.

The program is now able to delete the request in all the targets. The only thing I need now is to actually edit the records of the PSA Table. Are there no any other ways to do this?

And yes, can you give me the exact code? If ever I have no choice but to do routines for now. Thanks!

0