Need SAP field that shows billed quantities net of returned ones

[Former Member]

Hi friends,

Iu2019m trying to create a query that displays sold quantities by customer and by period.

For that I used the field VBRP-FKIMG (billed quantity).

But Iu2019ve noticed that this field includes the returned quantities.

I would like to know is there any other field with the billed quantities minus the returned ones?

Hope my request is clear.

Regards,

Bahia.

[former_member217082 · Accepted solution]

Hi Bahia

Check the following standard reports , take the feilds by generating those reports

MC+A Customer Returns

MC+M Material Returns

Regards

Srinath

[Former Member · Accepted solution]

Thank you for your answer Srinath.

But I think that my request was not that clear.

What I'm trying to say is: does the billing quantity includes returns quantity in those reports or not ?

[Former Member · Accepted solution]

Or in other words, where can I find the explanation and the calculation rules of the key figures in this kind of reports ?

[former_member217082 · Accepted solution]

Hi Bahia

You cant see the billing quantity feild but you can see the billed quantity feild as you are generating returns quantity. You can see the billed qty because we will be creating a returns order with ref to billing document . So that is the reason we can see the billed quantity feild.

when you generate those standard reports which were given in the previous thread , you can see their feild names

Regards

Srinath

[Former Member · Accepted solution]

I'm sorry....

But I didn't find in those reports any SAP field that fulfills my requirement...

Still need your help my friends!

[Former Member · Accepted solution]

Found what I needed in GLPCA table.

Thank's all.

Regards,

bahia.

[Former Member]

HI

Try in MC+A tcode

MC+M - Returns

MC+Y - Returns

MC-0 - Returns

regards

Edited by: rithvika on Feb 26, 2009 8:52 PM