CRM Activity Status History analysis in BW

[Former Member]

Hello all,

We are in a process to fetch activity related data into SAP BW. We have successfully fetched data from "0CRM_SALES_ACT_1" data source.

But in this data source only current "user status" is fetched against transaction number.

Our requirement is to fetch all the "user status" which has been assigned to this transaction number till today along with their date (i.e. when this status was assigned).

Please guide.

[Former Member · Accepted solution]

Hello,

This might be done with a generic datasource on the database table which contains the transaction history filtered on the field "status".

Best regards,

Thomas Wagner