topic Re: How to populate data into QMEL table in Application Development and Automation Discussions

How to populate data into QMEL table

Former Member — Thu, 05 Oct 2006 17:29:23 GMT

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

Re: How to populate data into QMEL table

Former Member — Thu, 05 Oct 2006 17:43:34 GMT

Hi Phani,

Have you tried transaction QM02?

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

Hope this will help.

Regards,

Ferry Lianto

Re: How to populate data into QMEL table

Former Member — Thu, 05 Oct 2006 19:02:43 GMT

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

Thank you,

Phani Varada

Re: How to populate data into QMEL table

Former Member — Thu, 05 Oct 2006 19:10:17 GMT

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

Re: How to populate data into QMEL table

Former Member — Thu, 07 Jun 2007 21:36:02 GMT

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

Re: How to populate data into QMEL table

Former Member — Tue, 03 May 2011 21:37:46 GMT

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