Improve Your G/L Reporting by Summarizing Your Data

  • by Srihari Subramaniam, Manager, Capgemini US LLC
  • January 15, 2008
One of the key challenges for the summarization process is determining which field you need to use for summarization to achieve the best business impact. Understand various summarization levels, as well as process, configuration, and practical examples demonstrating when to use these summarization concepts.
Key Concept

You can optimize your FI document posting by properly summarizing the data so that your reports can run faster and allow for quicker response times. You can only summarize non-value (e.g., material number, unit of measure) fields. A value field, also known as an amount field (e.g., invoice amount, discount amount), is a sensitive field that you cannot modify. The system controls summarization so that you cannot summarize sensitive fields or lose data when summarization “blanks out” fields to make them identical.

An SAP system automatically generates FI documents for all interfaces from modules, such as Sales and Distribution (SD), Asset Accounting (FI-AA), Materials Management (MM), and Project Management (PM). When several fields of a line item have unique values, an accounting document may post multiple line items in the BSEG table and cause an unnecessarily large data set.

The goal of standard FI summarization is to condense this information and post single line items by summarizing non- value fields during integration from SD or MM to FI. If you are unfamiliar with summarization, see the sidebar, “Standard SAP FI Summarization,” or the article, “10 Best Practices for Designing Summarization Levels,” by Mitresh Kundalia.

Srihari Subramaniam

Srihari Subramaniam is an SAP manager at Capgemini US LLC, with 14 years of experience in SAP consulting. He has thorough knowledge in the integration of SD, MM, FI/CO, POS DM and PP. Srihari has worked in projects for industries such as high-tech manufacturing, telecommunications, chemical, retail (IS-R), and apparel.

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.