Open a ERP transaction code with filter value of a Design Studio Crosstab (e.g. VA03 sales document)
I have a Design Studio Dashboard with charts and detail jumps in Design Studio Crosstabs. My last and final wish is the jump into erp system to show the details of the document.
Are there any options to call an erp transaction code (e.g. VA03, VA23, etc.) with filter value of the selected Design Studio Crosstab row?
Click on the sales document number in the DS Crosstab...
... and show the selected sales doc. in the ERP transaction VA03.
Thanks in advance and best regards,
I think there is a way to get that... first of all I assume you know how to make the Crosstab "selectable" and how to assign a script to it to open a URL in a new window.
If that is given you only need to find the right URL :-)
How to get that one?
Your ECC sytem has a URL to open the WebGUI. If you do not have that one, ask you admin or create a Report-Report-Interface from BW Query to ECC Transaktion and run that from a query. The window that opens then has the right URL in it.
The syntax will be like that...
To that you have to add the field you want to to be pre-filled with the value you select in the crosstab.
Go to transaction VA03 and hit F1 in the field you are interested. In the help window switch to the "technical information" (icon in the top bar) and check the last field called "Screen Field". That is what you need. In your case: VBAK-VBELN
Now put everything together and take care for the "space" in between the transaction and the field witch have to be ULR-proof coded like %20.
BTW this can be used for all BI clients if RRI is not supported.
Hope that helps.