topic Re: Pooled table in Application Development and Automation Discussions

Pooled table

Former Member — Wed, 11 Jan 2006 03:14:33 GMT

Hi all,

I'd like to query the dunning clerk's name in customer master's company code view.

And the pooled table T001S is found.

Could/should I make the SQL statement as usual in my ABAP? i.e.

select sname from T001S

into itab-sname

where bukrs = 3000 and busab = '01'.

Re: Pooled table

suresh_datti — Wed, 11 Jan 2006 03:20:11 GMT

Hi Macy,

Your SELECT statement will work. Ofcourse you need to close it with ENDSELECT..

Regards,

Suresh Datti

Re: Pooled table

former_member186741 — Wed, 11 Jan 2006 04:22:06 GMT

as far as abap is concerned a pooled table is just another table to be selected from. Technically, the data is held in the ATAB pool but it makes no difference to your program.

Re: Pooled table

Former Member — Wed, 11 Jan 2006 04:42:12 GMT

Only disadvantage is that you cannot use it in a JOIN statement.