Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

When exactly we use reference info object in SAP BI?

Explain with your project requirement

user-image
Question added by Ritesh C , SAP BI Consultant. , National Grid
Date Posted: 2013/08/01
Fazal Thaha
by Fazal Thaha , SAP BI/BW Consultant , Attune Lanka Pvt Ltd

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

Mahmoud Attar
by Mahmoud Attar , Sr. SAP BI Consultant , Alfanar

You do this mainly when you need to use the same info-object in the info-provider more than once; like: sold to, bayer are referring to the customer info-object; sender plant and the reciever one are referring to plant. Best regards Attar

SHAIK AMEER MALIK
by SHAIK AMEER MALIK

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.

Vamsi Kiran
by Vamsi Kiran , Sr.Project Manager , HARMAN(Samsung) International

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.

Ateeque Shaikh
by Ateeque Shaikh , Head of IT , TBG

HI,

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

 

Thanks

Ateeque

Governor mohamed sha Mohamed
by Governor mohamed sha Mohamed , Module lead , Mindtree ltd

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.

RAMESH KUMAR DINDI
by RAMESH KUMAR DINDI , SAP BW HANA Analytics Lead , CGI

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

Ankit Singhal
by Ankit Singhal , Application Development Senior Analyst , Accenture Technology Solutions

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

Deleted user
by Deleted user

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.