SAP PS report-(Open projects snapshot)

[former_member308318]

Hi Experts,

Would there be any Std report available where I can pull the following data in one shot.I am thinking of BW report if it can't be achieved by Std reports.

Requirement: The requirement is to pull the following data for all Open Projects. Let’s say 50 open projects so business would like to view the data for the following fields from 1-50 open project like a snapshot of all open projects.

Project ID

Project Description

Project Type

User Status of the Project

Basic Dates

User fields

Person Responsible

Reason for Investment

Scale

Environmental Investment.

Please advise.

Thanks,

Ashley.

[former_member308318]

Thanks for the solution guys.

I assume that I will be good with CN43N without BW report.Else I can also use SQVI.

Sanjeev:

Reason for Investment & Environmental Investment: CJ20N -WBS Element

Thanks!

[MTerence]

Hi Ashley,

If you got a solution, can you please close this thread as Answered.

Thanks

Terence

[sanjeevc]

Hello,

below is the FS for your report with this detail contact with abap or you can write standard query by SQVI transaction.

Project ID                         PROJ-PSPID

Project Description            PROJ-POST1  

Project Type                      PRPS-PRART  

User Status of the Project   CNJ_STAT-STTXT_EXT

Basic Dates                       PRTE-PSTRT

User fields                         PRPS-ZZZZZ

Person Responsible            PRPS-VERNR

Reason for Investment         let me know whether you are getting this option in which transaction?

Scale                               PRPS-FABKL

Environmental Investment.   let me know whether you are getting this option in which transaction? 

Regards,

sanjeev

[Former Member]

Hi,

You can find out all detail in one table except "User Status" in PRPS. You can make a query using "SQVI"

regards,

mukesh

[MTerence]

Hi Ashley,

Use CN43N - Individual overview of WBS element.

Hope this resolves your query.

Thanks

Terence