Common SAP BW Transactions

Following are most commonly used SAP BW Transactions
1) SBIW: Data Transfer to SAP BW
2) RSA1: Admin Workbench Modelling
3) RSZV: Maintain Variable for BEx Analyser
4) RSSM: BW Authorization
5) RSO2: Maintain Generic Data Sources
6) RSA7: BW Delta Queue Maintenance
7) RSA3: Data Extractor Check
8) RSA5: Installation of Data Sources from Business Content
9) LISTCUBE: To display content of Info Providers
10) RSCUSTA: Set User ID for Source SystemCommunication
11) RSKC: Permitted Characters
12) SNUM: Number ranges for Transfer Structure
13) SM62: Define Event
14) RSMO: Evaluation of Requests

General SAP Transactions:
1) SE11: ABAP Dictionary (Create,Change, DisplayTable, View, Data Elements, etc.)
2) SE16: Data Browser for Table and View
3) SU01: User Maintenance
4) PFCG: Role Maintenance
5) SPRO: Customizing
6) SE80: Object Navigator
7) SE93:To checktransaction codes available
8) STMS:Transport Management
9) SE09: Transport Organiser

Naming Convention in SAP BW

SAP BW has a naming convention related to its objects.

SAP BW prefixes /BIO/ to the names of BusinessContentdatabase objects. It prefixes /BIC/ to the database objects created by users.If a user creates characteristics type info object ZPRODUCT and activates it, information will be stored infollowing:

Data element: /BIC/IOZPRODUCT
SIDtable: /BIC/SZPRODUCT
Master data table: /BIC/PZPRODUCT
Text table: /BIC/TZPRODUCT
View: /BIC/MZPRODUCT
When an info cube ZSALES is created and activated, information will be stored in following:
ViewFact table: /BIC/VZSALESF
Transparent Fact table: /BIC/FZSALES
Dimensiontables: /BIC/DZSALES1 to /BIC/DZSALESN where N being no. of dimensions/BIC/DZSALESP, /BIC/DZSALEST, /BICDZALESU for Data Packet, Unit & Time (maximum 16dimensions possible, 3 reserved for P, T & U)

If a hierarchy is used in an info object ZDATE, following tables will be created:

Hierarchy table: /BI0/HZDATEHierarchy
SID table: /BI0/KZDATESID
hierarchy structure: /BI0/IZDATE
HierInterval table: /BI0/JZDATE