PM Order with object list - equipment number in operation

[BalasubramanianAP]

Dear All,

One of our client had created a PM order without assigning equipment in header (only functional location is mentioned). In operations we specify functional location & equipment number along with work center/hours required etc. They also used object list to add 2 equipments.

My requirement is to find the table which is containing equipment number along with operation number, hours etc.

I searched the tables afvc and AFVC_ILOS etc. but unable to locate equipment number.

Any idea?

[johnstog]

If you just want to report the Equipment on a Work Order Operation you can use IW37N or IW49N.

[BalasubramanianAP]

Hi, thanks for answering...I am preparing spec. logic for an ABAP report...

[BalasubramanianAP]

Hi all, SAP is using a real relational model database system. I found the required data by following tables with joining operations:

1) Pass the PM order number (AUFNR) to AFKO table to get 'Routing no.of operatoin' (AUFPL).

2) Pass AUFL to table OPROL and get the OBKNR,OBZAE - combination (Object list no. & counter).

3) Pass (OBKNR,OBZAE) to table OBJK and get EQUNR (Equipment number).

Please friends, if you also found any db view in a single step, kindly tell me.