topic Fetching the data from Pooled Table using SQL Statements in Application Development and Automation Discussions

Fetching the data from Pooled Table using SQL Statements

Former Member — Wed, 27 Nov 2013 10:54:32 GMT

Hi,

We have a third party System which is fetching the data from SAP Sql using SQL Query Statements.

We could able to fetch the data for Transparent tables but coming to Pooled and Cluster Tables it is giving erroe as Table does not exits.

What is the procedure to fetch the data form Database level for Pooled and Cluster Tables.

Regards,

NSK

Re: Fetching the data from Pooled Table using SQL Statements

matt — Wed, 27 Nov 2013 12:52:12 GMT

Pooled and cluster tables are not straightforward database tables and generally cannot be read directly from third parties.

In your position, I would write some RFC function modules to retrieve the data from SAP.

The actual code you need within those function modules varies according to the table you're reading. You will need an ABAPer experienced in the appropriate application area to help you.