I am explaining how the BW objects are mapped in a universe.
- To build a universe on SAP NetWeaver BW, We must create a multisource-enabled data foundation based on a secured relational connection to SAP NetWeaver BW in IDT.
- Once you add an SAP NetWeaver BW connection to a data foundation, by default tables and joins are automatically inserted.
- When you create a business layer on the data foundation, by default objects are automatically inserted into the business layer.
The naming convention for the automatically generated data foundation tables are as follows:
- I-Table: A table with a name prefixed by I (InfoCube) that maps to the InfoProvider fact table.
- D-Table: A table with a name prefixed by D (Dimension) that maps to an InfoProvider master data table.
- T-Table: A table with a name prefixed by T (Text) that maps to an InfoProvider text table.
- Data foundation -: To turn off automatic insertion, unselect the Detect table’s option in the advanced properties of the connection when you are adding the connection into the data foundation.
- Business layer -: To turn off automatic insertion of business layer objects, unselect the automatically create classes and objects option when selecting.
- When we include SAP BW as data source, Data Federator displays names of the tables start with prefix that identify the type of object.
- Tables that begin with this letter “I” – This table represents an “InfoCube” or “MultiProvider” in SAP BW. The name of the table is simply the name of the “InfoCube” or “MultiProvider” prefixed by an “I”.
- Example – An infocube ZINFOCUBE – Display as IZINFOCUBE
- Tables that begin with this letter “D” – This table represents a master data “InfoProvider” in SAP BW.
- Example – InfoObject ZIOBJECT – Display as DZIOBJECT
- Tables that begin with this letter “T”- This table represents a characteristic in SAP BW.
- Example – Characteristic ZMATID – Display as TZMATID
Hope this helpful.