Skip to Content
0
Aug 18, 2020 at 10:58 AM

Bank movements details

138 Views

Hello Experts,

I was requested to find or create a report for bank account movent details. The selection criteria should be:

  • Bank account (house bank code or GL code)
  • Date range

The columns should be following

  • Date of movement (accounting date)
  • Amount
  • Debtor Invoice number
  • Debtor code
  • Debtor name
  • Creditor invoice number
  • Creditor code
  • Creditor name
  • Invoice date
  • Due date
  • Project
  • Profit center

The columns from Debtor invoice onwards should be populated only if relevant for that posting

I was not able to find any standard report for this so I try developing a custom one.

Unfortunatelly I struggle finding the right tables and joins to get the required data. So far I have found following

  1. Table BSIS - selecting by HKONT = bank account GL code and BUDAT in movement range date - getting GJAHR and BELNR - list of bank account movements
  2. Table BSAS - selecting GJAHR and BELNR from BSIS- getting AUGBL - clearing document
  3. Table BSAD - selecting GJAHR and AUGBL from BSAS excluding BSAD-BELNR = BSAS-BELNR - list of cleared debtor items
  4. Table BSAK selecting GJAHR and AUGBL from BSAS excluding BSAK-BELNR = BSAS-BELNR - list of cleared creditor items
  5. Getting and calculating the other fields (due, date, project, profit center) from BKPF and BSEG

It seems to work but I find the joins kind of hacky and I am not sure if that will work correctly with all edge cases. Is there some more straight forward approach how to get requested?