Pm_project and planning item sync

[ShreyasG]

I have created a new custom field in pm_project table, customer want this field to be displayed in SPW as well and hence needs to be synced with sn_core_planning_item table or sn_core_planning_project. Is there any way to achive this without writing any custom business rules or script includes? To be more clear how already existing fields are mapped in both tables?

[PaulaaO]

Hi Shreya,

Are you doing everything via SPW, as in creating the new projects there or still using the PPM functionality? If the later, then I assume you've integrated it with SPW, in that case you will need to do the following:

- create the same field, with the exact same properties on the sn_align_core_project table

- use Table Map to create the connection between the 2 fields as per the screen shot

Hope this helps 🙂