Infocubes and infoobjects...

[Former Member]

Hi,

Currently I am working on SAP AFS module.

I came across various terminologies in AFS module like infocubes and infobjects.

1) Are infocubes same as tables in DDIC ?

2) Do I use the regular select queries to extract data from infobjects, the same way I do on tables ?

3) What transaction do I need to see details of data in infocubes/ infoobjects ?

Any insights will be grealy appreciated...

[Former Member]

Hi,

1. No infocubes are nt same as DDIC tables but one infocube is a combination of DDIC tables in a star schema. You cannot write a select on one/multiple table to get the data from a cube.

2. Info-objects are also known as characteristics and the master data behind them is stored in single table try tcode RSD3.

3. RSA1/RSD3

The above objects are not related to AFS these are BW objects

hope this was helpful

[Former Member]

Tushar,

The terms you are referring to come in the BW context. So, you can look at the help on BW and get the definition of these terms.

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

Regards,

Ravi

[Former Member]

Hi,

1. No infocubes are nt same as DDIC tables but one infocube is a combination of DDIC tables in a star schema. You cannot write a select on one/multiple table to get the data from a cube.

2. Info-objects are also known as characteristics and the master data behind them is stored in single table try tcode RSD3.

3. RSA1/RSD3

The above objects are not related to AFS these are BW objects

hope this was helpful

[Former Member]

Hi,

1. No infocubes are nt same as DDIC tables but one infocube is a combination of DDIC tables in a star schema. You cannot write a select on one/multiple table to get the data from a cube.

2. Info-objects are also known as characteristics and the master data behind them is stored in single table try tcode RSD3.

3. RSA1/RSD3

The above objects are not related to AFS these are BW objects

hope this was helpful

[Former Member]

Thanks Anand,

So what is the difference between views and infocubes. Views are also collection of tables ?

And what do u mean when you say "star schmea" ?

-Tushar