cancel
Showing results for 
Search instead for 
Did you mean: 

how to get the order type from notification number

Former Member
0 Kudos

Hi,

i have the notification number,

fromthis number how can i get the Maintenance Order type.

what is the table name to get the order type.

Please tell me.

Accepted Solutions (1)

Accepted Solutions (1)

former_member188685
Active Contributor
0 Kudos

from VIQMEL table get AUFNR and pass this to AUFK and get the Order type..

regards

vijay

Former Member
0 Kudos

hi ,

thanks for your reply.

i am getting the order related data from legacy data.

and i have the notification number (from my sap).

now i want to create the order in sap using the legacy data as well as notification numbers provided.

Please tell me how can i get order type.

Answers (2)

Answers (2)

Former Member
0 Kudos

Ramesh,

Step : 1: Use Notofication number in table<b> QMEL</b> to find the <b>AUFNR</b> order number.

Step : 2: Use the AUFNR got in Step 1 in the Table <b>AUFK</b> to find the <b>AUART Order Type</b>

Thanks

Kam

Former Member
0 Kudos

Hi,

First you read table QMEL with notification number and get AUFNR. Then go to AUFK and get AUART (order type).

Some thing like,

SELECT SINGLE aufnr INTO lv_aufnr FROM qmel WHERE qmnum EQ <your notification>.

IF sy-subrc EQ 0 AND NOT lv_aufnr IS INITIAL.

SELECT SINGLE auart INTO lv_auart FROM aufk WHERE aufnr EQ lv_aufnr.

ENDIF.

Hope this helps..

Sri