Skip to Content
Product Information
Author's profile photo Joey Tan

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.

1.png

Creating Custom Field

1. Open the “Custom Fields and Logic” app (you may need the role ANALYTICS_SPECIALIST).

2.png

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.png

3. In the UIs and Reports area, enable usage for the following:

  • Manage Sales Plans (SD_SALESPERF)
  • Sales Performance – Plan/Actual (SD_SALESPLAN)

4.png

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).

5.png

In the “Sales Performance – Plan/Actual” app, you can compare planned and actual performance data by the new custom field.

6.png

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).

7.png

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Riwa Mouawad
      Riwa Mouawad

      This is great! Thank you for sharing

      Author's profile photo Sai Giridhar Kasturi
      Sai Giridhar Kasturi

      Thanks for sharing...

      Author's profile photo Eric Yu
      Eric Yu

      Thanks for sharing this.

      Author's profile photo Frank Xie
      Frank Xie

      Nice work✨

      Author's profile photo Daniel Emmenegger
      Daniel Emmenegger

      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

      Author's profile photo Jan Revyn
      Jan Revyn

      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

      Author's profile photo Former Member
      Former Member

      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%20screen%20shots

      Configuration screen shots

      Author's profile photo Yehia Ahmed
      Yehia Ahmed

      DId you figure out the solution?