CN41 - Status

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Check PROJ table. That will help you to find Project status.

ashish

[Former Member]

Thanx there...

But how do i find the Dollar Amount for Last Posting Activity....

[Former Member]

Hi,

Can you tell me where you see Dollar Amount for Last Posting Activity so that i can see and let you know.

ashish

[Former Member]

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......

[Former Member]

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

[Former Member]

Dollar Amount for Last Posting Activity

Is there any way to find to the past posting activity on the project.....

[Former Member]

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

[Former Member]

"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.

[Former Member]

If you run transaction CN41 with the performance trace (ST05) turned on, you'll see all tables used by the transaction.

Rob

[Former Member]

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

[Former Member]

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.