Expand Your Reporting Options with an Extended G/L Code Block

  • by Rohana Gunawardena, SAP Practice Director, Exium Inc.
  • April 1, 2013
The G/L code block in FI is not static. Customer-defined fields can be added to provide for reporting functions that SAP did not envision. Learn how to use a standard SAP transaction to add fields to the G/L code block, how to ensure that the field is properly populated, and how to report on the data once it is populated.
Key Concept
The G/L code block is composed of the company code, G/L account, cost center, profit center, and other commonly used fields to help identify and classify transactions. Sometimes the vast range of fields offered by SAP as standard may not fit a business requirement (e.g., the most suitable field is already used or a suitable field has SAP processes around it that make it too cumbersome to use). In these cases SAP provides the option to expand the standard code block with customer-defined fields. This functionality is little known, but can add great flexibility to FI reporting. The functionality is available in both the classic General Ledger and the SAP General Ledger (formerly known as the new G/L).

In the SAP General Ledger or classic General Ledger the code block comprises all the fields that can be used to identify or categorize a G/L posting (e.g., company code, account, business area, or profit center). Users most often come across the G/L code block when they enter FI line-item details using a transaction such as FB01. There is even a special G/L code block pop-up (Figure 1) that you can access by clicking the More button in line-item data entry.


Figure 1
Fields in the G/L code block

A full list of fields is in structure COBL, which can be displayed using transaction SE12. These fields represent a key component of G/L reporting. They also allow a great deal of flexibility in slice-and-dice reporting or providing alternative views of the same financial data. An additional way to view all the fields in the SAP standard code block is to expand the SAP Standard Account Assignments Node in transaction OXK3.

Why Extend the Code Block?

Extending the code block enables more detailed and flexible reporting of financial data. Consider these two business process examples.

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 2017 conference, June 14-16, 2017, in Amsterdam. For information on this event, click here.

See more by this author


Comments

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.