List payments by cash management group

[Former Member]

Hello,

It's my first post on this community, hoping that will not be the last one .

I have to make a report that indicate the amount of payment by month and by cash management group.

For that I'm looking in the table BSAK with the clearing date 'AUGDT' of my month, and I go after in BSEG to have the cash management group 'FDGRP'. This method give me a correct result, but performances tests of this report are very poor. So my question is about finding another method to get theses informations, another table where I can find the two informations (Clearing date + Cash Management Group)?

Thanks a lot for your help,

Best Regards,

Laurent

[former_member251898]

Hello,

Another option would be to use FBL1N Vendor line item display but need to add FDGRP field in Dynamic selection so as to be able to filter the paid items for Logical data base KDF. You need to look at OSS note 310886 to add the field. I hope that this works out for you to meet the requirement.

Alternatively, you could even look at using REGUP and REGUH and linked up with BSEG.

Cheers

Taro