topic Re: How to define Range Tables dynamically in Application Development and Automation Discussions

How to define Range Tables dynamically

Former Member — Thu, 10 Feb 2005 10:35:06 GMT

Hi,

How can I define ranges dynamic for further using in the Select Statement?

Cause my Code is like this; But It comes to Short-Dump

lt_typnr is Range Table.

IF typnr IS SUPPLIED.

CONCATENATE 'TYPNR IN' lt_typnr INTO

source_line separated by space.

APPEND source_line TO where_tab.

ENDIF.

SELECT * FROM ZTYP_TABLE

INTO CORRESPONDING FIELDS OF TABLE lt_header

WHERE (where_tab).

Greetings

Besi

Re: How to define Range Tables dynamically

andreas_mann3 — Thu, 10 Feb 2005 10:41:45 GMT

Hi besi,

using sel_opt's is'nt possible in a dynamic wheretab

1) so you've to dissolve your sel_opt

2) or you've to use GENERATE SUBROUTINE POOL (F1)

regards Andreas

Re: How to define Range Tables dynamically

FredericGirod — Thu, 10 Feb 2005 10:47:39 GMT

That's not fit to your question, but have a look at the function module :

FREE_SELECTIONS_INIT

FREE_SELECTIONS_DIALOG

FREE_SELECTIONS_RANGE_2_WHERE

Regards

Frédéric.

Re: How to define Range Tables dynamically

Former Member — Thu, 10 Feb 2005 10:54:45 GMT

Hi Besi,

Could you please see if this one works?

IF typnr IS SUPPLIED.

CONCATENATE 'TYPNR IN'

'LT_TYPNR'

INTO source_line separated by space.

APPEND source_line TO where_tab.

ENDIF.

The value LT_TYPNR has to be supplied as a <i>literal</i>.

Here in your case, you have given it as a variable. Hence the dump.

Please reward the points and close the thread if this solution is satisfactory.

Regards,

Anand Mandalika.

Re: How to define Range Tables dynamically

Former Member — Thu, 10 Feb 2005 14:16:51 GMT

In case Anand's solution does not work, if the range table is empty, it will have no impact on the selection. So you could code:

IF typnr IS SUPPLIED.
ELSE.
  REFRESH lt_typnr[].
ENDIF.

SELECT * FROM ZTYP_TABLE
  INTO CORRESPONDING FIELDS OF TABLE lt_header
  WHERE typnr IN lt_typnr.

Re: How to define Range Tables dynamically

ChristianFi — Fri, 11 Feb 2005 06:13:50 GMT

Also,

in Release 4.6 it is not possible to build a where clause with variables.

field = 'A' would work

while

field = g_var would not.

I am not sure in which Release this feature has been introduced.

Christian

Re: How to define Range Tables dynamically

Former Member — Wed, 16 Feb 2005 15:01:56 GMT

Hi Developers,

I was on Vacation. Sorry for lately Points.

Thank You for all

Bye

Besi