Actual invoice Quantity

[Former Member]

Hi all

I have a requirement where I need to consider actual invoice quantity of a customer for particular week; in that week few of the invoices are getting cancelled (S1) and few of the getting return (RE). In this case how I need to consider the exact invoice quantity of a customer, I have to give requirement to ABAPer. Please do the needful

Thanks in advance

Regards,

Nagesh

[Lakshmipathi · Accepted solution]

Ask your ABAPer to check the field RFBSK in table VBRK which should not be "E". This will eliminiate the billing documents that were cancelled.

For returns, check the subsequent document category which should not be "H"

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Hi,

Thanks for the timely reply.

Regards,

Nagesh

[Former Member · Accepted solution]

Hi ,

I need some more clarification, i need exact invoice quantity of a customer for particular material in a week after considering the all documents types, how i need to check the data will be in VBRP.

Please do the needful

Regards,

Nagesh

[Former Member · Accepted solution]

hi,

there is a standard t.codes for that:

MCTE, MC2, MCY - satisfy your query,

if not

catch hold of DOCUMENT CATEGORY

V_TVAK-VBTYP =

'C' - NORMAL SALES ORDER.

'H' - RETRUNS SALES ORDER.

V_TVFK-VBTYP =

'N' - S1

include this in the logic

please check and confirm

balajia

[Former Member]

hi,

there is a standard t.codes for that:

MCTE, MC2, MCY - satisfy your query,

if not

catch hold of DOCUMENT CATEGORY

V_TVAK-VBTYP =

'C' - NORMAL SALES ORDER.

'H' - RETRUNS SALES ORDER.

V_TVFK-VBTYP =

'N' - S1

include this in the logic

please check and confirm

balajia