How is functional location linked with work order tables

[jennychen1]

Hi, Experts:

I am working on a BW project to extract Plant Maintenance data from R/3 to BW system. We need to get work order data with related Functional Location data togather. When check the 2 tables AFIH for Work Order header and AUKF for Order master data, I don't see Functional Location field in neither of the 2 tables.

Can anyone please tell me how (by which table/field) Functional Location data in table IFLOT is linked to a Work Order stored in tables AFIH and AUKF?

Many Thanks,

Jenny

[former_member187991 · Accepted solution]

hi

you cannot able to get directly,pass the order number in AFIH,get the ILOAN. Then pass the value in ITOB to get the FL

regards

thyagarajan

[jennychen1 · Accepted solution]

Hi, Thyagarajan:

Thanks for the reply! I tried to get the values of ILOAN from table AFIH. And pass the value to the field ILOAN in ITOB. However, no data returned from ITOB. The ILOAN in AFIH has different set of values from the ILOAN in ITOB.

Any suggestions?

Thanks,

Jenny

[former_member187991 · Accepted solution]

Hi

I mistyped the table ,kindly pass the ILOAN value in ILOA to get the FL

regards

thyagarajan

[jennychen1 · Accepted solution]

I got it from table ILOA now.

Thanks for the help! Points assigned.

Jenny