How to fetch data from Table Pool?

[Former Member]

Hi All,

I have to fetch data from table pool KAPOL. Could anybody tell how to fetch data from KAPOL table?.

Thanks in advance.

Regards

Jaker.

[Former Member]

Hello Jaker,

You can use the following code to read table KAPOL. However if you need to read the contents of the table associated with KAPOL then u need to break the VARKEY into exact fields and then read the respective table.

data: begin of i_data occurs 0.

include structure kapol.

data: end of i_data.

field-symbols <fs> type any.

SELECT * into table i_data FROM KAPOL.

[RichHeilman]

Reading data from a pooled table is just like any other tables, except that you can't use a pooled table with a join.

Regards,

Rich Heilman

[Former Member]

Hi Md,

1.

-

---

ABAP Dict >>>>>>>>>>>>>>>>>>>>>>>>>>> Database

-

---

Table1 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Table2 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Table3 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>> TBL

Table4 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Table5 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

2. The above is the concept of pooled table.

3. KAPOL is TBL Above.

4. Why do u want to directly use it ?

5. Instead, u should use Tabel1 - 5

using a normal SELECT query.

(The R/3 will take care

to fetch it from TBL (Kapol)

with apprpriate primary key and conditionis)

regards,

amit m.

[Former Member]

Hi Jaker,

You can retrive the data from table-pools similar to data retrival from other tables. But you can't use pooled tables in joins.

You can use IMPORT key word for data retrival from a cluster.

Ex:

IMPORT obj1 ... objn FROM DATABASE dbtab(ar) ID key.

Lanka