cancel
Showing results for 
Search instead for 
Did you mean: 

how to delete a record from PSA?

Former Member
0 Kudos

Hi,

How to delete error record from PSA. I got duplicate records in the PSA. because of this load failed. i checked these 2 records. both contains same data. i want to delete one and process from PSA.

Regards,

Nagesh.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Nagesh,

Have a look at this threads discussed earlier on the same issue.

And also go through this help document on PSA data deletion

http://help.sap.com/saphelp_nw04/helpdata/en/b0/078f3b0e8d4762e10000000a11402f/frameset.htm

Hope it helps.

Cheers,

Aravindhan

Former Member
0 Kudos

hi,

i'm loading master data to info object. request got failed.

I have 2 scenario's 2 get my data

1. Repeat Delta with allow duplicate records with only PSA optiona and upload from PSA.

2. create a program to delete that as mentioned above.

that request got the RED color. i need to delete it. and i need to request the data. can any body tell me how to delete that request. if i go to info object manage screen, i couldn't see my request.

how to delete that request and how to request for REPEAT DELTA.

thanks and regards,

nagesh.

former_member188975
Active Contributor
0 Kudos

Hi Nagesh,

For InfoObjects you will not really have to delete the request. You can simply repeat the delta. Before you do this, do make the changes in your InfoPackage (Ignore double data records).

Hope this helps...

Former Member
0 Kudos

You can delete the request from PSA, but you don't need to delete it as per your providers (there is no 'manage' function)...so, don't worry !

About repeat delta, it's enough to load again and to say yes when the system asks if you want to call a repeat !

Hope it helps!

Bye,

Roberto

Former Member
0 Kudos

Hi,

i'm trying to repeat it again. i could see these messages<b>" Last delta update is not yet completed Therefore, no new delta update is possible. You can start the request again if the last delta request is red or green in the monitor(QM)". </b>

if click enter.. i'm getting action cancelled.

i just rescheduled with new parameters.

Regards,

nagesh.

former_member188975
Active Contributor
0 Kudos

Hi Nagesh,

In your monitor for the error load, click on the Status Tab and then on the circles button next to Total. Say yes to the popup for QM Action for Delta/Repeat Load and then Select Red: Status not OK and Save it.

Hope this helps...

Former Member
0 Kudos

Load again failed.. i'm getting message .. Extractor id not supporting Update mode 'R'. so what i need to do this time.

Regards,

Nagesh.

Message was edited by: Nagesh Ganisetti

Message was edited by: Nagesh Ganisetti

former_member188975
Active Contributor
0 Kudos

The best way is just to run a full load and do a Reinit. As this is just with Master data, these steps would not be a big issue. I have faced this earlier with Master data and this is what I did. You can find a couple of posts in the forums on the same...

Hope this helps...

Former Member
0 Kudos

Hi Bhanu,

can you tell me.. so that i can keep the load.

Nagesh.

former_member188975
Active Contributor
0 Kudos

Nagesh...not clear. Please re-state what you were trying to say.

Former Member
0 Kudos

hi bhanu,

load failed again... i'm getting this error message <b>"

The application program for the extraction of the data was called using

update mode R . However, this is not supported by the InfoSource"</b>. can i get my data?

Nagesh.

former_member188975
Active Contributor
0 Kudos

You got the error with a Full load?

Former Member
0 Kudos

Bhanu,

dcan u tell me about Full and Reinit? wht re init?

i will request full load. and after that do i enable Delta(initialize delta with out data transfer). please correct me is i'm qrong. data will be syncronous? right ?

Nagesh.

former_member188975
Active Contributor
0 Kudos

You are right...delta status will remain intact even if you just do the full load. I suggested ReInit to make a fresh start again.

If you plan on doing the Re Init then remember to first delete the previous Init request from the Scheduler Menu.

Hope this helps...

Former Member
0 Kudos

Hi,

i will delete the previous initialization settings, i will select the full load. i will upload the data and i will request for delta.

thanks a lot.

Nagesh.

Answers (3)

Answers (3)

Former Member
0 Kudos

You can delete the record by program, using the tech name of PSA.

You can find it so:

Goto RSA1 -> PSA -> Right click on the Infosource and select delete PSA data -> A new screen is shown where the technical name of the PSA is displayed. It should be /BIC/*******. Copy that and come out of the screen

*declaration of table

TABLES /BIC/B0000000X.

EX DELETE /BIC/B0000000X

. WHERE FIELD1 = 'sihgdhfg'

. AND FIELD2 = 333333.

former_member188975
Active Contributor
0 Kudos

Hi Nagesh,

You cannot "delete" one record from the PSA. Can you give more details about your situation...there could another way out....you can avoid this by setting Ignore Duplicate Records in the InfoPackage.

0 Kudos

hi Nagesh,

i think you cannot delete individual record from psa.

to prevent duplicate error, you can set in infopackage option 'psa only', subsequent update, 'ignore double record...'

hope this helps.