About SAP query

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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!