Sales order wise Production Report

[prasanna_kumar4]

Hi,

Can any one guide me based on my client requirement they want to know that after one month or after 1 week or after 15 days

how many sales orders they received with quantity , how much quantity is completed , how many sales order are not generated planned order and how many sales order quantity is lying under production department

I tried by using the T-Code COOISPI & COOIS but i didnt get what my client wants

please guide me how to get above report

Regards,

Prasanna

[sreenivas_bhamidipati]

Check TCode MC(I. Set doucment /Customer & Material for stastical update.

You may need to configure SIs to meet your clients requirment.

[prasanna_kumar4]

Thanks for reply,

I tried by using T-Code MC(I , i am getting the message like this "No data exists for chosen selection" , "Message no. M5017"

in that screen i selected Sales org and execute that time it showing the above message

Regards,

Prasanna

[sreenivas_bhamidipati]

Try in sand box with a couple of orders. Check the out put fields. The error could be due to settings not completed.

[prasanna_kumar4]

Hi,

Can you please tell me what are the settings i have to do for getting the solution

Regards,

Prasanna

[sreenivas_bhamidipati]

The sales document, customer & Material should be set for statstical update.

Please use the below link.

http://www.scribd.com/doc/23491525/How-to-Work-With-SIS-Structures.

[prasanna_kumar4]

Thanks for reply all to my question

It is solved By using the T-Code CO46 in that i am getting the sales order wise all BOM items and as well as confirmed stock and how much qty is pending

Regards,

Prasanna

[Former Member]

Hi,

You would need to develop a custom report with the help of an ABAPer.

Consider tables VBAK, VBAP for sales orders and AUFK, AFKO and AFPO.

VBUK and VBUP for status and VBFA for sales document flow.

Regards,

Amit

[prasanna_kumar4]

Thanks for reply Mr.Amit,

But is there any way to get the report by using above standard transactions because i think it should be available in standard SAP

Regards,

Prasanna

[Former Member]

Hi,

I dont think there's any std report for your requirement.

However, check this [thread|; for more info.

Regards,

Amit

[prasanna_kumar4]

Thanks for reply Mr.amit,

Before posted this thread i searched in the SDN forum i got the 2 links based on that i tried but i didn't get satisfied because why

i am asking this report is mainly required to my client but this is report also normal for each and every manufacturing industries

that is the reason i think it is available in Standard SAP

and also i tried another T-Codes SAP1, SAP2 but in that also i couldn't able to find out

please guide me how to get my report

Regrads,

Prasanna