How I may help
LinkedIn Profile Email me!
Call me using Skype client on your machine

Reload this page SAP R/3 Tablespaces

Here is a condensed analysis of (without the sales hype) SAP R/3 Tablespaces.

RSS 2.0 XML feed on SAP valid:
SAP Solution Applications, Modules, Exams
SAP Certification Exams and Training
SAP Installation
SAP R/3 Configuration
SAP Netweaver Architecture Internals
SAP R/3 Tablespaces
SAP Solution Manager
SAP R/3 User and Server Administration
SAP R/3 Monitoring and Performance Tuning
SAP GUI Emulation for Load Testing
SAP R/3 ABAP Programming


Site Map List all pages on this site 
About this site About this site 
Go to first topic Go to Bottom of this page

* SAP's Glossary,
* SAP Developer Network
* SAP on Oracle

Set screen R/3 Tablespaces

    SAP requires tablespace names to have a leading "PSAP" and ending "D" or "I" (for index).

    Type Tablespace Contains Tables Size Activity
    Transaction Tablespaces PSAPBTABD Holds SAP Transaction tables holding order headers, line items, purchase orders, etc. Large Highest
    PSAPSTABD Master data and transparent tables with high write activity such as item master, customer data, pricing, etc. Largest Highest
    PSAPUSER1D Defined to hold user customization (customer tables) not defined with the SAP software. Depends Depends
    PSAPVB0101D & PSAPVB0102D - Large Very high
    BASIS Tablespaces PSAPDICTD ABAP data dictionary (usually cached in memory due to frequent reference). Small Low
    PSAPLOADD ABAP report loads and screens. - High
    PSAPSOURCEID ABAP report source code and screens. - Medium
    PSAPPROTD A heavy-use tablespace. Spool, customer, log files, reports and printouts generated by any SAP process. - Highest
    System Tablespaces PSAPPOOLD System pool tables that SAP considers too small to be in their own tables. These are generally buffered in memory, so they're accessed at SAP startup time but not heavily after that. Small Low
    PSAPCLUD Cluster tables used by SAP as subtables containing LONG RAW datatypes, which must be reorganized using Oracle's slower Export/Import utilities instead of Oracle's faster CREATE TABLE AS SELECT command. Large Medium
    PSAPDOCUD Contains codument tables, including SAPscript and SAPfind tables. Small Low
    PSAPVB0201D & PSAPVB0202D - - -

    The "Size" and "Activity" columns estimate the tablespaces where Oracle/SAP administrators typically need to run scripts (or use the display from the SAPGUI STUN/ST04 transaction ) to identify the largest and most active tables so that they don't fill and cause the entire SAP application to stop.

    See their contents using tx SE11 and SE16.

    The MiniSAP used by ABAP developers for testing and training has many empty tables after installation.

Go to Top of this page.
Next topic this page

Portions ©Copyright 1996-2010 Wilson Mar. All rights reserved. | Privacy Policy | | HTMLHELP | CSS | Cynthia 508 |

Related Topics:
another page on this site LoadRunner 
another page on this site SNMP 
another page on this site Rational Robot 
another page on this site Free Training! 
another page on this site Tech Support 

How I may help

Send a message with your email client program

Your rating of this page:
Low High

Your first name:

Your family name:

Your location (city, country):

Your Email address: 

  Top of Page Go to top of page

Thank you!