SAP Knowledge Base Article - Public

3297382 - Field is not showing in Sales pricing Condition Record template spreadsheet.

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

  1. Open app Manage Prices - Sales
  2. Click on 'Download Template'
  3. Open downloaded excel file
  4. 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

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions