In SAP system installed with the DB2 database – the naming and usage type will be different which is based on the runtime environment. The runtime environment (ABAP or JAVA) requires different tablespace as per following,
ABAP Schema
• BASIS Tablespace
SYSCATSPACE - DB2 data dictionary SAPSID#TEMP - Sort, temp tables, reorg SAPSID#USER1 - Default TS SAPSID#EL<rel .> - Dev. Environment Loads SAPSID#ES</rel><rel .> - Dev. Environment Sources SAPSID#LOAD - Screen and Report Loads SAPSID#SOURCE - Screen and Report Sources SAPSID#DDIC - ABAP Dictionray SAPSID#PROT - Log-like tables (e.g. Spool) SAPSID#CLU - Cluster tables SAPSID#POOL - Pool tables (e.g. ATAB) SAPSID#STAB - Master data SAPSID#BTAB - Transaction data
• BI/BW Tablespace
SAPSID#ODS - ODS, PSA tables SAPSID#DIM - Dimension tables SAPSID#FACT - InfoCube and Aggregate fact tables
JAVA Schema
SAPSID#DB - Tablespaces for Java Stack
