SAP Knowledge Base Article - Public

3221313 - Project Task ID Field Missing in Financial Planning Template


You are trying to enter the Project Task ID information into the financial planning excel but unable to find this field in the Excel Template downloaded from Cost and Revenue work center - Planning view.


SAP Business ByDesign

Reproducing the Issue

  1. Go to Cost and Revenue work center.
  2. Go to Planning view.
  3. Click on New and select 'Plan Version from Microsoft Excel'.
  4. Select 'New Expense And Income Statement Plan' and click 'Download'.
  5. Open the downloaded excel file. You cannot find a field "Project task ID".


There are many fields not mapped by default. You can customize the template according to the business need.


Download the excel template and under the Developer tab in Excel, view the source - this is an XML source structure and fields can be mapped to new columns via drag and drop. You could find Project Task ID here.

See Also

How to Add a New Field to Existing Templates in SAP ByDesign | SAP Blogs


Documentation, Project Task ID, Template, Microsoft Excel , KBA , SRD-FIN-COR , Cost & Revenue , Problem


SAP Business ByDesign all versions