cancel
Showing results for 
Search instead for 
Did you mean: 

Table for Confirmation numbers

Former Member
0 Kudos

Hi

Can any one provide the Table exclusive which show the Operation number and Confirmation numbers for a given Order.

Provide Table other than AFRU and AFVC .

AFVC does not have the input field AUFNR (Production Order)

AFRU only prodes the completed Confirmation for order.

Need Exclusive information for list of confirmation numbers and Operation number for given production order with

Thanks and Regards

Chakrapani

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Chakrapani,

Please refer the transaction COOIS.

Here,select "confirmations" under "List".

Enter the production order number in the selection screen.

Execute.

In the standard report we can find

1.Confirmation number

2.Operation

etc

Check and revert.If the report doesnt suffice then we can explore more with tables.

Regards,

Joseph Charles Vaikathussery

Edited by: Joseph Charles on Nov 3, 2010 5:43 PM

Former Member
0 Kudos

Hi Joseph Charles

Yes COOIS provide the information.

But I need to work with Table.

Please provide Table name to view exactly what we get from COOIS.

Thanks and Ragards

Chakrapani

Former Member
0 Kudos

Dear Chakrapani,

Please create a query by joining the two tables AFVC and AFRU.

This willl help us in having both the order and the confirmation number.

Check and revert.

Regards,

Joseph Charles Vaikathussery

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Chakrapani.

Confirmation numbers shall be seen in Table: AFRU for the production / process Orders.

Regards,

Shyam

former_member196530
Active Contributor
0 Kudos

Dear

Please check the following table :

AFVC Order Operations Detail

AFRU Order Completion Confirmations

AFRH Confirmations -- Header Info for Confirmation Pool

AFRV Confirmation Pool

You have beutful reports like COOIS-Sleect Operation -Select Standard Profile -Enter Order Type and Plant -Exectute -It will list down all the operation with confoirmation number .You can also select Order hedares -Standrad Profile and proceedd in the same way , it will list order details.Goto Select Lay out -Change lay out -Select the Display column and DragConfirmation field from hidden column to display in the list and SAVE.

Beside that you can try COHV /CO46 to get the details

Regards

JH

Former Member
0 Kudos

Dear Chakrapani,

In order to get the operation data for a given order, you first need to get the "Routing number of operations in the order" (AUFPL) in table AFKO.

Once you have AUFPL, you can use it as access field for tables AFVC, AFVU, AFVV,... than hold the operation data.

The operation number is AFVC-VORNR.

The table AFRU contains only the confirmations actually processed (through CO11N or another mean).

Each confirmation in AFRU is identified by RUECK + RMZHL.

RUECK has the same value for all the confirmations of a given operation. Its value is pre-allocated when the operation is created; you can get it in AFVC-RUECK (even if no any confirmation has been created yet).

RMZHL is an incremental counter, incremented at each confirmation.

Hope that helps,

Jean-François.

Former Member
0 Kudos

Thanks Jean. I was also looking for the same. The point is table AFVC.