Performance Problem with pooltable access

[sinan_keklik]

Hi,

pool tables are normally big Tables. I want to set limits, but it is not possible to use GROUP BY and so on.

Is there anyway to handle pooltables without loading the whole table in an internal table?

Sinan

[Former Member]

the WHERE clause of SQL is not going to help you?

[Former Member]

data: it_vbfa type table of vbfa.

data: Some_Number type vbfa-vbelv.

SELECT * from vbfa into table it_vbfa

WHERE VBELV = Some_NUMBER.

[Former Member]

A016 is a Pooled table.

REPORT ZR_SANDBOX_PROG3.

tables: A016.

data: it_A016 type table of A016.

data: r_A016 type A016.

data: u type i.

select * from a016 into table it_a016

where EVRTP = '000010'.

loop at it_a016 into r_a016.

u = u.

endloop.

In our system, A016 has 270 entries. The internal table above has 179 entries.

Has your issue been resolved with the WHERE clause?

[Former Member]

Hi,

U can use Where clause:

Rembember, to improve performance u should give more and more conditions on KEY fields.

e.g.

Select * from <p_table> into itab WHERE <fldname> = <condition>.

This will fetch only required entries passing <condition>.

Jogdand M B

[sinan_keklik]

I have the problem that I want to get all datasets from A018 with the same key (till ekorg) and in EKORG 0100 and 0200. In a normal Table I make:

SELECT key_1 key_2 COUNT( * ) FROM A018

INTO itab

WHERE ekorg = 0100

OR ekorg = 0200

GROUP BY key_1 key_2

HAVING COUNT( * ) > 1.

Any Ideas for pool tables?

Sinan