Skip to Content
Technical Articles
Author's profile photo Praful Jain

Extension Ledgers in S/4 HANA

Hello All,

Will try to explain the concept of Extension ledger in comparision to standard ledger with my recent experiences of projects.

Extension ledgers are one of the powerful options that can be used for Management reporting. These ledgers staple the data on top of Standard ledgers,hence no data duplications as number of extension ledgers can point to 1 Standard ledger.There are 2 types of ledgers in SAP S/4 HANA:

  1. Standard Ledgers
  2. Extension Ledgers

Comparision of Standard Ledger and Extension Ledger:

                  Standard Ledger                  Extension Ledger
This is an independent ledger and standard ledger is an underlying ledger. The underlying ledger is a standard ledger.
Postings made to standard ledgers will only be reflected in standard ledger. Postings made to standard ledger will form part of reports of extension ledgers linked to standard ledger.
Total Balance = Balance in Standard Ledger

Total Balance = Balance in Standard Ledger +

Balance in Extension Ledger

Postings can be specifically made in standard ledger Postings can be specifically made in extension ledger
If you are on Classic GL and migrate to S/4 HANA, you cannot activate standard ledgers on day 1 (Subsequent activation of standard ledger is possible though) Extension Ledgers can be activated in S/4 HANA even if you were on classic GL in ECC.
Many Standard ledgers can be created to reporting Many Extension ledgers can be added on top of Standard ledger. (N:1 is possible)

 

When Extension ledgers can be activated?

  1. This can be activated in S/4 HANA.
  2. Unlike standard ledgers, Extension ledgers can be activated in S/4 HANA even if you were not on New-GL and not used Ledgers in ECC.
  3. Extension ledgers are non-disruptive, hence can be actived at any period of time.

Where is the data of Extension ledger stored?

  • It is stored in ACDOCA table only.
  • Postings made to standard ledger are not stored in extenstion ledger specifically.(below example will help you in better understanding)

Example: You have your standard ledger as 0L and Extension ledger as ZX .

  1. If you post a document to 0L. ACDOCA will be updated with ledger posting to 0L only, However when you try to extract reports like FAGLL03  for ledger ZX, all the postings of 0L+ZX will be calculated for balances.
  2. If you post a document to ZX. ACDOCA will be updated with ledger posting to ZX only,hence influencing the balances of ledger ZX.

Config: The setup of extension ledger is very simple.

 

I will try to update this blog with use cases for extension ledger. Happy to get some suggestions and use cases in comments.

 

Thanks

Praful Jain.

 

 

Assigned tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Manik Jain
      Manik Jain

      Hi Praful,

      Nice blog.

      It will be more useful if you can add use of Non-leading ledgers also!!

      Author's profile photo Praful Jain
      Praful Jain
      Blog Post Author

      Hi Manik,

      Thanks for your comments.

      Non-Leading ledgers and Leading ledgers form part of standard ledgers. You can append extension ledgers on any of the standard ledgers.

      Hope this explains.

      Thanks

      Praful

      Author's profile photo Marssel Vilaça
      Marssel Vilaça

      Thanks for sharing, Praful!

      I would add about Extension Ledger is that isn't available for Fixed Assets in Paralell Control, and the new release 1809 bring new types of this Ledger.

      Regards

      Marssel

      Author's profile photo Praful Jain
      Praful Jain
      Blog Post Author

      Hi Marssel,

      Thanks.

      Good point about Fixed assets, can you please point to new types of ledgers in 1809?

      Thanks

      Praful.

      Author's profile photo Gaurav Agarwal
      Gaurav Agarwal

      Good overview Praful!.

       

      New type of ledgers are prediction ledgers. Checkout my blog on that:

      https://blogs.sap.com/?p=731173

       

      Also simulation ledger concept not covered above, which is also a type of extension ledger.

      Author's profile photo Praful Jain
      Praful Jain
      Blog Post Author

      Thanks Gaurav.

      Have gone through your blog and its informative.

      However, unable to get through the simulation ledger, what will be the usecase for this.

       

      Thanks

      Praful.

      Author's profile photo Gaurav Agarwal
      Gaurav Agarwal

      Simulation ledger is right now released only for forex revaluation use case. There will be more use cases released by SAP in future for simulation ledger.

       

      Checkout below blog from Srinath Gogineni which explain the simulation ledger for forex valuation use case is very detailed manner:

      https://sapexperts.wispubs.com/financials/articles/how-to-use-the-extension-ledger-functionality-in-sap-s-4hana-finance?id=c1626ee98a864580b258870f123ce233#.XEMaMlwzbIU

      Author's profile photo Praful Jain
      Praful Jain
      Blog Post Author

      Thanks Gaurav

      Author's profile photo Philippe Gauthier
      Philippe Gauthier

      Hello Praful Jain

       

      Thanks Gaurav Agarwal about your input.

      There are some case, which extend ledger can't be used for a local requirement if it's based on leading ledger. For ie in France, there is one case we can't because extend ledger present all postings even CO, or we need to publish all posting booked in local ledger for legal authority.

       

      So choice to activate this approach versus to create a new ledger should take in consideration the legal localization and can have a major impact in the global architecture.

       

      Of course, the new features based on it are not created to answer topics on legal domain.

       

      Thanks for your blog

       

      Philippe

       

      Author's profile photo Zunaid Hingora
      Zunaid Hingora

      Hi Praful,

      Your blog is very very informative. Thank you. But i have one small doubt. Please guide. Inspite of having standard Ledgers, why we need extension ledger? Can you give some information on this please?

      Thanks in advance.

      Regards

      Zunaid

      Author's profile photo Praful Jain
      Praful Jain
      Blog Post Author

      Hi Zunaid,

      Extension ledger is needed as an adjustment ledgers or re-org of values of standard ledger . The main advantage is its ability to staple the values on top of standard ledger.

      The advantages include;

      • No data redundancy as it pulls all the data posted to its base ledger (standard Ledger)

       

      Thanks

      Author's profile photo Suba Rayudu Bendhanam
      Suba Rayudu Bendhanam

      Hi Praful,

       

      Thanks for your blog,

       

      I have a small drought on Extension ledger functionality.

       

      If i post a entry only for Extension ledger ,ACDOCA updates only Extension ledger docs  , if i look the report FAGLL03 by selecting extension ledger and Expense GL and company code i can see standard ledger(Historical ) as well as Extension ledger documents , if i choose B/S sheet GL i can see only Extension ledger document .

       

      Moreover it seems no Technical  difference b/w Non- Leading ledger and Extension ledger  as look like  both the ledgers functioning is same .

      Can any one help me with the technical difference b/w Non- leading and Extension ledger .

      Thanks,

      Subbu.

       

      Author's profile photo Praful Jain
      Praful Jain
      Blog Post Author

      Hi Subbu,

      Non Leading ledger is a standard ledger it means you need to specifically post to that ledger.

      In extension ledger even if you dont post in it, it pulls data from its linked standard ledger. You can add extension ledger on top of Non leading ledger but you cannot add non leading ledger on top of extension ledger.My example in blog can help you understand.

       

      Thanks

      Praful.

      Author's profile photo Rama Yengisetty
      Rama Yengisetty

      Hello Praful,

      Based on the information provided here, is there a possibility that Extension ledger is a replacement to the non-leading ledger? please elaborate.

      Thank you

      Ram

      Author's profile photo Torsten Heck
      Torsten Heck

      Hi Praful,

      nice blog, thanks!

      What´s about the integration to CO?

      I know, that the leading ledger is integrated. But is there also a way to transfer bookings from the extension ledger to CO? Or from a non-leading Ledger to CO?

      Thanks and best regards,

      Torsten

      Author's profile photo Jimmy Zhang
      Jimmy Zhang

      Thanks for sharing this.

      Author's profile photo Ankit Deshwal
      Ankit Deshwal

      Hi Praful,

       

      We have implemented the Extended Ledger for the sales Document and during invoice creation the entries are getting created and saved in ACDOCA.

      The way we see the actual ledger accounting document, we are not able to see the accounting document for Extended Ledger when we click on Accuouting button in VF03. Also, the accounting document is not getting updated in the Document flow.

       

      Can you please confirm if this is the standard functionality or I am missing anything?

      Author's profile photo Edwin Weijers
      Edwin Weijers

      For a customer we discovered that in S/4NANA 2020 it is possible to create an extension ledger on an extension ledger that is on s standard ledger. Creating the top extenion ledger the

      pfkey4 input options for the base ledger va;ues on;y show the standard ledgers. However when you ignore this and put in the extemsion ledger as the ase ledger for a 2nd extension ledger, the syste, accepts this.  It also works with ledger specific postings.

      for reporting ypi can report on:

      1. base ledger
      2. base ledger + extension ledger 1
      3. base ledger + extension ;edger 1 + extemsion ledger 2

      My customer has a requirement to report like that. i have never seen this stacked extension ledgers, but it seems to work.

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Can we just do this or are there any restrictions? How many extesion ledgers van be stacked?

       

      best regards, Edwin

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Author's profile photo Paulo Vitoriano
      Paulo Vitoriano

      Hi Praful,

      What would you think about having Extension Ledger for Accruals postings?

      Thank you,

      Paulo