Question Re: Analyzing PSA data in Technology Q&A

Analyzing PSA data

Former Member — Sun, 28 Aug 2005 19:53:02 GMT

Hai All,

I have two kinds of data for the same key in my PSA. I mean for the same key(combination of company code, sales document etc.), I see two different types of values in the amount field. I want to analyze it. How can I do that? I have been to R/3 tables and checked and found that the value in only one of the documents is matching. Now I am in a dilemma where did the other value for the amount came from...I verified all other fields to make sure its the same document. Its same..They are from same standard extractor and I inquired about any changes in user exit or dat...None of them seems to be...

I would appreciate any kind of ideas to analyze this data.

Thank you.

Re: Analyzing PSA data

Ashwin — Sun, 28 Aug 2005 20:08:24 GMT

Hi!

did you analzed this in RSA3

with regards

ashwin

Re: Analyzing PSA data

Former Member — Sun, 28 Aug 2005 20:18:04 GMT

Hai Ashwin,

Yes. I extracted data in RSA3. The data extracted matches with only of the records I see in PSA. Our R/3 people says there are no changes in the change log of the field atleast. the only difference between the way the two kinds of data were extracted was one through a delta and other through a full load. does this make any difference?

Thank you very much.

Re: Analyzing PSA data

Ashwin — Sun, 28 Aug 2005 20:27:26 GMT

Hi!

I think it must not make any difference when you load with Fullupload and Delta except that some times in delta we get changed values. so just analyse this new amount is a difference between actual and changed value.

with regards

ashwin

Re: Analyzing PSA data

Former Member — Sun, 28 Aug 2005 20:48:13 GMT

Hai Ashwin,

Thats not the difference but the number thats in the puzzling document is logically correct. Are there any ways I can analyze this situation?

Thanks.

Re: Analyzing PSA data

Ashwin — Sun, 28 Aug 2005 21:26:27 GMT

Hi !

what do you mean by logically correct?. and why do you have 2 records for same key. What i assumed is you have performed the loading into BW twice. propably once with fullload and once agian initialization (delta). And hece you can see 2 requests which contains simmilar records twice which reflect changes to the amount field at 2 different times. is it the case or.. am i missing someting.

with regards

ashwin