10-24-2007 2:24 AM
I would like to know which fields/tables stores the
1) Project Status (system/user) similar to the one in tcode CN41.
2) Amount for last posting activity for a project.
Thank you
Message was edited by:
Alexander
10-24-2007 2:45 AM
Status :
Take objnr field from PROJ Table and now look at JEST Table ,field name is STAT
or you can status_read FM
2nd question - I have no idea
Thanks
Seshu
10-24-2007 2:46 AM
Check PROJ table. That will help you to find Project status.
ashish
10-24-2007 2:49 AM
Thanx there...
But how do i find the Dollar Amount for Last Posting Activity....
10-24-2007 2:52 AM
Hi,
Can you tell me where you see Dollar Amount for Last Posting Activity so that i can see and let you know.
ashish
10-24-2007 3:24 AM
Ashish,
I am not sure where it would be used. For the first time i am developing a report in PS for auditing purposes...which is some what like tcode CN41......
10-24-2007 3:26 AM
I have checked the output of the report but could not locate any amount field. If you have any idea, you can see the source code of program RCNST000. Or check with your functional consultant, if he gives an example, it will be easy to look further.
Hope this will help you.
ashish
10-24-2007 2:35 PM
Dollar Amount for Last Posting Activity
Is there any way to find to the past posting activity on the project.....
10-24-2007 3:13 PM
Check the below link for more information on Project systems:
http://www.sap-press.de/download/dateien/1274/sappress_projectmanagement_with_project_system.pdf
Try to talk to functional guy and he may help you.
This is not direct field ,this will determine by some other calculation based on cost center ,controling area.
Look at CJ91,CJ92,CJ93 ,OPID Transactions
Thanks
Seshu
10-26-2007 8:28 PM
"The dollar amount for last posting activity is a direct field, it is entered via a journal entry or a post" is the answer given by my functional consultant.
10-26-2007 8:53 PM
If you run transaction CN41 with the performance trace (ST05) turned on, you'll see all tables used by the transaction.
Rob
10-26-2007 9:17 PM
Just look at AFVC Table field name is PRKST
You have to link from PRPS ,PROJ table with AFVC then get PRKST Field
Thanks
Seshu
10-29-2007 3:36 PM
Atlast the functional consultant gave me the transaction for finding the Dollar Amount for Last posting activity.
She asked me to look at the CJR1 transaction (Report 1.01) and pull the actual column.
how can i find the find table and field name for the column.