Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

When exactly we use reference info object in SAP BI?

Explain with your project requirement

user-image
Question ajoutée par Ritesh C , SAP BI Consultant. , National Grid
Date de publication: 2013/08/01
Fazal Thaha
par 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
par 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
par 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
par 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
par 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
par 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
par 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
par 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.

Utilisateur supprimé
par Utilisateur supprimé

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.