Showing results for 
Search instead for 
Did you mean: 

Bank movements details

0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hello Sanil,

I should have mentioned that I need a solution for R/3.



Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello jiri.medved

You might want to look at SAP Cash Management functionality, which is part of S/4HANA under FSCM. It has all the functionality on managing cash and probably more

Thanks & regards

Sanil Bhandari