Question:
Hi everyone.
I would like to know if it is possible to create an activity from a BW report.
We are drawing a report of business partners and their email address, and would like to create some kind of RRI to the CRM Activities BSP when we click on the email address. We would like to have the relavent fields populated in the CRM BSP from the BW report.
I know it's a little high-tech, but surely some one has done this before
Any help will be appreciated.
Thanks,
Viven
Answer:
You must be kidding, not?
Answer:
Transaction RSBBS. If you never used it, I recommend trying to find some documentation first. Try searching SDN or BI (in SAP) for "Report-Report Interface" or "RRI" or "Receiver reports".
_________________
Leandro,
Tuly Idiots Shadow Supporter
Answer:
You must be kidding, not?
I'm not kidding
(unless it's so simple and you're being sarcastic)
In thoery, it's not that difficult:
- Get the Business Partner number from the report;
- Create an activity of type email;
- Slap in the business partner number (which will fill in other relavent fields)
- And type out the email.
We are using the portal as our front end, so you must be able to POST the data directly to the BSP in CRM.
If there is a url that can be used to call the BSP, and specify parameters (like the type, BP number, etc.), could someone please point me in the right direction
Thanks for the info lhowlin. I'll be sure to have a look at that.
Viven.
Answer:
I was not being sarcastic... in theory anything is possible, in practice however there are a few performance issues to take into account. Personally I would assume you have a BW report on CRM data and you would NOT create CRM data based on the results of a BW report. Sounds like a bad plan to me (but that's a personal feeling of course).
Originally those "jump target" interfaces were build for "exceptional" use only (especially when jumping to another system and not another report on the same server... 'cause that's pretty straigth forward). I've done it from BW towards R/3 (to jump to detailed data) a couple of years ago though (about 3 I think) and I must tell you... performance wise, that already sucked big time!!!
Anyway, this are just "thoughts"... you can do with it whatever you want
Answer:
I was not being sarcastic... in theory anything is possible, in practice however there are a few performance issues to take into account. Personally I would assume you have a BW report on CRM data and you would NOT create CRM data based on the results of a BW report. Sounds like a bad plan to me (but that's a personal feeling of course).
Originally those "jump target" interfaces were build for "exceptional" use only (especially when jumping to another system and not another report on the same server... 'cause that's pretty straigth forward). I've done it from BW towards R/3 (to jump to detailed data) a couple of years ago though (about 3 I think) and I must tell you... performance wise, that already sucked big time!!!
Anyway, this are just "thoughts"... you can do with it whatever you want
Thanks El Belgio
Let me give you the full story:
We have Sales People who have a portfolio of clients. We have a BW report which shows this portfolio (including contact info) and the users want to beable to create activities directly from here. (they're too lazy to use the search functionality in CRM).
But I hear what you're saying about performance.
Guess they're just gonna have to learn to do some work!
Thanks again.
Viven
Answer:
actually... I might have been wrong
I checked around and it seems a "valid business case" in a CRM environment... you learn something new everyday
however, my experience with BSP is very minimum (for now... hehe) and I have no clue at this point how to help you out... maybe try to post this on the CRM or ABAP forum as well?
cheers,
El Belgio
Answer:
ok, check out programs/function modules starting with RSCRMBW* (in your BW system)... you can call those via the Report/Report Interface
I guess this is where you'll find the light (at least I hope you do)!
cheers,
El Belgio