Web reporting for CRM 4.0

[Former Member]

Hi all,

We are currently using ITS webgui as an extranet for our sales reps in order for them to access CRM reports (which are basically RFC calls to a 4.0 R3 backend) . We are currently upgrading to CRM Internet Sales 4.0 and R3 4.7.

We would like our sales reps to access reports through the B2B webshop (one logon). Would this mean to scrap webgui and manually program these reports in JAVA? Can someone suggest the best way to put these reports on the web in a B2B context? Thanks you for your input,

Pat

[Former Member · Accepted solution]

Hi Pat,

I'd guess if I'd been tasked with this, first thing I'd do is convert the code of the R/3 reports from executable programs into RFC enabled function modules. Then, as you said, create the presentation logic in Java and JSP within the B2B application.

It shouldn't take too long to do that - selection screens can be a bit tricky to ensure they fully mimic their R/3 counterparts but other than that most of the work is just aesthetic stuff in a JSP page. The Java aspect is really only handling the input of data from your selection screen (JSP page with a form?) calling the RFC module on R/3 and then passing the data back - not too much Java code really. Of course, this depends on how complicated the layout of your reports is and assumes they are custom - if you are talking about standard reports then there may be a bit more work involved in getting the logic running.

Hope this helps.

Gareth.

[Former Member · Accepted solution]

Thanks for your insight Gareth. I will probably go the JSP way.

Pat

[Former Member]

Anyone with suggestions?