Sap apo locked planning book macros

Enhance supply chain management scm with sap advanced planning and optimization sap apo. Manage supply network planning in mysap scm sap apo pdf. Planning book maintenance sap library planning area. You will gain an indepth understanding of how demand plans with sap apo are created based on historical data.

Refer to the following table to find the macro function of your choice. How to identify the badi name of the macro from planning. Test macro on planning book open planning book data view, load a certain selection. In the attributes of the row, enter row attributes as the data source.

If you do this, the data is saved temporarily and the individual selections are locked for other users. 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. Administration of demand planning and supply network planning maintain planning areas and planning object structure sapapotr32. The components area shows macros that are active both for all data views in this planning book and for this. The badi will have the planning book data to play around. In the previous article we learnt how to debug macros in apo planning book. Sap apo planning book pdf download demand planning with sap apo dp. How to identify the badi name of the macro from planning book view. How to identify the key figure that was changed by the user onsap.

Importance of demand planning sap apo demand planning terminology apo data structure. Demand planning with sap apo concepts and design paperback. Now perform drill down to a certain characteristic. 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. 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. Sap apo has been promised sap support through 2025. 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. I wanted a consolidated list of macros and to which planning book it belongs. 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.

How to find the macro execution sequence in apo planning book. You can also plan for critical products to reduce the lead time and to improve time delivery performance. In my apo system there are around 40 planning books and 70 views. 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. I understand as per standard apo, it is possible to change \time bucket profile\ when \period s.

It is written from a long years experience in implementation projects and aims to provide project managers and team. Macro value from product master in planning book sap. As you can see below we have 35ku, basically 35k 35000pcs as a conversion factor. The function is not available if the compatibility mode is activated for the macro book. This way we can easily see values from product master in planning book. 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. Supply chain management is growing both as a research subject and as a crucial field of importance across organizations. Basically, we would find ans wers to the above two questions. Hi, there is no direct macro function to check planning book is change or display mode. We will consider an example where an alert situation is highlighted when forecast. 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. Fixing of key figure in planning book in sap apo youtube.

Generally, they can do just about everything you could do with abap code. The advanced planner course has been developed for the sap end users and it analysts. There are two sessions processing time series data from the same planning area planning version. Interactive solution for complex calculations in dp. Interactive solution for complex calculations in dp planning book using macro badis. How to trigger an event using apo planning book macro. 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. Macro execution both foreground and background failed, or succeeded but calculation result is incorrect.

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. Planning book open planning book data view, load a certain selection. Open planning book data view, load a certain selection. Test macro on planning book and here is the result in sapaposdp94 transaction. 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. This video explains sap apo users as how to fix the key figure values in planning book. Sap apo dp demand planning sample training content and overview. Scm230 supply network planning aposnp sap training.

I created a planning book and data view with followi. Abap apo planning book macros on aggregated levels. 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. Jul 10, 2015 here are some examples of different macros with different functions used in sap apo. For example, the abc technology demand planner locks the current. Functionality you can use this method to change key figure values in a data view for a planning book. Here are some examples of different macros with different functions used in sap apo.

Download book 6, 274 kb as a courtesy to our readers the ebook is provided drmfree. In this planning book, therere complicated drill down and drill up macros to make sure the result for multiple planning objects is also consistent. The advanced planner and optimiser sap apo tm is the software from sap dedicated to supply chain management. Before data can be loaded into supply network planning. How to identify the badi name of the macro from planning book. Key figures are the rows that populate planning books in apo. In this article we would cover another practical use case in apo planning book. 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 dpsnpppds functional team member resume hire it people. The interactive planning desktop in supply network planning snp is where you. Sales order and shipment history data is loaded to cube and use the same for creating cvcs and define various macros to calculate forecast. Previous next this solution offers integrated, bestinclass functionality for demand, supply, and production planning as well as global availabletopromise atp.

Macro execution sequence along with data in sap apo. According to research sap apo has a market share of about 1. Imagedata in this kba is from sap internal systems, sample data, or demo systems. Our experts are passionate teachers who share their sound knowledge and rich experience with learners variety of tutorials and quiz interactive tutorials. 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. Display last deliveries if you want to use this function, you must. Visit sap support portals sap notes and kba search. You use macro groups to restrict your selections in the macro workbench.

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. Sap resume st louis, mo hire it people we get it done. 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. Click more to access the full version on sap one support launchpad login required. The second step would be to define the macro in the relevant planning book data view for highlighting the alert situation. Highly configurable planning books with macro functionality. This component is also used for defining resource plan and order details. February, 2004 this version is valid for sap apo 3. The problem is that when the user has changed these key figures a macro should run online. At a high level, apo is used for longterm planning. Apo planning book macros on aggregated levels sap blogs. Write batch planning books with minimal rows and macros for the mass job. 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. They are exclusively locking different set of cvcs.

Sap was probably too optimistic or eager at showing its own way. Knowledge in configuring planning area, planning books, data views and advanced macros. The tables sapapoadvm and sapapopbmadvm were partially helpfull. This document is an excerpt from the complete scm 5. Sep 26, 2014 original of article taken from my personal blog site at. Overview of demand planning concepts and data structures. Sap library supply network planning run sap help portal. One or some macros of the corresponding planning book or data views are found to be in inactive deactivated status red light. Configuring the administrator workbench and the planning area, master data, planning books, advanced macros. Fixing is the ability to lock the cells in a key figure. You will learn how to create demand plans using various forecasting techniques and how to apply marketing and sales intelligence to the demand plan.

Home demand planning demand planning process planning book design advanced macros. Sap can call you to discuss any questions you have. What that means is that they will work on break fixes and some functional enhancements but nothing revolutionary. Configuring supply network planning and interactive planning using planning books and macros. You can use auxiliary key figures with macros, for example. Overview of supply chain planning in sap scm apo, integration with demand planning dp and production planning ppds. 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. In my case, there was a exit macro that was changing the data iu every bucket by. You use this function to find macros books and individual macros that contain the following. Reliable online sap ides for erp ecc for 7 days ibm doubles down on hybrid cloud. 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. 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. After transport of planning book settings, some macro relevant problems are found in target system, e. Maintenance of demand planning book, master planning object structure, planning area and macros in the interactive demand planning.

Jul 10, 2003 unleash the power of macros in abap by rehan zaidi in developer on july 10, 2003, 12. Most of the functions available are value functions, controlling the numbers or values stored within apo. In sap apo, production planning detailed scheduling ppds is used to generate procurement proposals to meet the production requirements. By pushing enter, the default macro will be triggered. This book provides an overview about the supported scm processes and explains how to implement sap apo tm in a company. They are powerfull and allow you to improve a lot user experience in apo dp and snp. The planning areas you are using such as 9asnp01 or 9asnp02 determine which key figures are transferred to your planning book. 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. Since documents will be disable in new scn, the content of this document is moved to wiki page sap. Besides, promising sap apo consultants will find this course highly relevant.

Sap advanced planning and optimization how to trigger an event using apo planning book macro. Abap apo planning book macros on aggregated levels spider. Source systems, infoobjectscatalogs and infocubes planning components like planning area, maser planning object structure mpos, planning books and macros various forecasting methods such as. Since you generally choose enter when entering values, sap recommends that you use macros with this. This paper provides a detailed step by step procedure for implementing the alert monitor and macro. Perform complex calculations in planning book using macro badis. Calculations in dp planning book using macro badis. The requirement was to execute the macro always only per one productlocation. This demo shows you some of the macro functions developped by our company dowap. Our next step is to look at macros, which are embedded in the planning book for. Md04 display stock requirements situation, rsplan modeling bi integrated planning, rsa1 modeling. Sap apo planning books for the short horizon to better reflect market demand situa. A program subroutine pool will be created for each data view of the planning book in macro builder. Is there any table from which i can get the name of macros in human readable form.

How intuitive is interactive planning book sdp94 from apo. Oct 08, 2014 the planning book, therefore, is a preselection of characteristics and key figures. Change of time bucket profile within planning book sap. Sap apo supply planning supply planning heuristic, deployment, tlb, ppds planning, demand planning, core interface. 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. People working as a business analyst, sap mm or pp consultant or demand and planning professionals can greatly benefit from the course. Since you generally choose enter when entering values, sap recommends that you use macros with this functions as default macros.

Input some value to a certain cell into key figure additional field 5, and press enter. Apo advanced macros webinar 1 use case control flow. A number of the macros are standard calculations that ship with apo. Implementing the alert monitor functionality using macro. 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.

For every macro which we create and activate, there will be macro id assigned and abap code will be generated for the same. Once we cover the planning book we will get into detail on sap 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. Data views control the layout of the planning table and are the snp planners most important tool for analyzing, modifying, and creating planning data. At present the user exit macro calculates the values properly and also gets them properly in the planning view of the interactive planning transaction. There are lot of opportunities from many reputed companies in the world.

However the performance may get affected by those macros. Hello, macro 1 hello, macro 2 hello, macro 3 macro examples sap scm apo. The purpose of this document is to provide us with a detailed read more. Todays topic is trouble shooting apo planning book macros. In planning book we need to load this material at detailed level that is material and location level. Sap advanced planning and optimization archives page 2 of 9. There are some instances when we want to be able to raise an event using an apo planning book macro.

188 701 1444 1314 1134 810 1024 765 303 1375 306 1271 203 22 598 260 961 798 669 827 904 771 108 292 1085 1363 419 929 1174 636 424 1433 1156 1137