Workcenter Wise sales order Load report

[former_member1318494]

Hi expert,

is there any standard report available, which will give work center wise sales order load report.

If i want to develop customizes report then which table will help to get above details.

thanks ,

subhash waydande

[ameya_beri]

Hello Subhash,

Did you try standard COOIS report ?

In the List option on the selection screen use Operations and Layout as standard layout.

Then when you execute, you get the details as below which has production order number, operation, work center along with the sales order and line item. You might have to change the layout to add sales order and item number.

This way you can fetch sales order line item wise, work center report.

It can be extracted to excel and you can do any kind of analysis .

Best Regards,

Ameya Beri

[venkatanaresh_yadav]

Dear,

As far as i know there is no direct report for your requirement.You can use the existing reports like CM01 or CM03 and asked ABAPer to move this output to temp table and pass the Production order number into AFPO table there you can find the sales order.This way you can achieve the sales order wise load.

Thanks,

Naresh.

[former_member1318494]

thanks,

i  will tray this option

regards,

subhash waydande

[former_member1318494]

Re: Workcenter Wise sales order Load report

venkata naresh yadav

Hi ,

I checked sales order in  AFPO table, but sales order release on 30/07/2016 not showing in this table.

regards,

subhash waydande

[sandeep_praharaj]

Hi,

Check VBUK field name CMGST.

Thanks & Regards

Sandeep Kumar Praharaj

[venkatanaresh_yadav]

Dear,

Are you using the MTO (Make to Order) scenario?If so please find the attached doc.This way you can link the Production order and sales order.

Thanks,

Naresh.