Interactive Reports??

[Former Member]

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.

[Former Member]

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

[Former Member]

* 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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.