--- description: In this tutorial you will learn about Characteristics Settings – Display Name Characteristics Settings – Display Properties Keyfigure Settings – Display Name Keyfigure Settings &nda title: SAP BW Characteristics & Key Figures image: https://www.guru99.com/images/sap-bw-characteristics-and-key-figures.png --- [Skip to content](#main) **⚡ Smart Summary** Characteristics and key figures in SAP BW define the structure of every query, where characteristics describe business dimensions and key figures hold the measurable values that formulas, calculated key figures, and restricted key figures refine for reporting. - 📊 **Characteristics:** Characteristics describe business dimensions such as customer, product, or time in a query. - 🔢 **Key Figures:** Key figures hold the measurable values such as revenue, quantity, or cost. - 🎛️ **Display Settings:** Display name, properties, and record options control how data appears to the user. - 💱 **Conversions:** Currency translation and unit conversion let key figures combine across currencies and units. - 🧮 **Formulas, CKF and RKF:** Local formulas, calculated key figures, and restricted key figures refine reporting. - 🤖 **AI Assistance:** SAP Analytics Cloud and Joule add natural-language queries and augmented insights. Read More ![SAP BW Characteristics and Key Figures](https://www.guru99.com/images/sap-bw-characteristics-and-key-figures.png) ## What Are Characteristics and Key Figures in SAP BW? In SAP BW, a query is built from characteristics and key figures. **Characteristics** describe the business dimensions of the data, such as customer, product, or fiscal period. **Key figures** hold the measurable values, such as revenue, quantity, or cost. The settings below control how characteristics and key figures are displayed and calculated, and how formulas, calculated key figures, and restricted key figures refine the results. ## Characteristics Settings – Display Name By default, when a characteristic is added to the query, it displays the description specified in SAP BW. It is possible to replace this with customized text as follows: 1. Click on Properties. 2. Select the General tab. 3. Enter the Description. [![SAP Characteristics Settings Display Name]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_1.jpg) ## Characteristics Settings – Display Properties 1. Select the Display tab of the properties window of the selected characteristic. 2. The “Display as” option is used to display either only the Key, only the Text, or both Key and Text. 3. If a characteristic has two or more of Short / Medium / Long Text populated, “Text View” is used to display the corresponding text. 4. It is possible to sort data ascending or descending either by the characteristic or any of its attributes. 5. The “Result Rows” option is used to show or hide the sub-total for the underlying characteristic. [![Characteristics Settings Display Properties]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_2.jpg) ## Characteristics Settings – Display Records The display option is used to define what data is viewed by the user during data selection (in filters) and after report execution. 1. Select the Advanced tab of the properties window of the selected characteristic. 2. Access Type for Result Values. Choose one of these values. - “Posted values” shows only records that have some transactions associated with them. - “Master Data” displays all master data records irrespective of whether a transaction exists for them. It is ineffective if used with zero suppression. 3. Filter Value Selection. Choose one of these values. - Only Posted Values for Navigation: the system displays only posted values from the current navigational state. - Only Values in InfoProvider: the system displays only values contained in the InfoProvider. - Values in Master Data Table: faster, but may result in zero records matching the selection criteria. [![Characteristics Settings Display Records]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_3.jpg) ## Key Figure Settings – Display Name By default, when a Key Figure is added to the query, it displays the description specified in [SAP BW](https://www.guru99.com/sap-bi.html). It is possible to replace this with customized text as follows: 1. Click on Properties. 2. Select the General tab. 3. Enter the Description. [![SAP Key Figure Settings Display Name]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_4.jpg) ## Key Figure Settings – Display Properties 1. Select the Display tab of the properties window of the selected Key Figure. 2. Hide: - The options “Always Show” and “Always Hide” are self-explanatory. - “Hide (Can be Shown)” keeps a key figure hidden in the default output, but the user can later display it using filters. 3. Number of Decimal places can be used to restrict the decimals displayed in the report. 4. Scaling factor is used to show data in thousands, hundreds, and so on. 5. The sign of key figures can be reversed if required. For example, Sales Quantity is a negative movement from the inventory perspective but positive from the sales perspective. [![SAP Key Figure Settings Display Properties]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_5.jpg) **Don't Miss:** - [What is SAP BI? Module, Full Form, Definition](https://www.guru99.com/introduction-sap-bi.html) - [What is Direct Update DSO in SAP? How to Create One?](https://www.guru99.com/what-is-direct-update-dso-how-to-create-one.html) - [SAP InfoSet Tutorial: What is, Create, Joins](https://www.guru99.com/what-is-infoset.html) - [SAP BI/BW Tutorial for Beginners](https://www.guru99.com/sap-bi.html) ## Key Figure Settings – Currency Or Unit Conversion BW does not allow cumulating amounts in different units, for example one rupee to one dollar or one kilogram to one yard. When data exists in multiple currencies or units, all records must be converted to a single currency or unit using Currency Translation or Unit Conversion. The translation can be dynamic (using a selection screen variable) or static (with the target currency or unit hardcoded). The advantage of doing this in SAP BW is that it directly imports the conversion factors available in [SAP ERP](https://www.guru99.com/what-is-sap-definition-of-sap-erp-software.html). 1. Select the Conversions tab. 2. For currency translation, this option can be used. 3. For unit conversion, this option can be used. [![Currency Or Unit Conversion]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_6.jpg) ## Key Figure Settings – Aggregation [Query Designer](https://www.guru99.com/introduction-to-bex-query-designer-and-query-elements.html) gives the flexibility of calculating aggregates such as average, summation, and minimum. Similar calculations can also be performed on row-level data. 1. Select the Calculations tab. 2. Select from the different options available under the drop-down of “Calculate Results As”. [![SAP Key Figure Settings Aggregation]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_7.jpg) ## Key Figures – Local Formula BW allows the use of formulas on data coming from the InfoProvider to provide calculated values to the user, for example subtracting Cost from Revenue to calculate Profit. ## Steps to Create a Formula **Step 1)** 1. Right click on the structure “Key Figure”. 2. Click on “New Formula”. [![SAP Steps to Create Formula]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_8.jpg) **Step 2)** Click on the edit button of the properties box to create or edit a local formula. [![SAP Steps to Create Formula]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_9.jpg) **Step 3)** Some of the common operators used in BW include: - Addition, Subtraction, Multiplication, and Division. - NODIM displays key figures without their corresponding unit. - NOERR displays zero instead of an error message, for example zero instead of a division-by-zero error. - %GT shows the value of a key figure as a percentage of the total value. 1. In the “Detail View” box, enter the formula. 2. Use the operators from the “Operators” box. [![SAP Steps to Create Formula]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_10.jpg) ## Key Figures – Calculated Key Figure If the same calculation is required for multiple reports, it can be mapped to the InfoProvider instead of being created individually in each query. Such a key figure is called a “Calculated Key Figure” or CKF. Once defined, it can be dragged into a query like any other key figure. The biggest advantage of this approach is that it enables global definitions of common calculated KPIs. **Steps to create a Calculated Key Figure:** 1. Navigate to the InfoProvider section. 2. Right click on the Key Figures folder. 3. Choose the option “New Calculated Key Figure”. [![SAP Key Figures Calculated Key Figure]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_11.jpg) ## Key Figures – Restricted Key Figure Restricted Key Figures (RKF) can be used to selectively apply filters to a specific KPI in the report, but not to the entire report, for example splitting sales into columns such as YTD (Year To Date) Sales and PYTD (Previous Year To Date) Sales. **Step 1)** 1. Navigate to the InfoProvider section. 2. Right click on the Key Figures folder. 3. Choose the option “New Restricted Key Figure”. [![SAP Key Figures Restricted Key Figure]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_12.jpg) **Step 2)** Click on the edit button of the properties box to create or edit an RKF. [![SAP Key Figures Restricted Key Figure]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_13.jpg) **Step 3)** In the subsequent screen, at least one key figure and one characteristic must be entered to make a meaningful RKF. 1. The key figure which is to be restricted. 2. The characteristic may be restricted by a selection screen variable to make it a “Dynamic” RKF. 3. It may also be restricted by a constant, for example year = 2008. In the screenshot, version is restricted with the constant value “1”. [![SAP Key Figures Restricted Key Figure]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_22_14.jpg) Like CKF, RKFs are also global to the InfoProvider and can be reused in multiple queries using the same InfoProvider. ## FAQs 🆚 What is the difference between a calculated key figure (CKF) and a restricted key figure (RKF)? A calculated key figure applies a formula to existing key figures, such as revenue minus cost. A restricted key figure filters a single key figure by a characteristic value, such as year-to-date sales. Both are global to the InfoProvider. 🧮 What is a free characteristic in a BEx query? A free characteristic is included in a query but not shown in the initial result. Users can drag it into rows or columns during navigation to drill down, giving flexible analysis without changing the query definition. 📊 What is exception aggregation in SAP BW? Exception aggregation defines how a key figure is summarized differently from standard summation, for example showing a counter, a last value, or an average per characteristic such as headcount per month rather than a running total. 🤖 How does AI enhance reporting in SAP BW and SAP Analytics Cloud? AI in SAP Analytics Cloud adds augmented analytics: Smart Insights explains figures, Smart Discovery finds drivers, and the Just Ask feature answers natural-language questions, helping users explore BW data without building queries manually. 🧠 Can AI generate or optimize BW queries automatically? Increasingly, yes. Machine learning and the SAP Joule AI copilot can suggest key figures, propose calculated and restricted key figures, and recommend query structures, helping report designers build and optimize BW queries faster. #### Summarize this post with: ChatGPTPerplexityGrokGoogle AI **Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.** ##### Sign up for the newsletter Subscribe for Free You have successfully subscribed. Please check your inbox. ![AI-Newsletter]() Chosen by over **350,000+** professionals [Scroll to top](#wrapper) × Search for: ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/sap-bw-characteristics-and-key-figures.png","url":"https://www.guru99.com/images/sap-bw-characteristics-and-key-figures.png","width":"700","height":"250","caption":"SAP BW Characteristics & Key Figures","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/sap-bi","name":"SAP - BI"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html","name":"SAP BW Characteristics & Key Figures"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html#webpage","url":"https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html","name":"SAP BW Characteristics & Key Figures","dateModified":"2026-10-09T16:26:18+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/sap-bw-characteristics-and-key-figures.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/editorial","name":"Editorial Team","url":"https://www.guru99.com/author/editorial","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/favicon-new-logo.png","url":"https://www.guru99.com/images/favicon-new-logo.png","caption":"Editorial Team","inLanguage":"en-US"},"sameAs":["https://www.guru99.com/editorial-team"],"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"SAP - BI","headline":"SAP BW Characteristics & Key Figures","description":"In this tutorial you will learn about Characteristics Settings \u2013 Display Name Characteristics Settings \u2013 Display Properties Keyfigure Settings \u2013 Display Name Keyfigure Settings &nda","keywords":"sap-bi","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/editorial","name":"Editorial Team"},"dateModified":"2026-10-09T16:26:18+05:30","image":{"@id":"https://www.guru99.com/images/sap-bw-characteristics-and-key-figures.png"},"copyrightYear":"2026","name":"SAP BW Characteristics & Key Figures","subjectOf":[{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is the difference between a calculated key figure (CKF) and a restricted key figure (RKF)?","acceptedAnswer":{"@type":"Answer","text":"A calculated key figure applies a formula to existing key figures, such as revenue minus cost. A restricted key figure filters a single key figure by a characteristic value, such as year-to-date sales. Both are global to the InfoProvider."}},{"@type":"Question","name":"What is a free characteristic in a BEx query?","acceptedAnswer":{"@type":"Answer","text":"A free characteristic is included in a query but not shown in the initial result. Users can drag it into rows or columns during navigation to drill down, giving flexible analysis without changing the query definition."}},{"@type":"Question","name":"What is exception aggregation in SAP BW?","acceptedAnswer":{"@type":"Answer","text":"Exception aggregation defines how a key figure is summarized differently from standard summation, for example showing a counter, a last value, or an average per characteristic such as headcount per month rather than a running total."}},{"@type":"Question","name":"How does AI enhance reporting in SAP BW and SAP Analytics Cloud?","acceptedAnswer":{"@type":"Answer","text":"AI in SAP Analytics Cloud adds augmented analytics: Smart Insights explains figures, Smart Discovery finds drivers, and the Just Ask feature answers natural-language questions, helping users explore BW data without building queries manually."}},{"@type":"Question","name":"Can AI generate or optimize BW queries automatically?","acceptedAnswer":{"@type":"Answer","text":"Increasingly, yes. Machine learning and the SAP Joule AI copilot can suggest key figures, propose calculated and restricted key figures, and recommend query structures, helping report designers build and optimize BW queries faster."}}]}],"@id":"https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html#schema-1122845","isPartOf":{"@id":"https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html#webpage"}}]} ```