cancel
Showing results for 
Search instead for 
Did you mean: 

Get BEX Query ID in inverse routine

kohesco
Active Contributor
0 Kudos
219

Hi guys,

I want to use the Query ID of the executed bex query in my inverse routine code.

Does someone know how to retrieve that ID?

Please share.

Thanks for helping

Koen

Accepted Solutions (1)

Accepted Solutions (1)

kohesco
Active Contributor
0 Kudos

Hi,

I solved it by writing the query ID at the end of the variable exit into memory with userID as key.  In the start of my inverse_routine, I'll pick it up per userID.  It's working okay for me.

Grts

Koen

Answers (3)

Answers (3)

RafkeMagic
Active Contributor
0 Kudos

what's your goal?

kohesco
Active Contributor
0 Kudos

in this document

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f05d0b81-076a-2c10-44ab-f00b0b90c...

you have a full explanation how to set the query filter to your database-table.

for example 0fiscyear (inbex-query) to RYEAR in BSEG -ECC Table.

Now, I'll use g/l account - hierarchies as well in my query.  I would like to push the g/l accounts, belonging to the hierarchy, through to my R/3 table.  But in the get_universe / dimension method, see document, they do not fetch the hierarchies as well.  so solution:

  1. is there a method/FM to fetch which hierarchy is used
  2. is there a method/FM to fetch the query name that is executed

One of those two is fine be me, from that point I'll have my solution.

At the moment I use a workaround with info-objects that holds filters referring to the hierarchy, but it's quiet far fetched. 

RafkeMagic
Active Contributor
0 Kudos

check class CL_RSROA_VQ_METADATA

giselle_lin
Employee
Employee
0 Kudos

Is it about virtual provider?

kohesco
Active Contributor
0 Kudos

Indeed!

Former Member
0 Kudos

Hi Koen,

Are you looking for table 'RSUNIURLCOMP' where all the ID's are stored for corresponding bex query.

Thanks,

AV

kohesco
Active Contributor
0 Kudos

Hi,

Please check my last coment : Jul 29, 2015 5:04 PM