topic Re: Possible for Native SQL to read Pooled Tables? in Application Development and Automation Discussions

Possible for Native SQL to read Pooled Tables?

Former Member — Wed, 07 Dec 2011 23:52:11 GMT

Hi Experts,

Is it possible to run native SQL against SAP's internal Pool Table, the table that stores the many "Pooled Tables" across SAP? I realize that is much preferred to access the pooled table using Open SQL via ABAP functions, but that is not an option for me. I am writing native SQL against a copy of the SAP ECC underlying tables.

If it is possible, what is the technical name of the table?

Thanks,

Kevin

Re: Possible for Native SQL to read Pooled Tables?

hendrik_brandes — Thu, 08 Dec 2011 00:10:35 GMT

Hello Kevin,

quite a strange question. As you mentioned it before, the preffered way is to use open sql. The pooled tables are handled by the application server and so, they are not accessible by native sql.

Independently, consider about two things:

1.) The ABAP DDIC uses sometimes different sizes and field-lengths, so you should not read LSTR or LRAW fields with native sql.

2.) You have to be more patient about transaction handling and parameter setting via SQL, because your application server does not get any information about what you have done before.

Kind regards,

Hendrik

Re: Possible for Native SQL to read Pooled Tables?

hendrik_brandes — Thu, 08 Dec 2011 00:22:55 GMT

Hello Kevin,

one more thing: Perhaps it is a possibility to use the ADBC ( ABAP Database Connectivity ) classes: http://help.sap.com/abapdocu_702/de/abenadbc.htm.

With this framework you can execute SQL statemens on any database connected via DBConnect with your application server.

Kind regards,

Hendrik

Re: Possible for Native SQL to read Pooled Tables?

Former Member — Thu, 08 Dec 2011 14:22:53 GMT

Thanks Hendrik for all clarifcations. I will not attempt to access this data using Native SQL.

Regards,

Kevin