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.,
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.
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.