3019626 - Error message "You are not authorized to execute report Sales Target Setting" when you open Sales Target Plan in Excel

You are not able to edit the Sales Plan structure in the excel because of the error " You are not authorized to execute report Sales Target Setting"

SAP Business Bydesign

1. Go to Managing my area work center
2. Go to Sales Planning view
3. Select any plan and click on Edit => Plan data in excel
4. Open the Excel File and Logon 
5. You will get the error "You are not authorized to execute report Sales Target Setting"

You have Unassigned the Report Sales Target Setting from the Work Center Managing My Area  with the View Sales Planning and Sales

You have to assign the Report to Sales Planning View in the system, please follow the below steps:

1. Go to the work center Business Analytics
2. Navigate to view Design Reports
3. Search for Report Sales Target Setting with ID CRMSTPP_Q0001
4. Click on Assign Button
5. Search  the Work center Managing My Area
6. Click on Assign Checkbox for the Work Center View Sales and Work Center View  Sales Planning
7. Click on Save
8. You should be able to edit the Sales Target Plan now

   2913805 - How to Define Sales Planning

Sales Planning; Planning; Sales Target; Sales Target Settinh; CRMSTPP_Q0001 , KBA , SRD-CRM-PLA , Planning , Problem