How to get WBS(PROID) by using Maintenance Order(AUFNR)

[Former Member]

Hi Experts,

Please advise how can i get WBS(PROID) by using Maintenance Order(AUFNR)?

How can when i retrieve the OBJNR from AUFK or ILOAN from AFIH table, the OBJNR and ILOAN is different when i want to retrieve PROID in IFLO table?

Please advise..

thank you very much

[frwed]

Hello,

Maybe something like this :

select z~posid, z~post1

from afih as y

inner join iloa as x on y~iloan = x~iloan

inner join prps as z on z~pspnr = x~PROID

where y~aufnr = ( 'XXXXXXXX' )

Fred

[peter_atkin]

View table VIAUFKS can be quite useful (joins AUFK, AFKO, AFIH and ILOA)

PeteA

[former_member187991]

hi

I think you can get from AUFK table itself ,you can see the WBS element in the Field PSPEL.kindly check whether the WBS element is matching with that you have entered

regards

thyagarajan

[Former Member]

Dear thyagarajan

Thanks for your help. by referring to my MO in AUFK, the PSPEL value is empty.

i need the WBS which is in my MO's Functional Location.

Currently i am using AFIH-AUFNR, Get AFIH-ILOAN.

Based on AFIH-ILOAN, Go to table ILOA-ILOAN,

Get ILOA-PROID.

but i realized that sometime the WBS is empty by using the logic above.

Please advise

Thanks.

[Former Member]

HI

As far as i know , if you assign any WBS to a Maintenance Order , then only it will appear in the table AUFK for the same Maintenance Order .

Please check if you have assigned the WBS in the additional data field of the MO and then check in AUFK table.You should find both in same table itself.

Further please note that table ILOA contains all the assignments for an equipment or a Functional Location.Hence if you want Order specific assignment, you must put 6 in the Object reference field in the table ILOA to find the WBS also if same is maintained the Technical object and hence has flown in the Order itself

Further if you are getting a Number in the Field PROID in ILOA then you need to check conversion exits by path

Settings-->User Parameters --> check conversion exits radio button

.Hope this helps

Regards

Manish

Edited by: Manish Chachra on Dec 2, 2009 11:15 AM

Edited by: Manish Chachra on Dec 2, 2009 11:27 AM

Edited by: Manish Chachra on Dec 2, 2009 11:35 AM

[peter_atkin]

Take the functional location from the order and get the ILAON from table IFLOT. Then go to ILOA to find the PROID using IFLOT-ILOAN

PeteA

[Former Member]

Is this question answered?

What is the resoltion?

I am facing the same issue.

For some Maintenance Orders i could not find a WBS element using this dataflow...

aufk > afih>iloa

Any chance that the creation of these WOs got some issues?

-jagadish