Production Order Confirmations by Work Center

[Former Member]

Using COOIS, I can see confirmations for production orders by work center, but it doesn't give me the option to display the material number and material number description.

Is there an easy way to create a quick view for this?

Could someone help me out?

[Former Member]

Check the MCPK and MCP1 transactions.

Regards

TAJUDDIN

[siddheshwar_rajguru2]

HI,

Explore CO28 , you will get it

Regards

Siddhesh

[Former Member]

I can manually get this information through COOIS, but my users need a faster way, therefore my need for a sqvi query.

The AFVV table doesn't have work center listed?

[Former Member]

Steve,

The object ID in AFRU (confirmation table) is to be linked with CRHD table to get the work center name. Link AFPO with AUNR to get the material number. All your confirmations can be displayed from AFRU.

I think then your problem is solved.

Regards

Ram

[Former Member]

Steve,

As you would not get material number along with confirmation details, as you said. The easiest thing is to create a simple query using SQVI joing tables AFRU and CAUFV, joining on order number. What you see in confirmations in COOIS is nothing by the AFRU table.

So goahead and get a query created through SQVI.

Regards

Ram

[Former Member]

Hi,

Try with tcode co28 ,choose order header

Enter order category as production orders.

Enter the profile as standard one

Enter order number and execute.

select the displayed order order number and choose the ALL Fields icon.

OR

Try with tcode co28 ,choose order header

Enter order category as production orders.

Enter the profile as standard one

Enter order number and execute.

Choose the Fileds icon and selet the fileds you need and save .

Regards

nandha

[Former Member]

Hi,

(1) List - Order header / Profile - Standard profile: Enter production order no & plant & run COOIS transaction, & create layout which will give you Material number, Material description & Order number.

(2)List - Operations / Profile - Work list per work center: Enter production order no & plant & run COOIS transaction, & create layout which will give you Order number, Work center, Operation quantity, Yield etc.

(3) Download both above list in Excel & join these two list by V-lookup to get one list showing Material number, Material description, Order number, Work center, Opn quantity, yield etc.

Regards,

Ranjeet