topic Re: Interactive Reports?? in Application Development and Automation Discussions

Interactive Reports??

Former Member — Fri, 01 Dec 2006 05:51:34 GMT

Hi all,

If i click at one field value in BASIC list the cursor has to go to a transaction....

how it is posiible ...

eplain me by writing the code,,,

Regards,

Kishi.

Re: Interactive Reports??

Former Member — Fri, 01 Dec 2006 06:07:35 GMT

USE THE

AT LINE-SELECTION.

GET CURSOR FIELD <VARIABLE TO GET FIELD NAME>

VALUE <VARIABLE>.

IF <VAR> = <YOUR DESIRED VALUE>

CALL TRANSACTION 'XXX'.

ENDIF.

HOPE IT WILL HELP YOU

SHIBA DUTTA

Re: Interactive Reports??

Former Member — Fri, 01 Dec 2006 06:08:23 GMT

* In case that sy-ucomn value
  CASE pi_ucomm.

    WHEN c_code.    "Double click
      IF NOT pi_selfield-value IS INITIAL.

*       If field selected  is 'ORDER'
*       Retrieve the value of field selected in local variable
        IF ( pi_selfield-fieldname = c_sales_order ).
          l_v_order = pi_selfield-value.
          SET PARAMETER ID: 'AUN' FIELD l_v_order.
          CALL TRANSACTION c_trans_va02 AND SKIP FIRST SCREEN .

here based on the field value and sy-ucomm value the transaction va02 will be called ....

Regards

Gunjan

Re: Interactive Reports??

Former Member — Fri, 01 Dec 2006 06:12:53 GMT

at line-selection.

get cursor field FFFF value VVVV.

set parameter id DDD field VVVV.

call transaction 'TTT' and skip first screen.

hope this helps u

thanks

pavan

Re: Interactive Reports??

Former Member — Fri, 01 Dec 2006 06:30:10 GMT

Hi PAVAN,

y did u written Set param ID before call transaction statement..

please clarify this....

can we use leave to transaction instead of call transaction..

regards,

kishore

Re: Interactive Reports??

Former Member — Fri, 01 Dec 2006 06:40:36 GMT

For each field some parameter id will be there ......

u r calling the field in get parameter -

for ex: vendor LIF,

with this parameter reference it is going to call that transaction code......

You can use the SET and GET parameter for HOTSPOT. i.e. if you have provided a hotspot on Report Output and when user clicks on that value, you want to call another transaction with the clicked value as input, then use SET Parameter in the report program. In the called program, use GET parameter to retrieve the value.

It can also be used to pass value from one screen to another in module pool.

AGAIN IAM COMING WITH ONE EX:

example........

data: cac_kokrs like coas-kokrs,

get parameter id 'CAC' field cac_kokrs.WRITE CAC_KOKRS.

parameter ID 'CAC' is checked in SAP MEMORY and if it is there, it is assigned to cac_kokrs.

The parameter id will be unique for a particular field in

SAP MEMORY.

U CAN ALSO USE

SET parameter id 'CAC' field cac_kokrs. ABOVE.

BUT THE DIFFERENCE BETWEEN THE TWO IS AS FOLLOWS:

get parameter id

DATA: para TYPE tpara-paramid VALUE 'RID',

prog TYPE sy-repid.

GET PARAMETER ID para FIELD prog.

IF sy-subrc <> 0.

MESSAGE 'Parameter not found' TYPE 'I'.

ENDIF.

1.in the above syntax para is a variable for which parameter id is assigned.

2. get parameter id returns sy-subrc.

set parametr id

SET PARAMETER ID: 'CAR' FIELD carrier,

'CON' FIELD connection.

1. the parameter id 'CAR' is static , u cant use variables

I THINK THI SWILL FULFILL U R REQUIREMENT.....

Message was edited by:

SITARAMIREDDY

Re: Interactive Reports??

Former Member — Fri, 01 Dec 2006 15:46:03 GMT

Write your code based on below pseudocode:

start-of-selection.

Select field1... into table.

loop at table.

hide <hidevariable>

endloop.

at line-selection.

if hidevariable = <desired value>

write:/ .........

endif.