topic Re: Regarding Interactive report in Application Development and Automation Discussions

Regarding Interactive report

Former Member — Tue, 27 May 2008 11:54:31 GMT

Hi Experts,

I am creating one Interactive report, my output is 2 fileds only let's say

Col-A and Col-B

I want when i will click on Col-A i SE11 will come and When i click on Col-B SE38 will come.

Is it possible?

Urgent............

Re: Regarding Interactive report

prasanth_kasturi — Tue, 27 May 2008 11:55:44 GMT

hi use

in at line selection event use statement get cursor

data : fnam(10) type c.

at line-selection.

get cursor filed fnam.

if fnam = 'ITAB-COL1'.

call transaction 'SE11'.

else.

call transaction 'SE38'.

endif.

REWARD IF HELPFUL

prasanth

Re: Regarding Interactive report

Former Member — Tue, 27 May 2008 11:56:09 GMT

Yes its possible--->

At line selection.

case sy-ucomm.

when 'PICK'.

call transaction se11 and skip first screen.

hope it helps

Re: Regarding Interactive report

Former Member — Tue, 27 May 2008 11:57:49 GMT

Hi,

Please refer the SAP standard demo program DEMO_LIST_HIDE.

Thanks,

Sriram Ponna.

Re: Regarding Interactive report

Former Member — Tue, 27 May 2008 11:57:53 GMT

Hi ,

at line selection

Get cursomr field fnam value fval .

when f1

call transaction se11 .

when f2 .

call transaction se38 .

Re: Regarding Interactive report

Former Member — Tue, 27 May 2008 11:58:22 GMT

Hi,

U can use HIDE( for the respective fields) and then use AT LINE-SELECTION command.

AT LINE-SELECTION.

call transaction SE11.

Hope it helps u.

Regards,

Ramya

Re: Regarding Interactive report

vinod_vemuru2 — Tue, 27 May 2008 12:00:29 GMT

Hi,

Yes it is possible. Put this piece of code in ur program

AT LINE-SELECTION.

GET CURSOR FIELD w_field VALUE w_value.

CASE w_field.

WHEN wa-f1

SET PARAMETER ID 'DTB' VALUE w_value.

CALL TRANSACTION 'SE11' AND SKIP FIRST SCREEN.

WHEN wa-f2.

SET PARAMETER ID 'RID' VALUE w_value.

CALL TRANSACTION 'SE11' AND SKIP FIRST SCREEN.

ENDCASE.

Here wa-f1 is col-A and wa-f2 is col-b. Check the exact field names in debug mode.

Make sure that w_field and w_value is od sufficient length.

I think for SE38 u can't skip first screen. U have to do BDC for this.

Thanks,

Vinod.

Re: Regarding Interactive report

Former Member — Tue, 27 May 2008 12:03:53 GMT

Hi,

Create two button using set pf-status 'ZABC'.

but1 = 'ZB1. bu2 = 'ZB2'.

then,

at line selection.

case sy-ucomm.

when 'ZB1'.

call transaction 'SE11'.

when 'ZB2'.

call transaction 'SE38'.

endcase.

Re: Regarding Interactive report

Former Member — Tue, 27 May 2008 12:05:08 GMT

Hi,

Try this code

Variable 'fldname' will have the field name that you have clicked and 'fldval' will have its corresponding value.

Set parameter id is used to pass the value to the transaction if required.

AT LINE-SELECTION.

GET CURSOR FIELD fldname VALUE fldval.

CASE fldname.

WHEN 'COL-A'.

SET PARAMETER ID 'MAT' FIELD fldval.

CALL TRANSACTION 'SE11' AND SKIP FIRST SCREEN.

WHEN 'COL-B'.

CALL TRANSACTION 'SE38' AND SKIP FIRST SCREEN.

ENDCASE.

Regards,

Hema.