Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Select-option in interactive report

Former Member

‎2008 May 20 10:14 PM

0 Likes
1,012

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

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

Reply
7 REPLIES 7
Read only

Former Member

‎2008 May 21 5:07 AM

0 Likes
914

hi,

could you be more clear in explaning the scenario.

regards,

siri

Read only

Former Member

‎2008 May 21 5:16 AM

0 Likes
914

hi

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.

Read only

Former Member
In response to Former Member

‎2008 May 21 8:00 AM

0 Likes
914

Thanks for your reply.

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

Read only

Former Member

‎2008 May 21 5:39 AM

0 Likes
914

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

Read only

Former Member

‎2008 May 21 5:51 AM

0 Likes
914

hi

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

Read only

Former Member
In response to Former Member

‎2008 May 21 7:58 AM

0 Likes
914

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.

Read only

prasanth_kasturi
Active Contributor

‎2008 May 21 8:29 AM

0 Likes
914

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