SAP Basis System and Installation in BW (BW-SYS) Component Details & Tutorials

SAP BW-SYS sub module is an application component stands for Basis System and Installation in BW. It is coming under the BW module (Business Warehouse). Here is a quick overview tutorial about its sub modules, transaction codes and tables for your training purpose.

SAP BW-SYS module

SAP BW-SYS SUB COMPONENTS

Here is the list of sub components coming under the SAP Basis System and Installation in BW application component with the package name they belong to.

  1. ARS0000024 → BW-SYS → Basis System and Installation
  2. J040000001 → BW-SYS-DB → BW Database platforms
  3. J040000005 → BW-SYS-DB-DB2 → BW DB2 for OS/390
  4. J040000006 → BW-SYS-DB-DB4 → BW DB2 for AS/400
  5. J040000007 → BW-SYS-DB-DB6 → BW DB2 Universal Database
  6. BY30000011 → BW-SYS-DB-HDB → BW HDB
  7. J040000003 → BW-SYS-DB-INF → BW Informix
  8. J040000004 → BW-SYS-DB-MSS → BW Microsoft SQL Server
  9. BRA0000052 → BW-SYS-DB-NV → BW Neoview
  10. J040000002 → BW-SYS-DB-ORA → BW Oracle
  11. BR81000001 → BW-SYS-DB-SDB → BW MaxDB
  12. BY30000002 → BW-SYS-DB-SYB → BW on Sybase ASE Database Platform
  13. BRA0000053 → BW-SYS-DB-TD → BW Teradata
  14. BR81000020 → BW-SYS-GUI → BW Frontend GUI

SAP BW-SYS (Basis System and Installation in BW) TABLES

Here is the list of standard SAP tables coming under BW-SYS component.

  1. RSDAREFTABDB2_OR → DB2-z/OS HiPe NLS: Template for reqstate table
  2. RSDAREFTABDB2_OU → DB2-z/OS HiPe NLS: Template for version table
  3. RSDB2A_ACCELPROP → DB2 Accelerator: Accelerator properties
  4. RSDB2A_CONTROL → DB2 Accelerator: conrol center TOC
  5. RSDB2A_CTRLTXT → DB2 Accelerator: language dependent texts
  6. RSDB2A_SETTINGS → DB2 Accelerator: Settings
  7. RSDB2A_STAT → DB2 Accelerator: Load statistics
  8. RSDB2A_STATUS → DB2 Accelerator: current table data status in accelerator
  9. RSDB2A_STA_FCT → DB2 Accelerator: data status of fact tables
  10. RSDB2A_STA_HIE → DB2 Accelerator: hierarchy status table
  11. RSDB2A_STA_STD → DB2 Accelerator: current table data status in accelerator
  12. RSDB2LOCKTABLE → Lock Table for DB2-z/OS Tables
  13. RSDB2NLS_CHKRSLT → DB2-z/OS HiPe NLS: Check results
  14. RSDB2NLS_CONTROL → DB2-z/OS HiPe NLS: Table of Content
  15. RSDB2NLS_QUEUE → DB2-z/OS HiPe NLS: Partitions waiting for archiving
  16. RSDRS_HDB_ENGSEL → maintain for which InfoProvider HDB-JOIN-enigine to use
  17. RSDUADACUBES → InfoCubes read according to system type
  18. RSDUDB6LCKTBL → Table for Serialization of Catalog Access

SAP BW-SYS (Basis System and Installation in BW) TCODES

See the list oftransaction codes used with SAP BW-SYS sub module.

  1. BWMSSPROCS → Transaction for MSS SP Maintenance
  2. RSCNV_MONITOR → DB6 MDC Reclustering
  3. DB2BW → BW Analysis Tool
  4. DB2ACCEL → DB2 Accelerator Control Center