Why Can't I Find My G/L Account?

  • by Rohana Gunawardena, SAP Practice Director, Exium Inc.
  • November 15, 2004
R/3 stores G/L account numbers differently depending on whether they are stored internally or externally. This can cause problems when a user searches for G/L account data using transactions SE16 or SE17. The author explains conversion exits and their implications and also provides tips for user-friendly G/L account searches.
Key Concept
A conversion exit is a piece of ABAP code that translates data from an internal to an external format and vice versa. R/3 uses conversion exits to ensure consistent sorting and storage of data across multiple databases and languages. Conversion exit ALPHA is used for G/L accounts, cost elements, cost centers, asset numbers, customer numbers, vendor numbers, and other business objects.

Often, the way that R/3 stores data differs from the user's expectation of how data should appear. This difference can cause a lot of confusion to users, especially when they search for data.

Let's consider users who run a report for a range of G/L accounts: They want to select all of the loan accounts in the 140000 range using report RFSSLD00, G/L account balances. When they enter the range 140000 to 149999, they get all of the accounts they want (Figures 1 and 2). However, if they use the pattern 14*, then they find nothing (Figure 3).

Figure 1
RFSSLD00 selection with a G/L account range

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.