Demystifying Document Splitting in New GL in SAP #0 Index

Demystifying Document Splitting in New GL in SAP #0 Index

Document Splitting is a very powerful feature delivered by SAP ECC.

Before SAP ECC, if new fields were required to GLT0 table,SAP had to design a new Special Purpose Ledger table. For example, when SAP wanted to add Profit Centre to GLT0 it created a new set of Special Purpose Ledger table 8* and a new module Profit Center Accounting. The design was for  results to be copied from GLT0 to special ledger tables and the new field Profit Centre derived within Special Ledger so Profit Centre could be reported upon existing data posted in GLT0. . However, technical glitches in code and incorrect usage of functionalities caused imbalances between the main ledger GLT0 and the Special Purpose Ledgers.

SAP customers who wanted to expand the functionality of the General Ledger to cater to special business requirements had to create custom Special Purpose Ledger tables. For example, if a customer wanted to report by two fiscal year variants, they could report one variant using the General Ledger and the other variant using a custom Special Purpose Ledger.

All these disparate ledgers reported the same source information with different views. Customers had to execute several month end jobs to ensure synchronisation of data across all these ledgers. Additional month end jobs, differences in balances and information between ledgers led to delays in month end closing and reporting.

With SAP ECC new GL, SAP Customers can add new fields (which SAP calls “scenarios”) into the main General Ledger. This allows customers to do, for example, Profit Centre Reporting within the General Ledger.

With SAP ECC new GL, SAP Customers can add new ledgers (which SAP calls “parallel accounting”) into the General Ledger. This allows customers to report, for example, the same General Ledger data in multiple fiscal year variants.

This reflection of data happens in real-time. SAP customers no longer need to execute month end jobs to synchronise data between different ledgers.

This blog is an index to a series of blogs I have written on Document Splitting. In these blogs, I intend to give an overview of the features of new GL and document splitting; give examples of how document splitting works in different scenarios; the design behind document splitting; and the configuration settings for document splitting.

For simplicity, I have used Profit Centre as the “scenario” for document splitting in all the blogs. What applies to Profit Centre, applies similarly to all other scenarios.

I hope the blogs will help understand the design and configuration of document splitting. Please do leave your comments/ suggestions / experiences in the comments section of the blogs.

If you liked this blog, do click on your social media icon on the blog page and share it with your network. You could subscribe to this blog using the rss icon on the top right of this page.

Index of blogs on Document Splitting

#1  Overview of new GL Document Splitting Process

#2  Architecture of SAP new GL

#3  The Design driving the new GL Document Splitting process

#4  SAP delivered pre-configuration for document splitting in SAP new GL

#5  The semantics of SAP new GL document splitting process

#6 Set up Zero-balancing for SAP new GL

#7 Customise Document Splitting rules

#8 Use Constants for Nonassigned Processes in SAP new GL

#9 Customise cross company code postings for document splitting

#10  Document Splitting in Cross company code vendor payment

 

View my presentation on slideshare

_____________________________________________________________________________________________________________________________

Rajesh has implemented new GL and Document Splitting for several customers. Rajesh has 12 years experience implementing SAP / IT / BPM Finance solutions for several customers globally; he also has 7 years experience working in the business in Finance and Accounting functions. His business process knowledge combined with his IT expertise enables him to provide his customers with best-of-breed advise on business process / IT implementations.

View Rajesh Shanbhag's profile on LinkedIn

 

Comments

  1. Hi,Rajesh, very useful research on SAP new gl functionality.
    I have a question:In the article<Document Splitting in New GL in SAP #7 Customise Document Splitting rules?,in the configuration base item catogory, you didn't tick automatic split, what did it mean?

    • Hi Tony

      Automatically split is meant for item categories that are split internally by SAP that are used as a basis for split on subsequent processes. I will explain this process in detail in a subsequent blog – when you perform a clearing (“Subsequent Process” in Document Splitting) and that process triggers an additional adjustment posting that posting can split based on the cleared line items (which in turn have derived the split from previous process). This indicator is generally used in Business Transaction 1010 (Clearing Transaction).

      Regards

      Rajesh

Leave a Reply

CommentLuv badge