BW Tables By Object Type Introduction

How many times have you seen a business warehouse table, with its typical length and slashes, and you have not been able to identify which object represents?

By Robin

It looks difficult, but it isn't at all.

This is a short summary, for business warehouse starters, and especially for any other consultant that, at any moment, need to know what represents a specific BW table.

It is simpler than expected.

The beginning is common for all the tables, just a little difference between 0 and C.

Once you ignore this, you have just to focus in a letter. Knowing which represents this letter, you are a BW expert!

In the following lines I will show the difference between 0 and C, and possible letters that you will find.

For all BW objects this is the general naming convention: * /BI0/Lxxx* - Standard /BIC/Lxxx - Customer defined where: + L+ - is the letter that will help us to distinguish quickly which kind of object is involved + xxx+ –is the name of the object. But it is important to know that:  If object is a NON standard object then name will be just xxx

Now, let’s see how we can do the differentiation just based in the first letter after the /BI/

DSO* (Datastore Object) Active data /BI/A00

Activation queue 

/BI/A /BI/B

* PSA (Temporary staging area) /BI/B 

+ Note: Technically Change log are PSA are the same

 INFOCUBE
 
F-fact table (partitioned by request_ID) /BI/F /BI/E
D-dimension tables /BI/D* In dimension tables L* is a character that represents each dimension. Possible values for L are: 1.P is the package dimension of a content cube 2.U is the unit dimension of a content cube 3.T is the time dimension of a content cube 4.I is the user defined dimension of a content cube * 

AGGREGATES* (partitioned as the cube!) F-fact table (partitioned by request_ID) /BI/F

E-fact table (partitioned by Year/Month etc.) /BI/E * 

TEMPORARY TABLES* /BI0/0<number> or /BI0/0D or /BI0/0P Please read these notes for further descriptions: 1139396 and 449891 * 

INFOOBJECTS

/BI/P/BI/Q Stores Values of Time Dependent Atrtibutes 

/BI/T/BI/X Stores the SID Values for Time Independent Navigation Attributes 

/BI/Y/BI/S Stores the SID Values for Characteristic Key Values found in the P, Q or T table 

/BI/M/BIC/H”infoobjectname” - Hierarchy data of an infoobject 

SAP BW Tips

Also read
Deleting the Setup Tables

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.