Display a ALV report in EP

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Again,

Is there any special integration tool of ALVs into the Portal?

In general I do not have currently a FM, but I will probably write one.

Thanks,

Aviad

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Hi,

As far as I looked in the SDN and in the PDK, PDV is not supported in EP6. Is it correct? If it is supported, can you please give a link to the information.

Is there any way to display it using WD for example?

Thanks,

Aviad

[Former Member]

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

[Former Member]

Hi,

PDV is available in ep6.0 only in the PDK environment, which means that you can not use webdybpro for this.

There is a section here on SDN in which you can download the PDK6.0 and its documentation.

Aviad

[Former Member]

Hi Aviad,

Thanks a lot for your help but unfortunatly, I can not find the API for the PDV in the PDK60.

I am working on SP12, is it actually there?

Thanks again,

Aviad

[athavanraja]

PDV wont give you all the features of ALV. if you are intersted in having all the features an ALV offers, you either have to code everything yourself or assgin the alv program to a transaction and use transaction iview.

Regards

Raja

[Former Member]

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

[athavanraja]

PORTAL_ALV_QUERY_CALL can only handle ABAP queries and not ABAP reports .

Regards

Raja

[athavanraja]

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