# Overview of BW tables per object type

Hello,

How many times have you seen a BW table, with its typical lenght and slashs, and you have not been able to identify which object represents? It looks difficult, but it isn’t at all.

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

It is easier 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.

Hope it is useful for you.

********************

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**/</p><p>** **</p><p>**DSO* (Datastore Object)

Active data |

/BI**/**A**<ODS_name>00</p></td></tr><tr><td><p>Activation queue </p></td><td><p> /BI**/**A** /BI**/**B**<number></p></td></tr></tbody></table><p>** *

**PSA** (Temporary staging area) /BI**/**B**<number> </p><p>+ Note: Technically Change log are PSA are the same </p><p> + </p><p>**INFOCUBE

**</p><table border=”1″ cellpadding=”0″><tbody><tr><td><p>F-fact table (partitioned by request_ID) </p></td><td><p> /BI**/

**F**/BI

**/**E

**<cube_name></p></td></tr><tr><td><p>D-dimension tables</p></td><td><p> /BI**/

**D***

**In dimension tables**L* is a character that represents each dimension. Possible values for L are:

- P is the package dimension of a content cube
- U is the unit dimension of a content cube
- T is the time dimension of a content cube
- I is the user defined dimension of a content cube

* **</p><p>**AGGREGATES* (partitioned as the cube!)

F-fact table (partitioned by request_ID) |

/BI**/**F**<aggr_**number**></p></td></tr><tr><td><p> E-fact table (partitioned by Year/Month etc.)</p></td><td><p> /BI**/**E**<aggr_**number**>

* **</p><p>**TEMPORARY TABLES*

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

* **</p><p>**INFOOBJECTS**</p><p>/BI**/**P**/BI**/**Q**<INFOOBJECTNAME> Stores Values of Time Dependent Atrtibutes </p><p>/BI**/**T**/BI**/**X**<INFOOBECTNAME> Stores the SID Values for Time Independent Navigation Attributes </p><p>/BI**/**Y**/BI**/**S**<INFOOBJECTNAME> Stores the SID Values for Characteristic Key Values found in the P, Q or T table </p><p>/BI**/**M**/BIC/**H**”infoobjectname” – Hierarchy data of an infoobject

Perhaps you would reach out to moshe.naveh@sap.com for some internal guidance around creating this in the correct wiki space.