Material Master History Tables
What Happens to Materials in Prior Periods?

  • by Rohana Gunawardena, SAP Practice Director, Exium Inc.
  • June 1, 2005
SAP R/3 4.5A stores previous period data for materials in new history tables. Learn how this change improves the MM period closing process and allows you the unprecedented opportunity to view historic material master data.
Key Concept
Starting with SAP R/3 Release 4.5A, SAP added functionality to save monthly history of the key material master tables. These material master history tables can be a useful source of information and can form the basis of custom reports to meet specific user requirements. Many SAP standard reports, such as RM07MMFI and FB5L, use these new history tables.
For most users, the change in the way R/3 Release 4.5A maintains material master history is transparent, because all SAP standard reports were changed. However, after Release 4.5A, when viewing data using SE16 or SE17, be aware that any fields marked as prior period or prior month do not contain valid values. If you have custom programs looking at historic material master data, you must make sure they follow the new logic.

I will give an overview of this critical change in the way R/3 stores material master history after Release 4.5A and explain how this affects you and your users. I'll also show how you can make this change work in your favor.

Rohana Gunawardena

Rohana Gunawardena heads the SAP practice division at Exium Inc. Exium is a leading business and technology consulting firm that enables companies to achieve their strategic business goals. Exium specializes in delivering superior IT solutions using ERP systems, with a special focus on SAP products. Rohana has been working with SAP since 1992. During his career he has assisted multiple clients on detailed system correction projects, such as correcting inventory balances, controlling area reorganizations, retrospectively activating group currency, and optimizing inter-company accounting transactions. He has spoken at many SAP conferences and has published more than 20 articles in Financials Expert, SCM Expert, and SAPtips on various aspects of SAP. His presentations have focused on Financials module selection, the order-to-cash process, global rollouts, business segment reporting, cross-module integration, and the financial impact of SCM transactions. Rohana is widely acknowledged as a leading SAP expert. Rohana is a Fellow of the Institute of Chartered Accountants in England & Wales. Previously Rohana has worked with the consulting practices of Accenture, Deloitte, and PwC.

Rohana will be presenting at the upcoming SAPinsider Financials 2018 conference October 16-18 in Prague. For information on the event, click here.

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.