on 10-13-2014 12:23 AM
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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can find out all detail in one table except "User Status" in PRPS. You can make a query using "SQVI"
regards,
mukesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashley,
Use CN43N - Individual overview of WBS element.
Hope this resolves your query.
Thanks
Terence
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.