Rejected Quantity Report

[Former Member]

Hi Friends,

here client need a report:

my client business process is doesnot have availability check,

for ex: customer orders 1000 quantity and delivered 600 quantity out of 1000 ordered quantity , rest of 400 undelivered quantity , customer needs report for 400 undelivered quantity

for closing the sales order changed the order quantity equilent to delivered quantity(600 delivered quantity) and close the sales order, but here client needs a report of the cancelled quantity (400 quantity)

any body can guide reagrding this report?

Thanks&Regards

Venkat.Dhanemkula

Message was edited by:

Venkat

Message was edited by:

Venkat

[Former Member]

Hi Venkat,

For first scenario u can proceed as follow:

1. Check if Item is with rejected status (Table flow already explained in above

answers)

2. If Rejected, goto VBUP based on VBELN & POSNR & check whether the

billing status is Not Processed / Partially Processed / Completed. In case of

Not processed, U can take full qty as rejected. In case of Partially processed,

Take the Invoiced qty from VBFA with VBTYP_N eq M reducing VBTYP_N eq

N. Reduce this qty from SO qty. In case of completly processed do not

consider the item in the report.

Hope it will help.

Amit

[Former Member]

Hi Amit,

thanks for reply, but here no billing invloved only delivery document,

[Former Member]

Hi Venkat,

I don't think there is a standard SAP report which can offer you this rejected quantity.You need to develope a Z report for this application.

Reward points if useful

Regards,

Amrish Purohit

[Former Member]

HI amrish

can u pls get me the clear tables and fileds to joint, so i can give functional spec and give to abaper, thanks

[Former Member]

Hi Venkat,

Depending on your input fields to run the report E.g. Sales org/ Date range / Sales order number range

This data is to be passed to VBAP table and look for the field ABGRU(Reason for rejection).If this is blank then item is not rejected

So finally the report out put will show the summary as in a particular order Item number 1,2,3 is not rejected and 5,6,7 is rejected.

Discuss this with your ABAPer he will do the rest.

Reward points if useful

Regards,

Amrish Purohit

[Former Member]

HI

YEA YOUR R RIGHT, BUT SYSTEM IS SHOWING ONLY REASON FOR REJECTION NUMBER , NOT REJECTED QUANTITY, EARLIER WE TRIED THIS , DIDNOT WORK

PLS GIVE ME SOME OTHER SOLUTION, THANKS

[Former Member]

Hi Venkat,

We are thinking about two scenarioes

1.First is the case where there is only one line item and having 1000 qty in sales order.Out of which 400 are delivered and 600 are still undelivered.

Now you want to reject the rest 600 and track those.

2.Secondly there are 2 line items out of which one is delivered and other is still undelivered.This undelivered item is rejected and you want to track it.

In second case in VBAP you should get quantity as well as the reason of rejection.

First case I am not sure how it will be handled.I will have to try this.

Can you confirm what was your scenario for which the report you tried didn't work?

Regards,

Amrish Purohit

[Former Member]

Hi Amrish,

1.First is the case where there is only one line item and having 1000 qty in sales order.Out of which 400 are delivered and 600 are still undelivered.

Now you want to reject the rest 600 and track those.

i need report for this requirement, Thanks

With Best Regards

Venkat.Dhanemkula

[Former Member]

Hi Venkat,

I will give you solution for this tomarow for sure.

Regards,

Amrish Purohit

[Former Member]

Hi Amrish,

For first secnario u can proceed as follow:

1. Check if Item is with rejected status (Table flow already explained in above

answers)

2. If Rejected, goto VBUP based on VBELN & POSNR & check whether the

billing status is Not Processed / Partially Processed / Completed. In case of

Not processed, U can take full qty as rejected. In case of Partially processed,

Take the Invoiced qty from VBFA with VBTYP_N eq M reducing VBTYP_N eq

N. Reduce this qty from SO qty. In case of completly processed do not

consider the item in the report.

Hope it will help.

Amit

[Former Member]

Hi amrish,

waiting for your reply

[Former Member]

Hi venkat.

Ask your ABAPers to write a routine for it.

You want this report to be sent to your costomer, or for internal analysis purpose.

Reward points if it helps.

rgds

bidhhubhusan

[Former Member]

hi

i think there is no standard report available

If you want to make the report which you have asked, you have to use the sales orders header& items / Delivery headers& items/ Billing items table for making such report...

vbak, lips,lipk and vbrk vbrp

regards]

[Manoj_Mahajan78]

Venkat,

Check below two LIS reports if you can use it..

MCM -Material Return Analysis & MCQ-Material Analysis-Invoiced Sales..

REWARD POINTS IF U FINDS THIS AS USEFUL....

Regds

MM

[Former Member]

Hi Manoj thanks for your reply

pls go through my requirement once again its not returns report, thanks

With Best Regards

Venkat.Dhanemkula