Skip to Content

Hi All,

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.


Thanks

Sreeni



To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply