topic Re: How to fetch data from Table Pool? in Application Development and Automation Discussions

How to fetch data from Table Pool?

Former Member — Mon, 23 Jan 2006 11:27:50 GMT

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.

Re: How to fetch data from Table Pool?

Former Member — Mon, 23 Jan 2006 12:35:56 GMT

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.

Re: How to fetch data from Table Pool?

RichHeilman — Mon, 23 Jan 2006 12:37:18 GMT

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

Re: How to fetch data from Table Pool?

Former Member — Mon, 23 Jan 2006 12:41:00 GMT

Hi Md,

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.

Re: How to fetch data from Table Pool?

Former Member — Mon, 23 Jan 2006 14:07:04 GMT

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