7 Steps to Configure Fiscal Weeks Right the First Time in SAP APO

  • by Manoj Ambardekar, Solution Architect
  • July 23, 2009
Learn how to avoid common errors in defining fiscal weeks when creating them in SAP ERP Central Component and then importing them to SAP Advanced Planning & Optimization. Examine the touch points of using the time bucket of fiscal week for the planning area, planning books, and supply network planning.
Key Concept
You can carry out demand and supply planning in different time buckets, such as calendar weeks, calendar months, or fiscal weeks. Unlike a calendar week, fiscal weeks can start on a day such as Saturday. It is critical to choose the right time bucket because the configuration setting has to remain consistent in the demand planning InfoCubes, planning areas, and planning books. Once you save data in the planning area, you cannot change the time bucket anymore.
With the advent of globalization, the era of central planning and local production has become a reality thanks to technology enablers such as SAP Advanced Planning & Optimization (SAP APO) and SAP ERP Central Component (SAP ECC). Global planners use SAP APO and SAP ECC to consolidate demand and supply across countries and across multiple business units within one country. This not only means that master data must be the same across the business units, but also that the time bucket for planning needs to be the same.

Let me give you an example of what I mean. Suppose all business units in one company need to use calendar weeks to consolidate demand and supply in their Sales & Operation Planning (S&OP) process. However, just like many other firms, they do not use calendar weeks starting on Monday. Instead, they use fiscal weeks starting on a Saturday or Sunday to have 52 or 53 fiscal weeks in a calendar year.

This is a real-life problem not just for my example firm, but for many companies across the globe. Some firms in countries such as India use a fiscal year starting on April 1. Other firms define a fiscal year in SAP ECC using 4-4-5 periods. This means that a year is split into 12 fiscal months and 4 quarters of 13 weeks each. Then each quarter has 4-4-5 weeks in the 1-2-3rd month of each quarter. As a result, using fiscal weeks can be complicated because you need to define fiscal variants and fiscal years into the future.

Manoj Ambardekar

Manoj Ambardekar has more than 20 years of IT and manufacturing experience with firms such as IBM, Infosys, PricewaterhouseCoopers, and Siemens Information in the CPG, brewing, and process industries. He has more than 14 years of experience with SAP APO and SAP ECC with specialization in logistics. He has played multiple roles as functional and technical lead as well as project manager. He has implemented SAP applications at more than 12 large- and medium-sized projects since 1998. Manoj is a chemical engineer certified in production and inventory management (CPIM) from APICS – USA, and holds a master’s of engineering (industrial) degree from B.I.T.S. in Pilani, India. Manoj works on both large and SME clients to implement SAP as both a configuration SME in APO/ECC PP-MM/Solution Manager and project manager/team lead. He specializes in supply chain management solutions using software such as SAP APO, SAP SCM, SAP ECC, SAP Solution Manager, and business intelligence for North American clients.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.