cancel
Showing results for 
Search instead for 
Did you mean: 

BASIS Tablespace Tables & Purpose

Former Member
0 Kudos

Hi Gurus ~

Could you tell me where I could find a list of tablespace tables for Netweaver 2004, ECC 6, and 4.7? Also, would you also include the general purpose of each of each of those tables?

Of course,<removed_by_moderator>

Read the "Rules of Engagement"

Thank you,

Denny Mathews.

Edited by: Juan Reyes on Sep 13, 2008 6:21 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi

you can check all the table spaces in transaction db02.here you can check all the table spaces and their fill level.basically what ever entry you make or changes you do will be stored in tables which will in return will stored in table spaces.indexes are meant for direct read or sequential read of contents from database.you can also reorganize the tables or the whole table space in order to regain space of your database or for faster performance of database.

regards

subhash

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks to everyone, especially Bhaskar for helping me out with this issue.

Former Member
0 Kudos

Hi

SAP R/3 installation created 6 tablespaces by default. Here are name of their tablespaces :

  • PSAPTEMP

  • PSAPUNDO

  • PSAP[SID]

  • PSAP[SID]620

  • PSAP[SID]UDR

  • SYSTEM

I am using SAP R/3 Enterprises 4.7 ext 200 version. It may be different if you are using old or new ones

I have some more document to share with you

SYSTEM Includes the internal Oracle dictionary.

PSAPROLL Contains the rollback segments.

PSAPTEMP Temporary tablespace for internal processing.

BASIS tablespaces. These tablespaces contain the R/3 Basis environment data.

PSAPEL<rel>D/I <rel> = R/3 release

Contains loads for the development environment. Are releaseu2212dependent (for

example, PSAPEL45BD for release 4.5B).

PSAPES<rel>D/I Contains the sources for the development environment in this release.

PSAPLOADD/I Contains the ABAP report loads and screens.

PSAPSOURCED/I Contains the ABAP report sources and screens.

PSAPDDICD/I Includes the ABAP dictionary.

PSAPPROTD/I Includes control and log tables. APPLICATION tablespaces.

PSAPCLUD/I Contains the system cluster tables.

PSAPPOOLD/I Contains the system pool tables (i.e., ATAB).

PSAPSTABD/I Contains master data, transparent tables.

PSAPBTABD/I Contains transaction data, transparent tables.

PSAPDOCUD/I Contains documentation tables.

CUSTOMERS tablespaces.

Data Storage: Tablespaces and Data Files 514

PSAPUSER1D/I Includes the customer tables.

Regards

Bhaskar

Former Member
0 Kudos

Hi Bhaskar ~

<removed_by_moderator>

  • Read the "Rules of Engagement"

Nice try to cheat the filter... I'll be whatching.

Thanks,

Denny Mathews.