topic Re: help in Application Development and Automation Discussions

help

Former Member — Tue, 13 Jul 2010 14:14:51 GMT

Hi,

I need to pull all the records from a table that has a list of tables starting with XY1, On the selection screen I am entering just 'XY1' , and in the select query i tried someting like this..

selection-screen begin of block B1 with frame title text-s01.

parameters p_table like ABC-tabname.

the value I am entering is 'XY1'.

selection-screen end of block B1.

Select tabname from ABCl into v_tabname where tabname+0(3) = p_table.

I am getting an erro here tabname+0(3) is unknown. Any thoughts?

Thanks,

Moderator message: please use much more descriptive subject lines from now on.

Edited by: Thomas Zloch on Jul 13, 2010 4:51 PM

Re: help

Former Member — Tue, 13 Jul 2010 14:18:18 GMT

Select tabname from ABCl into v_tabname where tabname = p_table.

This will work and Please use a descriptive subject line while posting.

Re: help

Former Member — Tue, 13 Jul 2010 14:20:12 GMT

Hi,

Whts the length of the tabname? Thats its showing the error.

With Regards,

Sumodh.P

Re: help

Former Member — Tue, 13 Jul 2010 14:40:28 GMT

Hi,

Thanks, I am trying to pull all the tables that are starting with the names XY1. Hence I gave the length of the p_table as 3.

The bottom line is I am pulling the entire list of these tables based on a particular pattern such as XY1*. The table is DD02L that has the field TABNAMe that lists a series of tables staritng with XY100, XY110, XY170 and so on. How to do this?

Hence I cannot give 'tabname = p_table' because it returns 0. I need to pull the entire list of tables in one shot by entering something like XY1.

Re: help

Former Member — Tue, 13 Jul 2010 14:45:35 GMT

use LIKE

p_table value = 'XY1'

data: lv_tabname  type abc-tabname.

concantenate p_table '%' into lv_tabname.

Select tabname from ABCl into v_tabname where tabname like lv_tabname.

Re: help

kesavadas_thekkillath — Tue, 13 Jul 2010 14:46:39 GMT

basic question.

Re: help

Former Member — Tue, 13 Jul 2010 15:14:33 GMT

Thanks for the help. I got it.