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

  • by Gaurav Aggarwal, Finance Specialist, Agilent Technologies
  • 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.

Note
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 Aggarwal

Gaurav Aggarwal is finance specialist at Agilent Technologies. Previously, he was a lead consultant at Infosys Limited. His has 13 years of experience, including 10 years in SAP FI and controlling (CO). He has expertise in both SAP FI and 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 implementation, rollouts, support, and upgrade projects.

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.