Performance analysis

[Former Member]

SELECT objnr

FROM onr00

INTO TABLE t_1

WHERE objnr IN t_2.

In t_2 internal table all objnr values contains wild card u2018*u2019.

It is taking lot of database time. ONR00 table has almost 14 lakhs records. If we use internal table also it takes time. But what do you people suggest the solution for it.

[Former Member]

This message was moderated.

[Former Member]

Hello

Declare internal table t_2 as RANGES.

[Former Member]

Declaration part:

TYPES: tp_objnr TYPE RANGE OF j_objnr.

DATA: t_objnr TYPE tp_objnr

[Former Member]

Sorry.

Here is the correct one.

TYPES: tp_objnr TYPE RANGE OF j_objnr.

DATA: t_2 TYPE tp_objnr

Edited by: lalitha botla on Aug 28, 2008 9:12 AM

[Former Member]

Hello

In t_2 internal table all objnr values contains wild card u2018*u2019.

Show sample of value in t_2 ...

[Former Member]

LMREPT0201785001*