topic Re: table control in Application Development and Automation Discussions

table control

Former Member — Fri, 15 Aug 2008 17:41:55 GMT

i have 2 screens, one a selection screen, and another is a table control created with wizard. If i leave the selection screen blank, i want all of the data displayed in the table control, no problems there. BUT if i select a particular record to be displayed, I want that record AND ONLY that record displayed in my table control, but it shows up blank. Any help here?

Re: table control

Former Member — Fri, 15 Aug 2008 17:45:27 GMT

show your select query. i hope you are using Select-options. if you are using select-options then it should work.

some thing wrong with the data population, may be there is no data or some wrong condition used.

Re: table control

naimesh_patel — Fri, 15 Aug 2008 17:47:08 GMT

Looks like you have some problem in your selection or Filteration.

Ideally it should be like:


START-OF-SELECTION.
* DATA SELECTION FROM DATABASE TABLE 
* BASED ONT HE SELECTION
* INTO TABLE OF TABLE CONTROL.

CALL SCREEN '0200'.  " <<  table control screen

Regards,

Naimesh Patel

Re: table control

Former Member — Fri, 15 Aug 2008 17:52:06 GMT

IF zdplayer_master-zplayer NE space

AND g_tc_stats2_copied IS INITIAL.

SELECT SINGLE * FROM zdstats

INTO CORRESPONDING FIELDS OF itab

WHERE zplayer = zdplayer_master-zplayer

AND zteam = zdplayer_master-zteam.

g_tc_stats2_copied = 'X'.

REFRESH CONTROL 'TC_STATS2' FROM SCREEN '0300'.

not too sure where ive gone wrong

Re: table control

Former Member — Fri, 15 Aug 2008 17:53:11 GMT

the selection screen is custom built screen that i created, can i even use select-options there?

Re: table control

Former Member — Fri, 15 Aug 2008 18:01:58 GMT


> the selection screen is custom built screen that i created, can i even use select-options there?

yes you can use..

i got the mistake

populate the range some thing like this.,.

data: r_palyer type range of zdplayer_master-zplayer,
        w_player like line of r_player.
w_palyer-low = zdplayer_master-zplayer.
w_player-sign = 'I'.
w_player-option = 'EQ'.
append w_player to r_player.
if you use range if the value there then it gets only one record for that value . if not it gets all records.

IF g_tc_stats2_copied IS INITIAL.

SELECT SINGLE * FROM zdstats
INTO CORRESPONDING FIELDS OF itab
WHERE zplayer in r_player
AND zteam = zdplayer_master-zteam.
g_tc_stats2_copied = 'X'.

REFRESH CONTROL 'TC_STATS2' FROM SCREEN '0300'.

select options can be used in the module pool , just check it once, last 30 days once there was a discussion.

Re: table control

Former Member — Fri, 15 Aug 2008 18:07:22 GMT

check this..

https://forums.sdn.sap.com/click.jspa?searchID=15000207&messageID=1501162