check data in psa?

[#1]

Hi all,

I have a req where in i have to extract 10mill records from r/3. Once i do this how can i check all the data in the psa at once if it possess more than one datapacket.Is there any way to do that.Let me know if the question makes sense or has to be explained more clearly.

Thanks.

[Former Member · Accepted solution]

Hi Pratibha,

You can check data in the PSA by clicking the PSA tree in RSA1 or by clicking the PSA icon in the data load monitor. But why do you need the data to be in just one data package...with 10 million I'm not sure that that would be possible...

[Former Member · Accepted solution]

Bhanu, this is the one of the questions i faced in the interview. Let me know if that is possible.

Thanks.

[Former Member]

How do you propose to check the data (assuming it is possible)? Matching no_of_records, sum_of_kf, ???

[Former Member]

Ajay,

Matching number of records.

Thanks.

[Former Member]

Assuming you know it on R/3, you can go to corresponding PSA table (get the PSA table name from RSTSODS table??) and specify the request no to get the total no of records.

[Former Member]

Hi Prathibha,

I would check the number of entries in the PSA table (not in RSA1) and compare it with those in R/3. Hope this helps.

Thanks and Regards

Subray Hegde

[Former Member]

Ajay,

could u explain me more clearly, how can i get the psa table name from this table rstsods. The short text beside the odsname field reads name of the persistant staging area.

Thanks.

[Former Member]

Specify your datasource name in ODSNAME field, and the corresponding value in field ODSNAME_TECH will be the SAP table for PSA.

[Former Member]

Hi Ajay,

The name of the data source is given in odsname field and field odsname_tech is the psa table name and this should be checked in BW. Is there any other way to check the psa table or this is the only way.

thanks.

[Former Member]

There are many ways to check the PSA table. Check this post:

Hope this helps...

[Former Member]

Thanks Bhanu, it was helpful to me and lastly i would like to clarify from u is this what the interviewer might be expecting.Just curious.

Thanks.