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]

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.