I understand as per standard apo, it is possible to change \time bucket profile\ when \period s. Apo planning book macros on aggregated levels sap blogs. What that means is that they will work on break fixes and some functional enhancements but nothing revolutionary. Jul 10, 2015 here are some examples of different macros with different functions used in sap apo. You will learn how to create demand plans using various forecasting techniques and how to apply marketing and sales intelligence to the demand plan. Basically, we would find ans wers to the above two questions. Todays topic is trouble shooting apo planning book macros. Agenda sap flexible planning overview outline the differences between standard sop and flexible planning create sales and production plans use the forecast tool create planning types, macros and events perform resource planning and roughcut capacity analysis use mass processing transfer planning. Highly configurable planning books with macro functionality. In this article we would cover another practical use case in apo planning book. On the planning book tab page, you give a longer description for the planning book, the planning area on which the planning book is based, the snp functions for example. I created a planning book and data view with followi. Key figures are the rows that populate planning books in apo.
Abap apo planning book macros on aggregated levels. Click more to access the full version on sap one support launchpad login required. I understood that you told me that this is the best option and also you dont have to load the apo product md to maintain the conversion factors for each product. You use macro groups to restrict your selections in the macro workbench. Explore our comprehensive solutions for all business processes across all industries to find the solutions you need to run your business better, faster, and simpler enterprisewide. Macro execution both foreground and background failed, or succeeded but calculation result is incorrect. The purpose of this document is to provide us with a detailed read more. Perform complex calculations in planning book using macro badis.
This way we can easily see values from product master in planning book. Sales order and shipment history data is loaded to cube and use the same for creating cvcs and define various macros to calculate forecast. How to trigger an event using apo planning book macro. You can select macro books in the sap list viewer either manually or by using the filter and sorting functions in the sap list viewer. Sap apo planning book pdf download demand planning with sap apo dp. In my apo system there are around 40 planning books and 70 views. Since you generally choose enter when entering values, sap recommends that you use macros with this functions as default macros. Reliable online sap ides for erp ecc for 7 days ibm doubles down on hybrid cloud. Abap apo planning book macros on aggregated levels spider. Here are some examples of different macros with different functions used in sap apo. Sap library supply network planning run sap help portal. Download book 6, 274 kb as a courtesy to our readers the ebook is provided drmfree. For example, there may be a need to allow the users to execute a certain background job or process chain by just running a macro in the interactive.
In this planning book, therere complicated drill down and drill up macros to make sure the result for multiple planning objects is also consistent. Before data can be loaded into supply network planning. Hi, is there any standard function module in apo which can block the users from entering the data views corresponding to a specific planning area. The components area shows macros that are active both for all data views in this planning book and for this. This document is an excerpt from the complete scm 5. Now perform drill down to a certain characteristic. Data views control the layout of the planning table and are the snp planners most important tool for analyzing, modifying, and creating planning data. For every macro which we create and activate, there will be macro id assigned and abap code will be generated for the same. Maintenance of demand planning book, master planning object structure, planning area and macros in the interactive demand planning. We can use this process to implement a standard vendormanaged inventory vmi scenario with an sap erp system and an sap advanced planning and optimization apo system for the vendor, and an sap erp system for the customer. In the attributes of the row, enter row attributes as the data source. The design considerations for efficient and welldesigned macros are the same as efficient and welldesigned programming.
Once we cover the planning book we will get into detail on sap macros. Make the necessary settings in customizing for advanced planning and optimization sap apo, under supply chain planning production planning and detailed scheduling ppds product planning table define days supply types. Input some value to a certain cell into key figure additional field 5, and press enter. Sap can call you to discuss any questions you have. You can also plan for critical products to reduce the lead time and to improve time delivery performance. Administration of demand planning and supply network planning maintain planning areas and planning object structure sapapotr32. Test macro on planning book and here is the result in sapaposdp94 transaction. Our next step is to look at macros, which are embedded in the planning book for. We will consider an example where an alert situation is highlighted when forecast. Implementing the alert monitor functionality using macro. Apo advanced macros webinar 1 use case control flow. Balance supply and demand planning across your global supply chain with sap advanced planning and optimisation sap apo. Sep 26, 2014 original of article taken from my personal blog site at. How to identify the key figure that was changed by the user onsap.
Fixing is the ability to lock the cells in a key figure. People working as a business analyst, sap mm or pp consultant or demand and planning professionals can greatly benefit from the course. Overview of supply chain planning in sap scm apo, integration with demand planning dp and production planning ppds. You use this function to find macros books and individual macros that contain the following.
Is there any table from which i can get the name of macros in human readable form. Besides, promising sap apo consultants will find this course highly relevant. Change of time bucket profile within planning book sap. Knowledge in configuring planning area, planning books, data views and advanced macros. Demand planning with sap apo concepts and design paperback. How to identify the badi name of the macro from planning book view. You should put this macro in the events level change and start because when you open sapaposdp94 and when you change the level the macro will be executed. However the performance may get affected by those macros. Since documents will be disable in new scn, the content of this document is moved to wiki page sap. Calculations in dp planning book using macro badis. Test macro on planning book open planning book data view, load a certain selection. Sap advanced planning and optimization archives page 2 of 9. Source systems, infoobjectscatalogs and infocubes planning components like planning area, maser planning object structure mpos, planning books and macros various forecasting methods such as. I want to lock the data in the interactive planning table according to each key figure and a period of time that mean i can not change the data of kf after locked.
Planning book maintenance sap library planning area. When i try to save the values the values get cleared or is replaced by the last values of the planning view that was last saved. You can use auxiliary key figures with macros, for example. For example, the abc technology demand planner locks the current. Generally, they can do just about everything you could do with abap code.
They are powerfull and allow you to improve a lot user experience in apo dp and snp. At present the user exit macro calculates the values properly and also gets them properly in the planning view of the interactive planning transaction. Most of the functions available are value functions, controlling the numbers or values stored within apo. Manage supply network planning in mysap scm sap apo 6 supply network planning the core business process you run in your company for planning your supply network. Open planning book data view, load a certain selection. Here id like to present my solution of a problem in apo planning books where it was necessary to load multiple products and locations at the same time into the planning view and execute some default macros on all of them. Sap apo has been promised sap support through 2025. At a high level, apo is used for longterm planning. This video explains sap apo users as how to fix the key figure values in planning book. The planning areas you are using such as 9asnp01 or 9asnp02 determine which key figures are transferred to your planning book. How intuitive is interactive planning book sdp94 from apo. Jul 30, 2015 drag the macro to default group and save the macro book.
This paper provides a detailed step by step procedure for implementing the alert monitor and macro. Oct 08, 2014 the planning book, therefore, is a preselection of characteristics and key figures. They are exclusively locking different set of cvcs. In the previous article we learnt how to debug macros in apo planning book. It is written from a long years experience in implementation projects and aims to provide project managers and team.
This book provides an overview about the supported scm processes and explains how to implement sap apo tm in a company. Hello, macro 1 hello, macro 2 hello, macro 3 macro examples sap scm apo. Functionality you can use this method to change key figure values in a data view for a planning book. The problem is that when the user has changed these key figures a macro should run online. There are two sessions processing time series data from the same planning area planning version.
Overview of demand planning concepts and data structures. There are lot of opportunities from many reputed companies in the world. Home demand planning demand planning process planning book design advanced macros. When i open a planning book in sapaposdp94, i could see the name of the macro, however i do not know what is the badi method in which this bad. Hi, there is no direct macro function to check planning book is change or display mode. I understand that all the macro relevant methods are available in the standard sap badi sapapoadvx, however it is difficult to map the right method in the badi with the macro that was used in the planning book. Dear all, we have a situation where in the planning book data in demand planning is locked by users using the same planning book even though the selections are completely different. The interactive planning desktop in supply network planning snp is where you. Sap was probably too optimistic or eager at showing its own way.
A number of the macros are standard calculations that ship with apo. In planning book we need to load this material at detailed level that is material and location level. How to identify the badi name of the macro from planning book. Refer to the following table to find the macro function of your choice. As you can see below we have 35ku, basically 35k 35000pcs as a conversion factor. Our experts are passionate teachers who share their sound knowledge and rich experience with learners variety of tutorials and quiz interactive tutorials.
Sap advanced planning and optimization how to trigger an event using apo planning book macro. This demo shows you some of the macro functions developped by our company dowap. Configuring the administrator workbench and the planning area, master data, planning books, advanced macros. The final chapters of this book describe available integration options and the architecture of sap apo, as well as a suggested process for successful implementation. I wanted a consolidated list of macros and to which planning book it belongs. By pushing enter, the default macro will be triggered. After transport of planning book settings, some macro relevant problems are found in target system, e. Sap apo planning books for the short horizon to better reflect market demand situa. Interactive solution for complex calculations in dp planning book using macro badis. There are some instances when we want to be able to raise an event using an apo planning book macro. Jul 10, 2003 unleash the power of macros in abap by rehan zaidi in developer on july 10, 2003, 12. How to identify the badi name of the macro from planning.
The second step would be to define the macro in the relevant planning book data view for highlighting the alert situation. Display last deliveries if you want to use this function, you must. In my case, there was a exit macro that was changing the data iu every bucket by. The badi will have the planning book data to play around. February, 2004 this version is valid for sap apo 3. Supply chain management is growing both as a research subject and as a crucial field of importance across organizations. The requirement was to execute the macro always only per one productlocation. Abap apo planning book macros on aggregated levels posted on 20140926 by spider here id like to present my solution of a problem in apo planning books where it was necessary to load multiple products and locations at the same time into the planning view and execute some default macros on all of them. Macro execution sequence along with data in sap apo. Sap apo supply planning supply planning heuristic, deployment, tlb, ppds planning, demand planning, core interface. Sap resume st louis, mo hire it people we get it done. Manage supply network planning in mysap scm sap apo pdf. The advanced planner course has been developed for the sap end users and it analysts. Configuring supply network planning and interactive planning using planning books and macros.
For some users you notice the left toolbar is missingblank when working on the planning book sapaposdp94, where you select the selection profile, planning book data view, macros and so on. In sap apo, production planning detailed scheduling ppds is used to generate procurement proposals to meet the production requirements. Planning book open planning book data view, load a certain selection. To add all key figures from the planning area to the planning book, choose the add all key figures icon below the planning area window.
According to research sap apo has a market share of about 1. The tables sapapoadvm and sapapopbmadvm were partially helpfull. Sap dpsnpppds functional team member resume hire it people. The advanced planner and optimiser sap apo tm is the software from sap dedicated to supply chain management. The function is not available if the compatibility mode is activated for the macro book.
Enhance supply chain management scm with sap advanced planning and optimization sap apo. Write batch planning books with minimal rows and macros for the mass job. One or some macros of the corresponding planning book or data views are found to be in inactive deactivated status red light. How to find the macro execution sequence in apo planning book. Sap apo dp demand planning sample training content and overview. This component is also used for defining resource plan and order details. You will gain an indepth understanding of how demand plans with sap apo are created based on historical data. Previous next this solution offers integrated, bestinclass functionality for demand, supply, and production planning as well as global availabletopromise atp. Sap abap macros if we want to reuse the same set of statements more than once in a program, we need to include them in a macro. A program subroutine pool will be created for each data view of the planning book in macro builder.
Imagedata in this kba is from sap internal systems, sample data, or demo systems. Macro value from product master in planning book sap. Importance of demand planning sap apo demand planning terminology apo data structure. Hello scm experts, i have started working on macros recently and in my current system i see some of the badi macros implemented and i need to support them. Interactive solution for complex calculations in dp. Since you generally choose enter when entering values, sap recommends that you use macros with this. Visit sap support portals sap notes and kba search. Fixing of key figure in planning book in sap apo youtube.
1458 1276 36 535 887 1487 885 606 352 704 787 1289 783 1266 1100 98 767 1455 49 1154 1199 1099 1217 1323 1001 611 1110 435 964 263 284 1186 944 830 688 398 31 501