Customer Line item report with SEPA_DD mandate information
We are working in the implementation of the SEPA DD solution.
As a requirement by the business users, we are searchinfg for a report similar to the Customer Line item report (FBL5N) with SEPA_DD mandate information.
The idea is to check regulary the line item report in order to identify those invocies posted in the system with:
- SEPA DD Payment method.
- No valid mandate register in the customer master data.
Once identified those customers without a valid mandate, be on time to collect the mandates or alternatively changing the Payment Method.
Does anyone know how to do this? Do you know if SAP developed such a report?
The option to make a query is the one we planned but I found some dificulties. This is because the mandate information is stored in the table SEPA_MADATE. The referred table does not have the customer with the standard field KUNNR but with field SEPA_MANDATE-SND_ID.