topic Re: About SAP query in Application Development and Automation Discussions

About SAP query

Former Member — Fri, 23 Jan 2009 06:36:28 GMT

Hi,

I have created one query and it is displaying material master data.

Requirement is when I double click on material number field then it should take me to MM02 screen.

Is this possible in query.

Please reply ASAP.

Regards,

Ashutosh

Re: About SAP query

Former Member — Fri, 23 Jan 2009 06:38:42 GMT

No its not possible in SAP Query, you have to change the program generated after SAP Query.

Re: About SAP query

Former Member — Fri, 23 Jan 2009 06:44:03 GMT

Hi Ashutosh,

you can use the functionnalities of AT LINE SELECTION of Intractive report,

1. pass the material number at at line selection function and call the screen that you want to open on material number it will open the screen on the clicking of line.

2. If you want to open screen only on click material number than add one more functionalities with it

use get cursor with hide in hide pass the material number.

check the validation with if query.

like if material number EQ material number

call screen ....

hope it will help you.

Thanks

Arun Kayal.

Re: About SAP query

Former Member — Fri, 23 Jan 2009 07:11:58 GMT

HI,

try this...



START-OF-SELECTION.

  SELECT LIFNR NAME1 ORT01
  FROM LFA1
  INTO CORRESPONDING FIELDS OF TABLE VENDOR_TAB.


AT LINE-SELECTION.

  GET CURSOR FIELD FLDNAME VALUE FLDVALUE.

  CASE FLDNAME.

    WHEN 'VENDOR_TAB-LIFNR' 
                
               CALL TRANSACTION MM03.


ENDCASE.


******************************************************************************************************************

END-OF-SELECTION.

  WRITE : /1 TEXT-001, 13 TEXT-002, 46 TEXT-003.
  ULINE.

  
  LOOP AT VENDOR_TAB.

    WRITE : /1 VENDOR_TAB-LIFNR, 13 VENDOR_TAB-NAME1, 46 VENDOR_TAB-ORT01.

    HIDE : VENDOR_TAB-LIFNR.

  ENDLOOP.

hope this help you..

Regards

Ritesh J

Re: About SAP query

Former Member — Fri, 23 Jan 2009 18:28:59 GMT

Hello,

This is possible in SAP Queries.

In Change Mode(SQ01), on the second screen,GOTO-->Report Assignment. Click the Insert Row Button or F6. Click Other Report Type. Select TR (Transaction). Enter MM02 in the input field. Save. Generate the Query Program and test. When you click a line or material number, it would take you to MM02.

Hope this helps!

Thanks!