Hi FI Gurus,
I have the below requirement, need help on how to achieve this
I have extracted data from BSEG and BKPF tables to a BI tool and would like to generate a TB report. When summing the values, these should match with the FBL3N report. I am able to get the data and its matching with most of the accounts.
For a few accounts I am seeing differences, could you please let me know if I need to eliminate any of the records in BSEG and BKPF by using any field of the fields in them?
Note: I do not want to use the BSIS/BSAS tables as I am using the data from BSEG and BKPF for most of the reports.
I have mapped the amount by considering the debit/credit indicator. I would need to go into a drill-down detailed report and this is why i have chosen the BSEG table. So please suggest and advise.
Thanks