topic Re: Select-option in interactive report in Application Development and Automation Discussions

Select-option in interactive report

Former Member — Tue, 20 May 2008 21:14:48 GMT

Hello , this is urgent requirement.

I have one report in which in the basic report i need to display the table name like mara, mard, marc etc etc 100 table is there.

when i click on the particular table , in the secondary list the key field of the select option should display with select option.

please let me know if you have soultion.

Thanks and regards,

zubera

Re: Select-option in interactive report

Former Member — Wed, 21 May 2008 04:07:58 GMT

hi,

could you be more clear in explaning the scenario.

regards,

siri

Re: Select-option in interactive report

Former Member — Wed, 21 May 2008 04:16:37 GMT

u can do one thing u can call any standard t.code in ur secondary list with value (name of table ) selected by user on basic list .

t.code like SE16 will help u .

reward if helpful.

Re: Select-option in interactive report

Former Member — Wed, 21 May 2008 04:39:36 GMT

Hi,

You caould design a new screen in your program with the select options and call this screen when the basic report is clicked.

Regards,

Shruthi

Re: Select-option in interactive report

Former Member — Wed, 21 May 2008 04:51:20 GMT

we can use table DD02T to display the table list with fields TABNAME and DDLANGUAGE in select option for basic list.

and table DD03L for displaying the fields in that particular table.

rewards points if helpful,

siri

Re: Select-option in interactive report

Former Member — Wed, 21 May 2008 06:58:34 GMT

Thanks for youreply.

yes i am using the table DD20T and TABBNAME. i am dipslayn all the TABNAME in the basic list. if i click the table name in the basic list secondary list should be popo up with the key fieldname of that table with select option.

Re: Select-option in interactive report

Former Member — Wed, 21 May 2008 07:00:11 GMT

Thanks for your reply.

can you give me sample code how you can call SE16 in the secondary list.

Re: Select-option in interactive report

prasanth_kasturi — Wed, 21 May 2008 07:29:35 GMT

hi,

try this code

TABLES : dd02t,databrowse.

DATA : it_dd02t TYPE TABLE OF dd02t WITH HEADER LINE.

PARAMETERS : table LIKE dd02l-tabname default 'M%'.

SELECT *

INTO TABLE

it_dd02t

FROM dd02t

WHERE tabname LIKE table AND ddlanguage = 'E'.

LOOP AT it_dd02t.

WRITE / it_dd02t-tabname HOTSPOT.

HIDE it_dd02t-tabname.

ENDLOOP.

AT LINE-SELECTION.

CASE sy-lsind.

WHEN '01'.

databrowse-tablename = it_dd02t-tabname.

SET PARAMETER ID 'DTB' FIELD databrowse-tablename.

CALL TRANSACTION 'SE16'.

ENDCASE.

reward if helpful.

prasanth