Skip to Content
Technical Articles
Author's profile photo S Abinath

Date / Day Wise Trial Balance in ECC – General Ledger

Introduction:

Standard SAP will allow to pick trial balance of any General Ledger based on period defined in system.  But there is a requirement from industry that it required date wise trial balance, and trial balance for the selected period it may be of any form.  Mixed period or week etc.,

Obtainable:

SAP has standard report F.08, F.01 and so on but all runs for a period defined in system.

Suggested ways to approach:

  • Can be tried based on Calendar reporting period field in special evaluation tab. But it’s doesn’t solve required purpose.
  • GRCT – installing FAGLFLEXA, coping FAGLFLEXT and proceeding with building report with posting date field. Creating report library using GRR1 – This also didn’t succeed because of performance Issue.
  • S_ALR_87012310 – didn’t match with GL balances.

Proposed Solution:

Creating a ‘Z’ Custom program and providing selection screen parameters/selection options as company code, F-Period, Date and GL if required can give Business Area.

By calling few function modules this can be obtained, G_GIVE_LEDGERS_FOR_GLT0 and reading BKPF / BSEG and perform calculations like  “glt0hslvt,  glt0hsl01, glt0hsl02 .
Below code to get FI_period for specified selection screen dates.

CALL FUNCTION 'FI_PERIOD_DETERMINE'                  
        EXPORTING i_budat = budat-high                
                  i_periv = t001-periv                 
                  i_monat = g_last_monat
        IMPORTING e_gjahr = bupej_high                  
                  e_monat = monat-high.      

Followed by this FAGL_GET_GLT0 helps to get business area wise report.

Loop result table and write coding according to requirement.

Screen shots:

Conclusion:

Tried with all possible approach to build this report and achieved the requirements screenshots attached for reference.

 

Regards,

Abinath Sivasankaran.

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo vishwanath vedula
      vishwanath vedula

      Good one.

      Author's profile photo Raghavendra Kanive
      Raghavendra Kanive

      Awsome post.. its helpful

      Author's profile photo Varkey George
      Varkey George

      Abinath,

      Great to know this possibility.

      Can we also consider to draw out a Trial Balance based on Business Place.

       

      K Varkey George

      Author's profile photo S Abinath
      S Abinath
      Blog Post Author

      Yes, In this output have two options ie., with business area or consolidated values, further to your requirement ie., Business Place wise is possible an abaper can help in same selection screen bring business place.

      By passing business place to J_1BT001WV and pick all plant assigned to that business place can be passed to T134G and get business Areas assigned to that particular business Place..

       

      Regards,

      Abinath

      Author's profile photo Fawad Tung
      Fawad Tung

      @abishankar

       

      But how the system would charge the depreciation, FCY and the A/R and A/P. For Example: we want to get Trail Balance as on 24 Jan 2022. Can we get this report?