Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the table types in SAP®?

April 26, 2017Table types

0

Posted

What are the table types in SAP®?

1 Answer

0

Posted

SAP® has three table types. Transparent, Pool, and Cluster. The transparent tables have database fields that are readable by the Oracle® database. Pooled tables are grouped together under one Oracle® table, and their information is stored in a raw Cobol structure format, basically unusable outside of the SAP® tools and framework. Cluster tables are also pooled into one Oracle® table, with the data stored in an encrypted raw format. The pool tables contain lookups, and lists, that are used to classify information in transparent tables. Without access to pool tables, it is hard to use Oracle® database access for anything useful. The cluster tables are used in cases where the data needs to be encrypted – payroll.