Skip to Content
avatar image
Former Member

Delete One Row from PSA

Hi -

I am loading master data (not an ODS or a cube). One row in one of the data packages in the PSA contains bad data. I don't want to edit it; I want to delete it and then rerun that package. When I select the row in the PSA, it will allow me to edit it, but I want to delete it. The "Delete" option is grayed out. How can I get rid of this row so I can load the rest of the rows in the package?

Thank you!

Jo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 16, 2007 at 09:32 PM

    To my knowledge PSA can only act as a cleaning area where you can perform edits to the records. But I dont think you can delete individual records from PSA (frustrating isnt it ?).

    But attempting the following is worth a try. Not sure if it works...

    Go to SE16 -> RSTSODS -> datasource tech name and Objvers = A

    Get the PSA table name for this record which starts with /BIC/B00. Now to go to SE16 -> PSA table tech name (/BIC/B00) obtained from above table and execute. Identify the record you want to delete, select and choose delete from the menu RECORD ENTRY.

    It may work if you have authorization to do so....

    Good luck!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      After I posted, I went and looked and found that option myself. I just reran a portion of the extract, and it put the bad record in a PSA of its own and processed the rest. Excellent!

      Thank you so much for your quick response. It's also good to know about the PSA table, even though I can't update it. It's a good place to be able to look at all the records in the PSA without having to go packet-by-packet.

      Thanks again!