Pooled table

[Former Member]

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'.

[Former Member]

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'.

[suresh_datti]

Hi Macy,

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

Regards,

Suresh Datti

[former_member186741]

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.

[Former Member]

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