Symptom
The downloaded template excel has missing fields like "ConditionRateValueText" from "Condition Data" sheet.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud
Reproducing the Issue
- Open app Manage Prices - Sales
- Click on 'Download Template'
- Open downloaded excel file
- Some fields like "ConditionRateValueText" are missing from "Condition Data" sheet.
Cause
Some fields are hidden because the pane is frozen.
Resolution
Please follow the below steps to make the additional fields visible in the downloaded template excel:
1. In the excel file, head over to Condition Data sheet
2. Go to 'View' tab
3. Click on 'Freeze Panes'
4. In the drop down, click on 'Unfreeze Panes'
5. Scroll down to find the field or search the desired field using Ctrl+F (find shortcut).
Keywords
Sales Pricing Condition Record, Template, excel, missing field, ConditionRateValueText, Condition Amount or Ratio , KBA , SD-MD-CM , Conditions and Condition Maintainance , SD-MD-CM-2CL , Conditions and Condition Maintainance (Public Cloud) , Problem