RSBBS jump query not making a call in R3

[Former Member]

Hi,

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

Could someone through ideas on fixing this.

KSB1 requires Controlling Area, Cost Center, Cost Element, Posting Date and I've all these infoobjects in the BEx query in rows.

Also, I've specified infosource in RSBBS that I used to pull data from R3 to this BEx query data target.

I also specified "assignment details" for the above 4 objects as type 3 = table field

InfoObject	Field Name	Type	Data El		Domain	Set/Get Parameter ID
0COSTCENTER	KOSTL-LOW	*	KOSTL		KOSTL	KOS
0COSTELMNT	KSTAR-LOW	*	KSTAR		KSTAR	KAT
0CO_AREA	SVALD-VALUE	*	KOKRS		CACCD	CAC
0PSTNG_DATE	R_BUDAT-LOW	*	CO_BUDAT	DATUM	 	

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.

Warning Communication error when calling a function in source system.

I don't see any activity in SM50 transaction of source system so I assume it's not even making a call to R3.

Appreciate any ideas.

Hari Immadi

http://immadi.com

SEM BW Analyst

[BGarcia]

Hello Immadi,

When you configure the jump in RSSBS t-code, you have to declare an RFC destination in 'Src. System' field.

Can you check if you have a problem with the RFC configuration to your R3 system?

In t-code SM59, goto 'ABAP connections' and double click on RFC destination that you are using in your jump. Then hit the button 'Remote Logon'. Then, can you tell if appears a logon screen to that system (it should appear...).

Good luck.

Kind regards.

[Former Member]

Hi Bruno,

thanks for your reply.

In SM59, remote logon is not doing anything and also R/3 system logon screen is not coming atall.

user is configured as "Communications" type user in R/3. Is this a problem?

When I asked the same question to my basis team, they mentioned that for this kind of connection in SM59 with this user type, remote logon doesn't work from BW to R3.

Should we change any connection in SM59 or user in R3?

Just to let you know, we have been using this connection since 5 years to pull data from R3 to BW with no problems and same at this moment.

Greatly appreciate further help.

Hari Immadi

http://immadi.com

SEM BW Analyst

[BGarcia]

Hello Immadi,

I'm sorry, but I'm not a basis guy and I don't know the answer the question about the user type. But I can tell you this:

In our system, I see that we have two RFC's configured for each system. One with an user associated (this seems to be your case), and another RFC that access the target system in dialog mode (with a logon window).

We use the first RFC, for example, to extract the data from the target systems, and we use the second RFC, for example, to make jumps to the target systems as well.

But we have a pre-requisite for our jumps: the BW user must have also an R3 user, to get access to the jump information.

If this is also your scenario and if this make sense to you, why don't you try with your basis guy to create an RFC to R3 system that logons in dialog mode and then use it in your jump. Maybe it can resolve your problem.

Kind regards,

Bruno

Edited by: Bruno Garcia on Jun 16, 2008 12:20 AM

[Former Member]

I see that not all SM59 connections are available in RSBBS screen to choose.

I created another connection with dialog user in SM59 but I'm unable to select this new connection for "Source Systems" in RSBBS screen. Here, I can only select those "source systems" that are defined in "source systems" tab of RSA1.

Should I create another source system in RSA1 just for this jump purpose?

Could someone clarify on this.

Hari Immadi

http://immadi.com

SEM BW Analyst

[Former Member]

Hi Bruno,

I did change user to "dialog user" type and in SM59, remote logon is now working.

But jump to transaction from query is still not working to R3, I stil get same error logs in sm21 in BW. Atleast this time, I see that dialog user is logged into R3 from BW when I click on jump.

Do you have any other ideas why it is not taking me to R3 transaction atall even though I see that dialog user is logged in R3. Are my assignments in RSBBS correct? is there a way of verifying if these assignments are correct?

I also checked the flag "logon screen" in SM59 still not successful.

Hari Immadi

http://immadi.com

SEM BW Analyst

[BGarcia]

Hello Immadi,

I don't have access to the our BW system right now. I'll have it later afternoon, and then I'll try to look and try to help you.

Kind regards.

[BGarcia]

Hello Immadi,

I think that even the assignments are incorrect, it should navigate into the transaction (but doesn't not fiil the parameters).

But if you want to try different values, I was consulting a jump that I have in BW into TP01 transaction at R3 system. My assignments are like this:

...

Field Name: PERNR

Selection Type: Single Values

Data Element: PERNR_D

Domain: -

SET/GET PARAMETER: -

If you are suspicious about the assignments, try to declare none, to see if it jump at least into the transaction.

Check also if the user at target system, was authorization to the transaction.

Kind regards.