Problem with transfer of variables from BW web report to SEM BPS web layout

[Former Member]

Hi all,

On www.service.sap.com I've found a whitepaper on how to transfer a variable from the BW web API to the SEM BPS web API. The paper is called "How to Call a BPS Web Interface with Predefined Selections".

I've followed the instructions to the point; the correct variable value is transferred to the URL using RRI; however, SEM BPS prompts an error message.

Any of you that have any experience with how to get SEM BPS to accept the value transfered by the URL? Has it anything to do with internal/external formats?

Thanks in advance for any assistance!

[gerd_schoeffl · Accepted solution]

Hi,

Can you tell me what the error message says? Maybe it is because of some other problem...

You have to be a little carefull as the API that is used in the coding of the How...to paper uses the characteristic value in EXTERNAL format. If you only have the internal format available you either have to convert to external format (using the fucntion module UPC_CHAVL_IN_EX_CONVERT) or use some internal methods to set a variable value.

Best regards,

Gerd Schoeffl

BI RIG, SAP

[Former Member · Accepted solution]

Hi Gerd,

Thank you very much for your answer. I've have checked that the variable value actually is transfered to BPS, and this seems to be the case as the chosen value (CO-order, e.g. FAGLIGVIDEN) is displayed as "chosen" if I subsequently enters the variable setup in BPS. So, it seems that the transfer fails when trying to lookup the variable value. I have posted an OSS note and attached all relevant screendumps; unfortunately, I haven't come any further. Would you have the incovenience of having a look at the URL and the screendumps, please?

Thanks in advance.

Regards,

Morten

[gerd_schoeffl · Accepted solution]

Hi Morten,

Just to get it right - if you call the url you transmit the variable in the internal format and then convert it to external format in the BSP page (or - which works as well - convert it before putting it into the url). Then when the url is called you get the message "serious error". Still if you enter zhe bps0 afterward the variable value is set to the right value. Is that correct?

I just had a look at the coding again. What you should try is to find out whether the coding from tha How to paper works fine in your case. The best way to do thie is to set a break point in the BSP application and debug the coding. Have a look at the return parameters of the API calls to see whether everything is alright. If there is no error in this page you will have to have a look at the Web Interface geb´nerated by the web interface builder itself.

Best regards, Gerd

[Former Member · Accepted solution]

Hi Gerd,

Thanks for your reply! It is perfectly correct, that I'm able to enter BSP0 and verify that SEM has attempted to call the layout since the variable is locked to the current user. So far so good ...

From this point I go to ways: 1.) Making sure, that there are no problems in the BPS layout and 2.) - as you suggest - debug the BSP.

The CO-orders that I have to transfer are alphanumerical - e.g. 'SAP-BW' - should this cause any problems?

Have you yourself implemented the code somewhere? Perhaps made any changes to the code? Would you - if changes have been made - let me have a look at your version?

Thanks in advance.

Regards,

Morten

[gerd_schoeffl · Accepted solution]

Hello Morten,

The CO-order looks okay. There should not be a problem but... What I would do - set a break point in the BSP-page just before the call where the variable is set. Then go past that call (e.g. using F6) and have a look at the return code and the message in the table lt_mesg. If this call runs okay (the sy-subrc is set to 0) then the variable is set properly and the problem must lay somewhere else. Could you check that please?

Well - I have implemented that code at one customer site and this is where I copied the coding from. So the coding should be all right. As far as I know some other customers ar using the solution from the how to paper and did not report any problems yet. This is why I think this might be a problem of the BSP coding itself but of the "interaction" of that coding with the given customizing at your site. Please try out the debugging as described above and tell me the result.

Best regards,

Gerd

[Former Member · Accepted solution]

Hello Gerd,

Thank you very much for your attention. I've debugged the BSP, and all sy-subrc's are EQ 0 and all variables are filled. The only thing I wonder about is that the co-order no. - e.g. FAGLIGVIDEN - is transfered/transformed into IEQFAGLIGVIDEN, but that is probably ok?

Besides debugging using SE80, I've put a trace on the proces from SM50. The log shows, that the program produces an uncaught exception that is related to program/module CL_BSP_RUNTIME. The service.sap.com seems to have no relevant notes related to this module/program.

I've somehow also wonder if the problem could be caused by the HTTP settings in the SMICM?

Could I mail you the SM50-log, please? Your mail would be gerd.schoeffl@sap.com?

Once again: Thanks in advance for putting your efforts into this!

Best regards,

Morten