RSBBS - jump query not making a call in R3

[Former Member]

Hi,

I'm trying to jump from BEx query to R3 transaction ME23 but I'm unable to succeed.

I have specified "assignment details" for the infoobjects as shown below...

InfoObject				Field Name	Type		Data Element	Domain		Set/Get Parameter ID
Transmission Message Processed Date	DATVR		Parameters	NA_DATVR	DATUM	                    
Customer Sector Group			EKORG		Parameters	EKORG		EKORG		EKO
Object key				OBJKY		Parameters	NA_OBJKEY	NA_OBJKEY	

When I click on "Go to" menu, I see status message as "SAP BEx: Jumping to target of type Report drill-through" for like 30 seconds and get following pop-up message and does nothing thereafter.

Could someone suggest on fixing this?

Thanks in advance,

Sandy.

[Former Member]

Hi Gurus, Any help on this pls...

[Former Member]

Hi,

You can try this:

- In the "Type" column set all values to "Table Field"

- In the "SET/GET" Parameter set all values to "SET"

When I say "set all values" I mean the values in those columns ONLY for those fields that will be passed as parameters to the Transaction Code in R/3.

I normally set the rest of the fields to "Delete" in the "TYPE" column. That way I make sure no parameters are passed from those fields. Some R/3 Transactions get "Confused" without that setting.

Hope it helps.

Luis

[Former Member]

Hi Luis,

I did as mentioned by you, but no use. still not able to drill down.

Any idea of code? BADI?

Thanks in advance.

[Former Member]

Hi Sandy,

Try to replace "Parameters" with "TableField" . Then define Data elements and domain name of respective Fieldname.

Now comes the main portion.

Set/Get Parameter ID is used to pass values from query to R3. Here, mention parameter name that you will use on R3 side.

I.E. Set/Get Parameter ID for any field might be P_TEMP in this assignment details.. the same P_TEMP should be declared as

PARAMETERS : P_TEMP type <DataType>

This will pass your data from BW to R3 via this parameter P_TEMP. You have to mentain different parementers for all of the assignments in RSBBS.. If you don't want to pass particular value., choose 'DELETE' Rather then "Parameter" Or "TableField" under TYPE in RSBBS.

Set parameters as mentioned above and use same at R3 side...

I hope this will work.