Bank movements details

[jiri_medved]

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?

[jiri_medved]

Hello Sanil,

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

Regards

Jiri

[sanilbhandari]

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

https://blogs.sap.com/2019/12/11/sap-s-4hana-cash-management-what-is-new-in-release-1909/

Thanks & regards

Sanil Bhandari