how to add a new field to MSP_TimeSheet table in EPM.

[jahandad]

am working on the customization of EPM and need suggestion/help in this
regards.

I need to add a field in TimeSheet. Lets say i have to add a 'Transaction
Category' field in timeSheet table MSP_Timesheet so that it will also be
available on Project server (EPM) page when i click on 'My timeSheet'. I am
new to this so any type of help will be highly appreciated or if you can give
me some sample or just tell what do you think that how can i do this.

 

[David Ducolon]

Hello Jahandad,

It is not possible to add additional fields to the out of the box fields to
project server. To enable your scneario, you would need to create another
table and joing it. The out of the box tables and APIs us typed datasets
which of course have well defined fields and thus are not dynamic.

Hope this helps. BTW this is true for 2007 and 2010. 2003 was the only
version with an API that could be extended but the 2003 model for API was
retired in 2007.

 

[jahandad]

Thanks for the response David
Is it possible to create a custom field say 'Field 1' (lookup type) and add
it to an existing view associated with tasks. I have tried this by making a
custom field through 'server settings > new custom field' However i am unable
to view this field in EPM. Can you please guide me that how to make this
field visible on EPM display like ' My tasks' or 'My timesheet'. And also
will the value of this custom field be stored in database ? b/c i may need to
transfer/sync this field with AX as well. Just like we have DAX_Project*
fields which are also synced with Ax database.