query - infoobject - table

[Former Member]

hello,

I wanted to know if there is any table fro sap bw which keep the whole infoobject initial in query.

for example,

I wanted to have whole infoobject are running the query initially for I can create aggregate from that.

There is many restricted and calculated, and i don't wnat to lose go each one to get the infoobject, that's why I wanted to know if there is any table for that.

Dank

Regards,

[Former Member]

Hi,

You can use Tcode RSRTQ to get these details. All the details including properties are shown in this Tcode.

Goto RSRTQ-->Give your Query and select the required options on the screen and then execute.

Hope this helps,

Aparna Duvvuri

Edited by: Aparna Duvvuri on Nov 21, 2011 4:35 PM

[Former Member]

That was very helful

excellent.

Another question.

I have a query from multicube,

but, when im creating aggregate from last use query from infocube (who is inside) multiube, its doenst give me the last use.

im going explain my problem:

its happening like

Multicube MC_Master (Infocube_X, Infocube_Y, Infocube_Z.... )

infoobject A, B, C ... Z

Infocube_X

infooobject A, B, D, E, Z

Infocube_Y

Infoonject A B D J K L .

I wanted to create the aggregate from infocube_Y which whole fields are initial

another for infocube_X

how can I get that in simple way?

dank