Portal activity report, which tables in database?

[Former Member]

Hi,

Could someone say, which tables in database have information for Portal Activity Report?

I need to build my own report which I cant build using standart Portal Activity Report template.

great thanks

[hofmann]

Hi,

you really shouldn't access SAP portal db tables. These tables and the structure can change and SAP won't communicate this. This will give you more controll about the reports, as more data is collected.

The data stored in the DB tables for the PAR are only aggregated data. If you need more detailed data, the PAR data won't help you. In fact, what can be displayed with the PAR data in the DB, can be achieved with the PAR reports.

If you need to generate your own activity reports, you should considre using the other possibilities delivered with SAP Portal, like the Activity Data Collector:

SAP Help: http://help.sap.com/saphelp_nw70/helpdata/en/47/873c99c84a199ce10000000a42189d/content.htm

br,

Tobias

[Former Member]

Please check the following link which contains the list of tables you can use to generate reports

http://help.sap.com/saphelp_nw70/helpdata/en/47/873464c84a199ce10000000a42189d/content.htm

[Former Member]

Hi ,

Portal Activity Report use all tables with the prefix WCR_ : like WCR_USERPAGEUSAGE . Except for those who has the NODE phrase in there name like table WCR_WEBCNODESTAT which has the NODE phrase in its name, because those table consider to hold temporary data.

Gilad

[Former Member]

Hi,

For that, you may have to check the code for 'Portal acitivity report' iView. You may have to decompile and get the code.

Regards,

Harini S