Skip to Content
avatar image
Former Member

BASIS Tablespace Tables & Purpose

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 13, 2008 at 04:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2008 at 06:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhaskar ~

      <removed_by_moderator>

      • Read the "Rules of Engagement"

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

      Thanks,

      Denny Mathews.

  • avatar image
    Former Member
    Oct 14, 2008 at 12:50 AM

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

    Add comment
    10|10000 characters needed characters exceeded