Extract Project System Version information into BW

[Former Member]

Hi All,

We have requirement to extract the “Project structure
version” data into BI reports. The version data stored in tables like VSPROJ_CN, VSPRPS_CN, VSAFVU_CN, VSRPSCO_CN etc.

Are there any standard BI content extractors for this information?

[Former Member]

have used PS data for more than 2 years now and there is no standard extractor for version information. You could simply create custom extractor in RSO2 based on the table directly if you do not have any complex logic during extraction.

[AK_Analytics]

Hi,

We have the same requirement to extract forecast and original versions of project  from CN41.

I couldn't find any standard datasource that gets version related data (VS****_CN tables).

Has anyone been able to achieve this in BI ?

From what I understood, CN41 gives the snapshot of key figures at particular period.

At the beginning of every month, this snapshot is taken.

So in BI (cube 0PS_C041), since every record has Posting date, we can easily display snapshot of key figures for different periods.

For example, If I have to show snapshot for period 03.2012 then on query level I can restrict the data for posting date <= 03.2012. It should provide same snapshot if we select forecast version P0XXXXXF1203 (03.2012 period) in CN41.

I am not sure if this is what CN41 achieves.

[Former Member]

SAP doesn't deliver any standard extractor for this. I had to write a custom function module based extractor at my current client. Data is fairly straightforward, so the logic is not to hard.

[Former Member]

Hi Vineet,

I am PS Consultant and would like to extract the Project version (mainly RPSCO) data to BI. I read your post and had few questions: Per my understanding when you stated custom extractor, does it mean that I will have to write the logic based on version tables VSPROJ_CN, VSPRPS_CN,  VSRPSCO_CN and the object IDs in the custom extractor? Could you pls provide an example of the logic that you used in your custom extractor/function module?

Thanks in advance Vineet!

[Former Member]

Hi Sachin,

The project system extraction is like FI, no need to fill the setup table . Just activate the datasource in RSA5 and check in RSA6 . Then in extract checker, RSA3, check the data and load to BI system.

Go through this link to know about Standard Extractors in PS

http://help.sap.com/saphelp_nw70/helpdata/en/b4/60073c0057f057e10000000a114084/frameset.htm

For eg, For InfoCube 0PS_C03, Earned Value, the data is fetched through the standard DataSources:

0PS_ORD_EVA:      Order Earned Value

0PS_NTW_EVA:     Order Earned Value

0PS_NWA_EVA:     Network Activity Earned Value

0PS_NAE_EVA:      Network Activity Element Earned Value

0PS_WBS_EVA:     WBS Element Earned Value

Go through this and I feel you will find what you are looking for.

Regards,

Anjali