Finding Equipment Number from the Service order number( vbak-aufnr)

[Former Member]

Hi Friends,

I am able to find the Service order number from the Quotation from VBAK table.

Once I have the Service order i would like to find the Quipment number i.e EQUNR.

from which table I can get the EQUNR based on VBAK-AUFNR?

Regards,

Xavier.P.

[Former Member · Accepted solution]

You can LInk VBAK table to QMIH Table and get your Equipment Number.

As you have AUFNR through this you can get VBAK-QMNUM (Notification Number)

and using this notification you can join QMIH-QMNUM and get QMIH-EQUNR.

regards

Malik

[Former Member · Accepted solution]

Hi,

Once I get the Aufnr from VBAK, can I get the EQUNR FROM ihsg table.this table is containing both AUFNR AND EQUNR.

am I allowed to write the query Like

select single equnr from ihsg where aufnr = gv_aufnr.( already recived the value from VBAK table)

Regards,

Xavier.P,

[Former Member · Accepted solution]

are you working on PM or CS.

regards

Malik