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. The design considerations for efficient and welldesigned macros are the same as efficient and welldesigned programming. How to identify the badi name of the macro from planning book. This paper provides a detailed step by step procedure for implementing the alert monitor and macro. Todays topic is trouble shooting apo planning book macros. I created a planning book and data view with followi. The planning areas you are using such as 9asnp01 or 9asnp02 determine which key figures are transferred to your planning book.
Write batch planning books with minimal rows and macros for the mass job. Planning book open planning book data view, load a certain selection. 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. Input some value to a certain cell into key figure additional field 5, and press enter. The purpose of this document is to provide us with a detailed read more. One or some macros of the corresponding planning book or data views are found to be in inactive deactivated status red light. Sap apo supply planning supply planning heuristic, deployment, tlb, ppds planning, demand planning, core interface. At a high level, apo is used for longterm planning.
Sap apo planning books for the short horizon to better reflect market demand situa. Imagedata in this kba is from sap internal systems, sample data, or demo systems. What that means is that they will work on break fixes and some functional enhancements but nothing revolutionary. How intuitive is interactive planning book sdp94 from apo. Since you generally choose enter when entering values, sap recommends that you use macros with this functions as default macros. You can also plan for critical products to reduce the lead time and to improve time delivery performance. 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. Planning book maintenance sap library planning area. Source systems, infoobjectscatalogs and infocubes planning components like planning area, maser planning object structure mpos, planning books and macros various forecasting methods such as. Balance supply and demand planning across your global supply chain with sap advanced planning and optimisation sap apo. I understand as per standard apo, it is possible to change \time bucket profile\ when \period s.
Jul 30, 2015 drag the macro to default group and save the macro book. The advanced planner course has been developed for the sap end users and it analysts. For example, the abc technology demand planner locks the current. Overview of supply chain planning in sap scm apo, integration with demand planning dp and production planning ppds. Data views control the layout of the planning table and are the snp planners most important tool for analyzing, modifying, and creating planning data. Demand planning with sap apo concepts and design paperback. Sap library supply network planning run sap help portal. Test macro on planning book open planning book data view, load a certain selection. This video explains sap apo users as how to fix the key figure values in planning book.
Sap advanced planning and optimization archives page 2 of 9. Sap dpsnpppds functional team member resume hire it people. Configuring the administrator workbench and the planning area, master data, planning books, advanced macros. Change of time bucket profile within planning book sap. Implementing the alert monitor functionality using macro. The advanced planner and optimiser sap apo tm is the software from sap dedicated to supply chain management.
How to identify the badi name of the macro from planning. Macro value from product master in planning book sap. 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. This book provides an overview about the supported scm processes and explains how to implement sap apo tm in a company. Calculations in dp planning book using macro badis. 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. You will gain an indepth understanding of how demand plans with sap apo are created based on historical data. They are powerfull and allow you to improve a lot user experience in apo dp and snp. You use this function to find macros books and individual macros that contain the following. At present the user exit macro calculates the values properly and also gets them properly in the planning view of the interactive planning transaction. 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. People working as a business analyst, sap mm or pp consultant or demand and planning professionals can greatly benefit from the course.
In planning book we need to load this material at detailed level that is material and location level. Transferring aggregated historical data to the internal bw of sap apo generating master data characteristics combinations and proportional factors configuring demand planning using planning areas, planning object structures, 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. Abap apo planning book macros on aggregated levels spider.
There are lot of opportunities from many reputed companies in the world. Open planning book data view, load a certain selection. In the previous article we learnt how to debug macros in apo planning book. This demo shows you some of the macro functions developped by our company dowap. A program subroutine pool will be created for each data view of the planning book in macro builder. Importance of demand planning sap apo demand planning terminology apo data structure. This component is also used for defining resource plan and order details. The interactive planning desktop in supply network planning snp is where you. How to trigger an event using apo planning book macro. Our next step is to look at macros, which are embedded in the planning book for. 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. For every macro which we create and activate, there will be macro id assigned and abap code will be generated for the same. Visit sap support portals sap notes and kba search. You use macro groups to restrict your selections in the macro workbench.
Hello, macro 1 hello, macro 2 hello, macro 3 macro examples sap scm apo. There are two sessions processing time series data from the same planning area planning version. In my case, there was a exit macro that was changing the data iu every bucket by. Highly configurable planning books with macro functionality.
Manage supply network planning in mysap scm sap apo pdf. Hi, there is no direct macro function to check planning book is change or display mode. Interactive solution for complex calculations in dp planning book using macro badis. A number of the macros are standard calculations that ship with apo. There are some instances when we want to be able to raise an event using an apo planning book macro. Now perform drill down to a certain characteristic.
However the performance may get affected by those macros. How to find the macro execution sequence in apo planning book. The problem is that when the user has changed these key figures a macro should run online. Most of the functions available are value functions, controlling the numbers or values stored within apo. Md04 display stock requirements situation, rsplan modeling bi integrated planning, rsa1 modeling.
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. I wanted a consolidated list of macros and to which planning book it belongs. In this planning book, therere complicated drill down and drill up macros to make sure the result for multiple planning objects is also consistent. Sap advanced planning and optimization how to trigger an event using apo planning book macro. In the attributes of the row, enter row attributes as the data source. Administration of demand planning and supply network planning maintain planning areas and planning object structure sapapotr32. After transport of planning book settings, some macro relevant problems are found in target system, e. Overview of demand planning concepts and data structures. In sap apo, production planning detailed scheduling ppds is used to generate procurement proposals to meet the production requirements.
Scm230 supply network planning aposnp sap training. Apo planning book macros on aggregated levels sap blogs. Display last deliveries if you want to use this function, you must. Our experts are passionate teachers who share their sound knowledge and rich experience with learners variety of tutorials and quiz interactive tutorials. Before data can be loaded into supply network planning.
Basically, we would find ans wers to the above two questions. Sap apo planning book pdf download demand planning with sap apo dp. 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. 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. 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. If you do this, the data is saved temporarily and the individual selections are locked for other users. Click more to access the full version on sap one support launchpad login required. 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. Knowledge in configuring planning area, planning books, data views and advanced macros. Oct 08, 2014 the planning book, therefore, is a preselection of characteristics and key figures. The function is not available if the compatibility mode is activated for the macro book. How to identify the key figure that was changed by the user onsap. In this article we would cover another practical use case in apo planning book. According to research sap apo has a market share of about 1.
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. 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. We will consider an example where an alert situation is highlighted when forecast. Jul 10, 2015 here are some examples of different macros with different functions used in sap apo. Test macro on planning book and here is the result in sapaposdp94 transaction. Generally, they can do just about everything you could do with abap code. This document is an excerpt from the complete scm 5.
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. Sap apo has been promised sap support through 2025. You can use auxiliary key figures with macros, for example. 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. 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. Sales order and shipment history data is loaded to cube and use the same for creating cvcs and define various macros to calculate forecast. Apo advanced macros webinar 1 use case control flow. The second step would be to define the macro in the relevant planning book data view for highlighting the alert situation. Fixing is the ability to lock the cells in a key figure. How to identify the badi name of the macro from planning book view. Download book 6, 274 kb as a courtesy to our readers the ebook is provided drmfree.
In my apo system there are around 40 planning books and 70 views. By pushing enter, the default macro will be triggered. Maintenance of demand planning book, master planning object structure, planning area and macros in the interactive demand planning. Interactive solution for complex calculations in dp. The components area shows macros that are active both for all data views in this planning book and for this. Abap apo planning book macros on aggregated levels. You will learn how to create demand plans using various forecasting techniques and how to apply marketing and sales intelligence to the demand plan. Reliable online sap ides for erp ecc for 7 days ibm doubles down on hybrid cloud.
It is written from a long years experience in implementation projects and aims to provide project managers and team. 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. Sep 26, 2014 original of article taken from my personal blog site at. Macro execution both foreground and background failed, or succeeded but calculation result is incorrect. February, 2004 this version is valid for sap apo 3. 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. Configuring supply network planning and interactive planning using planning books and macros. 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. Functionality you can use this method to change key figure values in a data view for a planning book. Perform complex calculations in planning book using macro badis. The badi will have the planning book data to play around. This way we can easily see values from product master in planning book. The requirement was to execute the macro always only per one productlocation. Sap can call you to discuss any questions you have.
Enhance supply chain management scm with sap advanced planning and optimization sap apo. 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. Is there any table from which i can get the name of macros in human readable form. As you can see below we have 35ku, basically 35k 35000pcs as a conversion factor. Refer to the following table to find the macro function of your choice. Home demand planning demand planning process planning book design advanced macros. Supply chain management is growing both as a research subject and as a crucial field of importance across organizations. Besides, promising sap apo consultants will find this course highly relevant. They are exclusively locking different set of cvcs. Previous next this solution offers integrated, bestinclass functionality for demand, supply, and production planning as well as global availabletopromise atp.
The tables sapapoadvm and sapapopbmadvm were partially helpfull. Here are some examples of different macros with different functions used in sap apo. Since documents will be disable in new scn, the content of this document is moved to wiki page sap. Sap was probably too optimistic or eager at showing its own way. Sap apo dp demand planning sample training content and overview.
169 1529 1185 466 780 24 564 294 924 1036 564 993 965 1137 837 7 246 1488 1545 1082 633 206 245 1072 688 78 1003 585 427