Wednesday, July 12, 2017

Table Types

Database Tables

Transparent Table
One to One
One table in data dictionary equal to one table in data base.



Cluster Table
Many to One
Many tables in ABAP dictionary equal to one table cluster in database. Basically used to hold application data. One table cluster contains few number of cluster tables having data of around large quantities.

They have different field name at the table and database level ( as they are coming from different tables ?)

  • Cannot be read from other systems
    • BSEG / CDPOS are cluster tables and can not be read from IDT.



Pool Table




Reference Links
https://archive.sap.com/discussions/thread/940285


Internal Tables

Standard Table

Hash Table


Sorted Table

No comments:

Post a Comment