How to populate data into QMEL table

[Former Member]

Can any one tell me how to populate data into table QMEL?

I am trying to populate QMEL-vbeln data. Is there any t-code for it. I am just trying to populate few fields.

Thanks,

Phani

[Former Member]

Hi Phani,

Have you tried transaction QM02?

Also please check this FM <b>VIQMEL_POST</b>.

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

Hi Ferry, Do you know what field do I need to update to reflect vbeln?

Thank you,

Phani Varada

[Former Member]

Hi Phani,

The field is VIQMEL_NEW-VBELN.

  
CALL FUNCTION 'VIQMEL_POST'
  EXPORTING
    VIQMEL_OLD = VIQMEL_OLD
    INDUPD     = 'U'
    CHG_DOC    = 'X'
    VIQMEL_NEW = VIQMEL_NEW.

Regards,

Ferry Lianto

[Former Member]

This is Correct. It will establish link between Service Notification and Corresponding Service or Repair Orders.

[Former Member]

I was having issues with this function module previosly. Specifically, I was attempting to update 2 fields, VIQMEL-INSPK (Technical Inspection By) and VIQMEL-DATAN (Date of Technical Inspection). Therefore there is a "U" indicator which needs to be passed (see function call below). The call is listed below:

CALL FUNCTION 'VIQMEL_POST'

EXPORTING

INDUPD = 'U'

VIQMEL_NEW = lv_viqmel_new

VIQMEL_OLD = lv_viqmel_old

CHG_DOC = 'X'.

INDUPD Parameter- U is for update

VIQMEL_NEW Parameter - has the old VIQMEL values along with the specific field values which need to be changed

VIQMEL_OLD Parameter - has the old VIQMEL values

CHG_DOC Parameter - indicates that change logs will be updated (assumption); assign "X" value if you want to update change logs

Recommendation --> populate with the following:

• GET THE EXISTING VALUES FOR THE NOTIFICATION

SELECT SINGLE * INTO lv_viqmel_old

FROM VIQMEL

WHERE qmnum = it_notif-QMNUM.

• ASSIGN THE OLD VALUES TO THE NEW VARIABLE

lv_viqmel_new = lv_viqmel_old.

• OVERLAY THE FIELDS YOU WANT TO REPLACE WITH NEW VALUES

lv_viqmel_new-qmnum = it_notif-QMNUM.

lv_viqmel_new-inspk = gv_inspect_by.

lv_viqmel_new-datan = gv_req_end_dat.

• UPDATE THE NOTIFICATION WITH NEW VALUES

CALL FUNCTION 'VIQMEL_POST'

EXPORTING

INDUPD = 'U'

VIQMEL_NEW = lv_viqmel_new

VIQMEL_OLD = lv_viqmel_old

CHG_DOC = 'X'.

• PERMANENTLY ADD THE CHANGES TO THE SYSTEM

COMMIT WORK AND WAIT.

Regards,

Matt Potts