Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Customer Line item report with SEPA_DD mandate information

Hi,

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.

Kind regards

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question