Interactive reports in SAP query

[Former Member]

I created a SAP query which prints the sales documents numbers..After displaying the ALV list,when I click the sales documet ,it will directly go to the VA03 tcode.

Can any body help how to develop it?

[Former Member]

I created a SAP query which prints the sales documents numbers..After displaying the ALV list,when I click the sales documet ,it will directly go to the VA03 tcode.

Can any body help how to develop it?

[Former Member]

Hi,

at line-selection.

get cursor field w_string.
if w_string cs 'KUNNR'.
READ LINE w_line FIELD VALUE kunnr.
SET PARAMETER ID 'KUN' FIELD kunnr.
call transaction 'VA03'.
endif.

This will work.

thanks

[Former Member]

Hi Durga,

Regards,

Sravanthi

[Former Member]

Hi,

try this .

at user-command.

GET CURSOR FIELD w_cursor VALUE fs_customer-kunnr.(field on which you click)

CASE sy-ucomm.

WHEN 'CUSTINFO'.

IF w_cursor = 'FS_CUSTOMER-KUNNR'.(compare field name )

SET PARAMETER ID 'KUN' FIELD fs_customer-kunnr.( see parameter id in dataelement further characteristics )

CALL TRANSACTION 'TCODE' .

CLEAR w_cursor.

ELSE.

MESSAGE text-005 TYPE 'I'.

ENDIF. " IF W_CURSOR = 'FS_CUSTOMER-KUNNR'