Skip to Content
1
May 22, 2020 at 05:58 PM

Reg data from BSEG to match with FB3LN

718 Views Last edit May 25, 2020 at 11:58 PM 3 rev

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