Product Information
How to Use Custom Fields in Sales Plans
Background
With the “Manage Sales Plans” and “Sales Performance – Plan/Actual” apps, you can set sales targets and monitor target fulfillment. If the standard fields offered by the two apps do not suffice in your business transactions (e.g., in transactions related to sales orders and billing documents), you can create custom fields. They serve as dimensions by which sales plans are managed and sales performance is analyzed or compared.
Creating Custom Field
1. Open the “Custom Fields and Logic” app (you may need the role ANALYTICS_SPECIALIST).
2. When create custom fields, choose one of the following business contexts:
· Sales: Sales Document
· Sales: Sales Document Item
· Sales: Billing Document
· Sales: Billing Document Item
3. In the UIs and Reports area, enable usage for the following:
- Manage Sales Plans (SD_SALESPERF)
- Sales Performance – Plan/Actual (SD_SALESPLAN)
Usage of Custom Field
In the “Manage Sales Plan” app, you can select the new custom field as a dimension and manage sales plans by the field (dimension).
In the “Sales Performance – Plan/Actual” app, you can compare planned and actual performance data by the new custom field.
Notes:
· In the Sales Performance – Plan/Actual app, the dimensions in the View By list are dynamically fetched from the Manage Sales Plan app.
· If a custom field in the Manage Sales Plan app does not exist in View By list of the Sales Performance – Plan/Actual app, ensure that Enable Usage has been activated in the Custom Fields and Logic app (as described in Step 3 above).
This is great! Thank you for sharing
Thanks for sharing...
Thanks for sharing this.
Nice work✨
Hello Joey
Thank you.
How to use an additional field in the PlanApp, which is already on the Salesorderitem (Producthierarchy)? how to extend table SALESPLAN_ITEM and all dependent objects (CDS-Views, oData, App)?
Regards
Daniel
Hi,
We have following problem with table SALESPLAN_ITEM and other related structures.
Our VBAK and VBRK (or VBAP and VBRP) have a ZZ-field with the same name in the SAP std extension includes. No need to mention these contain a lot of data.
These includes are all included in the SALESPLAN tables. --> impossible to activated because of duplicate field !
So SAP did not take into account duplicate fields may exist in the different order and billing tables.
How to solve our activation problem ?
Tx for any idea (except for remove/renaming the ZZ-field 😉
Regards,
Jan
Thanks for the nice blog.
I tried to add additional fields in Manage Sales Plans app as below but its not showing in dimensions while creating new sales plan. Please suggest what is missing here.
Configuration screen shots
DId you figure out the solution?