Build Powerful Exit Functions in Integrated Planning
- by Pallavi Kale, BI Consultant, Deloitte Consulting India
- August 21, 2012
Many times standard SAP BI Integrated Planning functions are limited in scope and do not achieve the desired results when complex calculations or company-specific logic are involved. In such cases, exit functions are a tool that can take care of almost any kind of complex logic.
Exit functions are custom planning functions, based on a custom function type that is developed using a custom ABAP class. These functions provide flexibility to restrict the processing of data based on different parameters, arrange selected reference data including an actual date, and build your own logic for critical situations. For example, you can combine actual and planned data. You can use standard interfaces provided by SAP to build the base custom classes. Once the function type is designed, you can use it in several planning functions.
Every company has its own planning strategy based on its business model and experience. For example, media companies can have a planning interface to budget and forecast their marketing campaigns. In the media industry, unlike other industries, the products are sold or dispatched as a part of a subscription on a periodic basis.
From a planning perspective, the forecasted marketing campaigns are unrealized campaigns. The data for all unrealized campaigns comes from customer relationship management campaign master data. The planner calculates the revenue, response, gross margins based on the estimated customer base, attrition rate, sales, and cost. Once the campaign is realized, the actual data starts building up in SAP ERP Central Component (ECC).
At a given time, it may happen that you have actual data coming from ECC for the delivered subscriptions and planned data for subscriptions that are yet to be dispatched. To fine-tune the forecasting process, the actual data needs to be considered while determining key performance indicators (KPIs). The challenge is to combine the actual and planned data for calculations while restricting the write access only to the future plan data.
Would you like to see this full item?