Date / Day Wise Trial Balance in ECC - General Ledger

[Abinathsiva]

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  "glt0-hslvt,  glt0-hsl01, glt0-hsl02 .
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.