How to Extend the G/L Code Block in the Reporting Framework for a Live Organization

  • by Gaurav Agarwal, Principal Consultant, SAP S/4HANA Finance, Infosys Limited
  • August 21, 2015
Learn the special steps involved for implementing general ledger (G/L) code block enhancement in a live organization that uses transactional data.
Learning Objectives

By reading this article, you’ll learn:

  • The objects to be retrofitted for customer-defined fields in general ledger (G/L) code block
  • Various tools to perform the historic data retrofit for the new field(s)
  • Cautions and special considerations to keep in mind during the data retrofit
Key Concept

According to Rohana Gunawardena’s article “Expand Your Reporting Options with an Extended G/L Code Block,” the “code block comprises all the fields that can be used to identify or categorize a general ledger (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.”

Organizations are always striving to find different options to have better and more flexible reporting of transactional data. Extending the standard SAP General Ledger code block for new customer-defined fields provides you with the option to enhance the reporting by entering specific data in those new fields. However, it is tricky to apply such new fields when the organization is already live and has a lot of transactional data.

Financial reporting is one of the main reasons why the SAP ERP Financials module exists, and generating financial reports accurately and flexibly is the prime objective in every organization. SAP has built in many reporting dimensions in the standard SAP ERP Financials solution (e.g., company code, plant, G/L account, cost center, profit center, internal order, segment, business area, and functional area). However, sometimes these dimensions are not sufficient and need enhancement for two reasons:

  • The new reporting dimension need could not be met by any standard reporting dimension.
  • The new reporting need can be met by a standard SAP reporting dimension, but that standard SAP dimension is already in use for other reporting purposes.

In such cases, you need to extend the standard G/L code block for new customer-defined fields. I focus on helping you understand different special steps involved in such G/L code block change in a live organization with historic transactional data.

Rohana Gunawardena’s video demonstration “Extend the G/L Code Block with an Additional Field,” covers the extending G/L code block concept. This video complements the content in his Financial Experts article “Expand Your Reporting Options with an Extended G/L Code Block.”

Table 1 shows a summary of the various steps involved in activating a new field in the G/L code block.

Table 1
Some of the steps for activating a new field in the G/L code block

Gaurav Agarwal

Gaurav Aggarwal is SAP S/4HANA lead consultant at Infosys Limited. He has more than 14 years of experience, including 11 years in SAP Finance. He has expertise in both SAP FI and Controlling (CO) with integration to other modules in manufacturing and process industries. He is a chartered accountant and SAP Certified Financial Consultant. He holds a bachelor’s degree in commerce and is a techno-functional expert with thorough knowledge of the necessary ABAP for functional experts. He is a veteran in G/L, AR, AP, banking, FA, Travel Management, and closing cockpit and has handled greenfield implementation, upgrades and conversions, rollouts, and support projects.

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.