When exactly we use reference info object in SAP BI?

Hi

When you create a reference InfoObject you get the data as well as the structure from the Parent InfoObject.  For e.g. If you create a Z sales rep InfoObject based on0Customer then you don’t have to separately load master data for ZSALEREP. When you load data to0Customer you will get data to ZSALESREP.

But this option really depends on your ECC configuration.

Hope this clarifies your question

Best Regards

Fazal

Reference Info object is used to technically link individual Info objects......

The data is available as well in Reference Info object whenever data load occurs in Referred Info object (Parent infoobject).

For Example Infoobject XYZ is reference infobject of infoobject ABC then you can't make any direct modification to properties of XYZ, you have to modify Infoobject ABC for that purpose.

Infoobject is nothing but field/column in a database. If you want to store data into database you need fields, those fields we call InfoObject in BW Language.

HI,

When you want to use the Data and Structure for some other info object. we do Reference.

Thanks

Ateeque

The reference info objects used for, If we want to create a new infoobject which needs to use the existing master data includes its SID table. For this there is no new SID table will create and same structure and the data can be used in the new object.

Hi All,

To answer simple terms.

SAP BI has a special feature of Extended star schema where the master data can be shared across the system in order to reduce the redundency.

So, suppose that we have created an Info object of type 0customer where we load 100 + attributes with millions of records in it and now we have 0sold_to which stores and needs the same information.

Now in our scenario this makes sence to use the master data which is already there in our system. In order to achieve this we create an Info object 0SOLD_TO with reference to 0CUSTOMER so that 0SOLD_TO can use the existing master data and serve our purpose both as a seperate field by itself and sharing the master data 

Hope it helps

When we want to inherit the characteristics of a standard infoobject in our custom/generic infoobject then we use reference infoobject.

If we want to copy only the structure and properties to that IO we have to use Template.

If we use Reference IO , it derives the value or data of the IO. 

Ex.0Currency.