cancel
Showing results for 
Search instead for 
Did you mean: 

Delete old requests/data from PSA and 0CUST_SALES Master Infoobject

Former Member
0 Kudos

HI Gurus,

I appended 0CUST_SALES with a field from KNVP table. I did not delete old data in the PSA before I replicated and activated the new appended datasource. I am doing a full load to the PSA instead of delta.

I deleted all requests in the PSA giving a date criteria before we implemented SAP which means I deleted all visible PSA requests from the Manage option. However when I check the PSA table /BIC/B0000200000 it shows me data from multiple Request numbers. Even the P table of 0CUST_SALES hows 3 times the number of records than the number of records in one full load despite deleting all requests from the Manage option of 0CUST_SALES_ATTR.

I have a Customer Master report with 0CUST_SALES as one of its infoobjects and the report is showing old data that is no longer in the base KNVV table that feeds 0CUST_SALES_ATTR. For example:

Cust# SalesOrg Distr_Chan Division

ABC DE01 10 03 (as in KNVV table)

ABC CH01 40 03 (old data no longer in KNVV table)

Any suggestions on how I can delete old data in PSA and the actual P table of 0CUST_SALES_ATTR? Thank you.

Edited by: Alnick on Dec 2, 2009 4:17 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

First check SID table to see if it is empty. If not, try to delete master data by context menu and check SLG1 for dependent cubes/ODS.

Once you have dependencies fixed, just write ABAP program with delete * statement for PSA and master data table.

BR

Ondrej

Former Member
0 Kudos

Hello Ondrej, Monika and Mr.V

We have a BW 7.0 environment and this issue is in Prod. I do not have access to SE14 in the Prod environment. The SID table also has old data. I was able to dump the transaction data dependencies during quiet time based on SLG1 and was able to delete the complete Master data. However I got stuck because the PSA still has old data that I cannot delete and when I reloaded from PSA it brought in the old data from PSA.

I have used the PSA Manage option to go back all the way to Yearr: 1000 but there is no visible request that I can delete so that is ruled out as some of you suggested.

As Ondrej suggested, the only other alternative is to write a program in Dev and transport to Prod to delete all contents of the PSA table. I was hoping there was an easier way to delete old requests in PSA. Thanks to all. Points have been assigned.

mr_v
Active Contributor
0 Kudos

U can contact Basis Consultant to delete PSA data from SE14 in the Prod environment.. because this is the easiest way.

OR

U can create Process chain in PROD system , to delete PSA data.

OR

Try to run program RSAR_PSA_CLEANUP_DIRECTORY from SE38, by selecting following

Persistent staging Area Radiobutton 'ON'

Repair check box 'ON'

Only Active PSA check box 'ON'

(Check Note 1063105 on this)

OR

execute the program "RSSM_REPAIR_PSADELETE".

select option PSAdelete

Continue with "Repair incorrect PSA References in PSADELTE"

Also,

u can try Function Module : RSATREE_PSA_DELETE_BATCH

Former Member
0 Kudos

All,

I had to systematically delete all the transaction data with this master data object and then cleanup the PSA and the master data. Thanks for your assistance.

Al

Answers (2)

Answers (2)

mr_v
Active Contributor
0 Kudos

From the DS manage option, if u change date (say 12-02-2007) for 'Request Newer Than', u can see older requests (if u r not deleting them manually or by process chain). U can manually delete one by one..

To delete COMPLETE PSA data use tcode SE14. enter /BIC/B0000200000 for 'Obj. Name'

select 'Tables', hit 'Edit'.. then select 'Delete Data', and hit 'Active and Adjust database'...

(be careful... If u want to delete complete PSA data, then only use SE14)

Former Member
0 Kudos

Hi

are you on 3.5 or 7.0 ? To delete master data its corresponding transaction data should also be deleted. Am not sure why you want to delete data from the object 0cust_sales.

If you are one 7.0 , click on datasource --> PSA ---> select all the requests and then delete. It will delete data from PSA.

Do a full infopackage and run DTP.

If your aim is to just load the data , then

3.5

do a init without data transfer to the object . rull full infopackage to the object.

7.0

do a delta without data transfer to the object. run full infopackage and then delta DTP to the object.

Thanks.