Relation between Maintenance Order No. and Operation Number

[RKSK]

Hi all,

I have to make a module pool in which i want to display the following field

Order No.

Operation no. | Operation Description |

Now my problem is that i m not getting the tables from which i have to select data basically i want to extract the data on the basis of Maintenance Order No. and Operation Number.

I have checked the following tables

AFKO , AFVu , AFVC, CAUFV.

But i m not able to find any relation between Maintenance Order No. and Operation Number.

Please help!!!

Thanks and regards,

Rachit khanna

[Former Member]

Hello Rachit,

The relation is as follows

AFKO-AUFPL (Routing number is Order header)

Use this routing number to get operations from AFVC

AFVC-VORNR gives operation number

AFVC-LTXA1 gives operation description

For sub-operations, VORNR will be sub-operation number, and AFVC-SUMNR for this sub-operation corresponds to the respective superior operation(refers to AFVC-APLZL).

AFVC-APLZL is a unique number for each operation.

Hope this helps. You can check with some existing/new orders as well.

let me know if you need anything about split operations as well.

Best Regards,

Subhakanth