ABAP Query Quantity totals wrongly - M.Type 101+, 102-

[Former Member]

Hi Friends,

Could any one help me in this? I created an ABAP Query for the combination of T.codes MB51 & MB52. When I see the total qty for the item which has GR and Goods return document.........say first by 101 I rerceive 5 nos and using 122 returns 3 nos. Here Query shows total is 8nos instead of 2 nos.

The same way correnponding price also shows for 8nos instead 2 nos.

Kind Regards,

Sankar.K

[Former Member]

Hi Sankar,

You can use MSEG-SHKZG field for +(plus)/-(minus) indicator where 'H' is -(minus) and 'S' is +(plus).

I hope this can answer your problem.

Regards

Gunawan

[Former Member]

Dear Sankar,

I think that its because you dont use the debit/credit indicator (MSEG-SHKZG) to mark the transaction as in/out. Please add the logic to your query.

[rwarri1]

Hi,

Which tables are you using in the query ?

Cheers !