Please note, this is a STATIC archive of website www.tutorialspoint.com from 11 May 2019, cach3.com does not collect or store any user information, there is no "phishing" involved.
Tutorialspoint

Getting information from pooled tables in SAP system

We are running SAP on Oracle 11 database and E1 on Oracle 11 database to run different units. We are also managing Data Warehousing using SQL Server system. 

Now I want to get information out of SAP like from pooled tables. We are using ETL-SSIS with linked server connected to both Oracle database. Is it possible that I can pull the information from tables from which Pooled tables are getting information?


1 Answer
SAP Expert

Note that you can’t access Pooled tables directly and it should be accessed via Application server. When a pooled table is created, it involves creation of a suitable transparent table with a suitable delivery class and then it is changed to a pooled table.

A pooled table can be flagged as transparent in its technical settings, which is a simple way of transforming it to a transparent table.

To fetch information from Pooled tables, you need to write an ABAP code that can extract the data as per requirement.

Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.