on 2005 Jul 23 6:49 PM
Hi,
What is the best way to display an ALV report in the Portal?
I would like the report to be displayed in the GUI of the Portal (meaning, I would like to work with WebDynpro or PDK or any other way such that the GUI will be identical to all the other Portal objects).
Thanks in advance,
Aviad
Hi Aviad,
1.Simplest would be to assigning a transaction code to the report and creating a SAP R3 transaction iview.
2. If you have a FM that can give u output data, then its easy to create a iview using Visual composer, or you can create a RFC Iview in Portal catalog.
3. If it is a query then you can use com.sap.portaldata viewer and display report in Portal.
There are many ways. it depends on how you have or designed in R3 System. Hope this helps. Let us know if you need more
Thanks,
Praveen
PS.Dont forget to reward points if useful/solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Aviad,
did u have a chance to look at the Visual Composer. You can create iviews without writing a single line of code.
If you desire to write FM, then with visual composer its only 5 min job to create a report iview. Hope this helps
thanks,
Praveen
PS. Dont forget to reward points if useful or solved
Hi Aviad,
You can work with a PDV component found in the PDK.
The documantation on PDV can be found here on SDN.
What you will actually use is the BAPI called - "PORTAL_ALV_QUERY_CALL".
Aviad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We have implemented many WD reports in portal, Those are not user friendly as like a ALV. I think you have to write all those ALV functionalities using Java Code which may be tedious job.For example SAP did not provide any functions to download the displayed table contents to Excel. Thanks, Sai
Hi,
You can actually, as suggested by others, code the PDV_ALV found in the PDK yourself.
All you need is to understand the workflow of the BAPI called "PORTAL_ALV_QUERY_CALL".
This BAPI is configured to get the properties of a query and another BAPI (derived from Z_QUERY_SELECTIONS) which plants additional data in the original query.
For example - If you wish to activate a query called myQuery1 in the user group FI-AP with a variant called TEST between a date range selected by the portal user. The parameters passed to the BAPI are as follows -
"QUERY_NAME=myQuery1"
"QUERY_USERGROUP=FI-AP"
"QUERY_VARIANT=TEST"
"QUERY_CREATE_SELTAB_FM=Z_QUERY_SELECTIONS_1"
"FROM_DATE=" "TO_DATE="
What will happen in the background is that the query myQuery1 from the usergroup FI-AP will be activated using the variant TEST and using the QUERY_CREATE_SELTAB_FM value the date fileds will be assigned to their corresponding fields in the query. After the activation the BAPI will return a table with the result.
Hope it helps,
Aviad
the best way is to use the transaction iview. the reason being the number of features ALV provides. if you had replicate these stuffs, in your java iview, thats lot of work.
Regards
Raja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.