--- title: Discover 4 Key SAP BPC Functions [Checklist] description: Learn SAP Business Planning and Consolidation (BPC) planning functions (BPC Functions) in this How to guide to SAP BOBJ functions. image: https://www.sapbwconsulting.com/hs-fs/file-16557413-png/images/evdre_builder-resized-600.png --- ![](https://www.sapbwconsulting.com/hs-fs/file-16557413-png/images/evdre_builder-resized-600.png) # Discover 4 Key SAP BPC Functions [Checklist] Table of Contents ## Four Critical BPC Functions Checklist If you’re a [SAP Business Planning and Consolidation consultant (SAP BPC)](https://www.sapbwconsulting.com/request-sap-business-planning-and-consolidation-sap-bpc-consulting-support) or [SAP BPC](https://www.sapbwconsulting.com/blog/14-sap-business-planning-best-practices) end user, you will frequently have need to use [BPC functions](https://www.sapbwconsulting.com/blog/inbound-marketing/does-pci-dss-compliance-affect-you).    Unfortunately, there are a lot of them, and it sometimes is hard to remember them, so I’ve decided to provide an on-going series of articles on those functions, which you can either copy here, or download from our site when I assemble them into one large checklist.   ## SAP Functions Are Critical to Your Project's Success With that, here is the first installment of 4 [SAP BPC Function](https://www.sapbwconsulting.com/request-sap-business-planning-and-consolidation-sap-bpc-consulting-support) definitions with their likely use [cases](https://www.sapbwconsulting.com/blog/understanding-the-difference-between-value-model-and-value-case).   **Objective:**  You need to use [SAP Business Planning and Consolidation](https://www.sapbwconsulting.com/blog/how-to-determine-your-fully-loaded-cost-rate) functions to convert an existing [Excel spreadsheet](https://www.sapbwconsulting.com/time-sheet-management-1099-payments-for-contractors) so it may be used in [BPC](https://www.sapbwconsulting.com/blog/how-to-build-a-sap-sem-bps-retail-industry-value-case) for Excel as an input template.   BPC functions allow you to create excel type workbooks that require minimal ongoing maintenance.   The **EVSND (Send)** function references another cell and sends its [value](https://www.sapbwconsulting.com/blog/value-stream-mapping) to the database when a Send is initiated.  The arguments specified in the EVSND function identify where the [data](https://www.sapbwconsulting.com/develop-a-data-governance-framework) value is to be sent in the database.  [Any dimension](https://www.sapbwconsulting.com/blog/learn-what-makes-sap-dfps-solution-different) that is not specified in the function will be taken from the Current View.  EVSND also returns the value from the database to the referenced cell.  This is useful for two reasons: - You [do not have](https://www.sapbwconsulting.com/blog/inbound-marketing/how-important-is-data-governance-to-internet-marketing) to add any **EVGTS** functions to the sheet in order to return values to the cell - Because the values are returned to the referenced cell, BPC only sends those cells that have changed since the last send in the current session. ## SAP BPC Exchange Function **Objective:**  You need to create data range report. **Description:**  The **EVDRE (Data Range Exchange)** function allows you to create large reports or input schedules with optimal performance.  **EVDRE** is considered and “exchange” [function](https://www.sapbwconsulting.com/blog/cots-vs-custom-development-decision-tree-analysis) because it is bidirectional, that is, it can be used to both send and retrieve data.   ![SAP BPC EvDre Builder](https://www.sapbwconsulting.com/hs-fs/file-16557413-png/images/evdre_builder-resized-600.png) **The Initial Screen for the EvDRE Builder** ## SAP BPC Time Functions **Objective:**  You need to create a date range that is offset from another date range. **Description:  EVTIM (Time Period Offset)** Function specifies an offset from a given time period.   A typical use of this function is as follows:  In cell D4 of a new workbook, enter an EVCVW function to return Q1 2012.  In cells E4 through G4, enter an EVTIM function, with an offset of 1.  These cells should retrieve Q2 2012 through Q4 2012.  When you change the Current View to Jan 2012, all the cells change accordingly, showing Feb 2012 through Apr 2012. ## SAP BPC Reporting Functions   **Objective:**  You need to utilize BPC reporting functions to create a report template from a blank Excel workbook. **Description:**  The **EVGTS (Get Value and Scale)** function retrieves a data value.  The arguments specified in the EVGTS function identify which data value to retrieve from the database by specifying the dimension members that describe that data value.  Any dimension that is not specified in the function will be taken from the Current View.  The retrieved value will be scaled if the scale property is enabled for the specified account.   ### You can also use the EVGTS function to retrieve data from two different applications.   **Description:**  You can create reports that retrieve data from [multiple applications](https://www.sapbwconsulting.com/blog/inbound-marketing/4-ways-to-bring-digital-innovation-to-your-company).  The applications must reside within the same application set.  The EVGTS function has an argument called AppName.  To retrieve data from one application, create EVGTS functions that reference that particular application in the AppName argument.  To retrieve data from a second application with the same report, simply create additional EVGTS functions that reference the second application in the AppName argument.   ## SAP BPC Variance Function   **Objective:**  Create a variance calculation using the EVBET function.   **Description:**  The **EVBET (Better/worse)** function performs a better or worse comparison of two values, based on the account type (ACCTYPE) property of the account member.  The ACCTYPE property may have one of the following values:  - INC (Income), - EXP (Expense), - AST (Asset), - LEQ (Liability & Equity). ## SAP BPC Row Expansion Functions   **Objective:**  You need to create a report that contains a row expansion **EVEXP function** and a column expansion **EVEXP function**.  This will enable drill down capability in both the rows and the columns of the report. **Description:**  When expansion functions are used in [reports](https://www.sapbwconsulting.com/blog/inbound-marketing/12-sap-crm-content-management-system-requirements) and input schedules, users can dynamically expand dimensional data based on criteria defined in the expansion [formula](https://www.sapbwconsulting.com/blog/inbound-marketing/how-to-correctly-calculate-conversion-rate-3-easy-formulas-to-use).  In the expansion formula, you can specify whether to expand the report by row, column, or both, and on which member to base the expansion criteria.  By clicking on a cell that contains an expansion formula, the report is restructured to include the new members, while maintaining its original design.  The EVEXP (Expand) expansion function performs row or column expansions.   I'll provide some more of these functions in a subsequent entry.  In the meantime, if you need these and 6 other critical SAP BPC functions in a handy [checklist](https://www.sapbwconsulting.com/blog/how-to-use-a-project-charter-to-start-a-project) format, just press the button.   [![Get 10 BPC Functions Checklist](https://no-cache.hubspot.com/cta/default/118735/5dd08cfd-6a79-463a-bf15-927c5bc507b2.png)](https://cta-redirect.hubspot.com/cta/redirect/118735/5dd08cfd-6a79-463a-bf15-927c5bc507b2)   **People Who Read This Also Read:** - [How to Map SAP BPC to Planning Scenarios](https://www.sapbwconsulting.com/blog/how-to-map-sap-bpc-to-planning-scenarios) - [Get 10 Critical SAP BPC Functions](https://www.sapbwconsulting.com/get-10-critical-sap-bpc-functions) - [How to Get SAP BPC Consulting Support](https://www.sapbwconsulting.com/request-sap-bpc-consulting-support) - [Project Net Present Value NPV Calculator](https://www.sapbwconsulting.com/net-present-value-npv-template)   Topics from this blog: [How-To](https://www.sapbwconsulting.com/blog/topic/how-to) [BPC](https://www.sapbwconsulting.com/blog/topic/bpc) [Checklist](https://www.sapbwconsulting.com/blog/topic/checklist) [Guides](https://www.sapbwconsulting.com/blog/topic/guides) ### Download SAP BW Mindmap Learn what SAP Business Warehouse is and what it does in under five minutes [![Get this Mindmap](https://no-cache.hubspot.com/cta/default/118735/8db2ad37-8211-47a3-86ae-09b6b2bb297b.png)](https://cta-redirect.hubspot.com/cta/redirect/118735/8db2ad37-8211-47a3-86ae-09b6b2bb297b) [mailto:someone@yoursite.com](mailto:someone@yoursite.com) ### Lonnie D. Ayers, PMP About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and ** remote coaching. ** ![Balanced Scorecard Consultant](https://www.sapbwconsulting.com/hubfs/social-suggested-images/Balanced%20Scorecard%20Certified%20Graduate.jpg) He also recently released a book **"How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results",** which is available on [ Amazon.](https://www.amazon.com/Dominate-Turbocharging-Digital-Marketing-Results/dp/1728357950/ref=sr_1_1?dchild=1&qid=1589182458&refinements=p_27%3ALonnie+D.+Ayers&s=books&sr=1-1&text=Lonnie+D.+Ayers)**** [View All Articles by Lonnie D. Ayers, PMP](https://www.sapbwconsulting.com/blog/author/lonnie-d-ayers-pmp) ## The SAP Blog Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email. [mailto:someone@yoursite.com](mailto:someone@yoursite.com) ![SAP](https://googleads.g.doubleclick.net/pagead/viewthroughconversion/960101754/?value=0&guid=ON&script=0) ![](https://www.facebook.com/tr?id=199270410761059&ev=PageView&noscript=1) ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions#blogposting", "@type" : "BlogPosting", "about" : [ { "@type" : "Organization", "name" : "SAP", "sameAs" : "https://en.wikipedia.org/wiki/SAP_SE" }, { "@type" : "Thing", "name" : "SAP Business Planning and Consolidation", "sameAs" : "https://en.wikipedia.org/wiki/SAP" }, { "@type" : "Thing", "name" : "Business planning", "sameAs" : "https://en.wikipedia.org/wiki/Business_plan" }, { "@type" : "Thing", "name" : "Consolidation (business)", "sameAs" : "https://en.wikipedia.org/wiki/Consolidation_(business)" } ], "author" : { "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person" }, "description" : "Explore the critical functions in SAP BPC for effective business planning and consolidation.", "headline" : "Discover 4 Key SAP BPC Functions", "inLanguage" : "en", "mainEntityOfPage" : { "@id" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions#webpage" }, "mentions" : [ { "@type" : "Thing", "name" : "Database", "sameAs" : "https://en.wikipedia.org/wiki/Database" }, { "@type" : "Thing", "name" : "Project", "sameAs" : "https://en.wikipedia.org/wiki/Project" }, { "@type" : "Thing", "name" : "Value (economics)", "sameAs" : "https://en.wikipedia.org/wiki/Value_(economics)" } ], "name" : "Discover 4 Key SAP BPC Functions", "potentialAction" : { "@type" : "ApplyAction", "name" : "Get 10 BPC Functions Checklist", "target" : { "@type" : "EntryPoint", "actionPlatform" : [ "http://schema.org/DesktopWebPlatform", "http://schema.org/MobileWebPlatform" ], "inLanguage" : "en", "urlTemplate" : "https://www.sapbwconsulting.com/get-10-critical-sap-bpc-functions" } }, "publisher" : { "@id" : "https://www.sapbwconsulting.com#organization" }, "url" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#website", "@type" : "WebSite", "inLanguage" : "en", "name" : "SAP BW Consulting, Inc.", "publisher" : { "@id" : "https://www.sapbwconsulting.com#organization" }, "url" : "https://www.sapbwconsulting.com" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#organization", "@type" : "Organization", "logo" : { "@id" : "https://www.sapbwconsulting.com#logo" }, "name" : "SAP BW Consulting, Inc.", "sameAs" : [ "https://www.linkedin.com/company/sapbwconsulting", "https://www.youtube.com/user/SAPBWConsulting/", "https://twitter.com/Lonniea39", "https://www.facebook.com/SAPBWConsulting" ], "url" : "https://www.sapbwconsulting.com" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#logo", "@type" : "ImageObject", "caption" : "SAP BW Consulting, Inc. logo", "url" : "https://www.sapbwconsulting.com/logo.png" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person", "@type" : "Person", "name" : "Lonnie D. Ayers, PMP", "sameAs" : [ "https://www.linkedin.com/in/lonnieayers" ], "url" : "https://www.sapbwconsulting.com/about-us/lonnie-ayers", "worksFor" : { "@id" : "https://www.sapbwconsulting.com#organization" } } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions#webpage", "@type" : "WebPage", "breadcrumb" : { "@id" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions#breadcrumbs" }, "description" : "Explore the critical functions in SAP BPC for effective business planning and consolidation.", "headline" : "Discover 4 Key SAP BPC Functions", "inLanguage" : "en", "isPartOf" : { "@id" : "https://www.sapbwconsulting.com#website" }, "mainEntity" : { "@id" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions#blogposting" }, "name" : "Discover 4 Key SAP BPC Functions", "url" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions#breadcrumbs", "@type" : "BreadcrumbList", "itemListElement" : [ { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com", "name" : "Home", "position" : 1 }, { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com/blog", "name" : "Blog", "position" : 2 }, { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com/blog/discover-4-key-sap-bpc-functions", "name" : "Discover 4 Key SAP BPC Functions", "position" : 3 } ] } ```