cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete individual records from PSA

Former Member
0 Kudos

Hi

I have a scenario where there is error record in the PSA.

Can anybody advise how to delete this single record from PSA.

Thanks and regards,

Priya.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

you cannot delete individual records from a PSA-request, you can only delete the whole request. But if the request is not yet updated to any data target, you can edit individual records (just double-click the record in the PSA-display). Then you can either correct the error or reset all values of this record to the initial value so that an 'empty' record remains for the update.

Be careful chosing the initial value: its space for character fields, 0 for numbers and '00000000' for date fields, otherwise the update will cancel.

Former Member
0 Kudos

Hi

After resetting the values in the PSA to all zeroes I

am getting yellow flag now instead of the red earlier.

Will that be ok for me to proceed with further upload or

I have to get the green status for that to proceed further.

Thanks and regards,

Prabhat verma

Former Member
0 Kudos

Don't worry about yellow light...it's just to say that you changed something !

Load with no problem and good luck!

Bye,

Roberto

Former Member
0 Kudos

Thanks for your quick answer.

Its giving me this error.

"InfoObject DOC_NUMBER does not contain alpa-conforming value 0"

I put single 0 for sales document.

Was that ok or should have left it empty.

Please advice.

Thanks and regards,

Priya.

Former Member
0 Kudos

Hi Priya,

As per Stephan's post, you should create a space (make it blank) as it's a character field.

Cheers,

Sree

Former Member
0 Kudos

Thanks a lot for your quick answer.

Actually now I am getting the same error as I was getting earlier before making any changes in the PSA record.

It says "Record 265 :No fiscal year variant specified".

But when I check the the fiscal year maintained earlier

was P1 (now obviously i made it blank to edit this record no) as like any other records ie all the other records have the same fiscal year maintained as P1.

I don't understand why this error is still showing.

Please advise.

Thanks and regards,

Priya Verma.

Former Member
0 Kudos

Priya,

what about my first suggestions ? I think you should be able to avoid all these problems...

Former Member
0 Kudos

Hi Priya,

Can you try saving fiscal year variant with 'P1' instead of blank for the record or alternatively correct only the "erroneous field value" rather than making whole record empty.

Cheers,

Sree

Former Member
0 Kudos

Hi,

You have an option which says simulate update in the transfer(IDocs and TFRC)where you have a red traffic signal

It will give you a selection box to load from PSA you can select say 10 records and in the next screen select all the records displayed and click transfer....if there are any issues you will come to know by a pop up window....you can pls post it in the group for further help

Its better to change the particular record in the PSA

you have an option which says PSA maintain in the transfer(IDocs and TFRC)where you have a red traffic signal

In the next box select all the datapackets and lookout for the red marked record ...double click on that record....you will get a pop up window in that click on the button with a single arrow pointing downwards....so that it corrects the record ...check it and save the PSA and then reload the cube from the PSA....

If you require further help you can post on the group

Former Member
0 Kudos

Hi Sree

Thanks for the answer.

But initially the error record had the fiscal year variant

mainatined as P1 but was still giving the error as fiscal year variant not mainatained.

Actually the issue is :

For the same sales document number, for the same item number, the same error is shown in the PSA's of different data loads from logistics. So do u think that I need to check the data in R/3 or there is some problem during the load into BW because of which I am getting the error for only one record in all data loads involving this record (inspite of the fact that fiscal year variant(P1) is maintained in all the PSA's for this record)

Please advice.

Thanks and regards,

Priya .

Former Member
0 Kudos

Hi Priya,

Looks like you may need to transfer global settings from your R/3 source system for the fiscal year variant.

Goto RSA1>Modeling>Source System->choose your relevant R/3 source system, right click and transfer global settings-> choose the radio button Fiscal year variant and execute to update this info. This should bring the P1 fiscal year variant. And then resume the loads, hope it helps,

Sree

Former Member
0 Kudos

Hi Priya

Sree's reply should help you. Because i also had problem with Unit, and could solve steps mentioned by Sree.

Regards,

Rohini

Former Member
0 Kudos

Hi Sree

Thanks a lot for the answer.

I have done that.

But i want to know if i need to do the upload from R/3

again or it will automatically correct the record.

And just for ny information the other thing if the error is because of global settings then why this error not shown for any other records.

Please advise,

Priya.

Former Member
0 Kudos

Hi Priya,

If you already have this request in PSA, then you should be able to load from PSA. No need to load from R/3.

In terms of clarification, this specific fiscal year variant is required for the record in question, but not for other records (perhaps this P1 fiscal year variant is new and needed to be replicated into BW through global settings transfer and probably fiscal year variant for other records may already be available in your BW system).

Hope it clarifies,

Sree

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Priya,

as already pointed out, std functionality allows to delete request and not single records, but you can reach the same result:

-creating a start routine that delete your undesired record (in transfer rules or in update rules)

-creating a little ABAP pgm that delete your record directly from DB table...As you prefer !!!

Hope it helps!

Bye,

Roberto

Former Member
0 Kudos

Go to PSA and Delete the request number related to the record. But by this your other records related to the request also get deleted.