Symptom
You perform data migration related to opportunity. You need to update the field Distribution Type in Item Revenue Schedule section in Products tabs of the opportunity. But the field Distribution Type is not available in the template Opportunity_Product_Revenue_Plan.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Sales work center
- Click on Opportunities view
- Open any opportunity
- Go to Products tab
- Select any product
- Note: The Item Revenue Schedule will be visible.
- Click on Add
- Note: There is a field called Distribution Type.
- Go to Data Workbench work center
- Click on Import view
- Click on Opportunity
- Download csv file
- Open template Opportunity_Product_Revenue_Plan
- Note: The field Distribution Type is not available.
Cause
The distribution of Item Revenue Schedule based on the Distribution Type is a special feature for the UI.
Resolution
For Data Workbench and for the OData API, the Distribution Type is not required because the distribution amounts need to be provided together with the corresponding distribution dates in the Data Workbench import file. The distribution is then automatically done based on the given distribution dates.
Keywords
Item Revenue Schedule, Opportunity, field Distribution Type, Data Workbench, template, pportunity_Product_Revenue_Plan, , KBA , LOD-CRM-OPP , Opportunity Management , LOD-CRM-INT-DWB , Data Workbench , Problem