Lastuse_date Field in the table SEPA_MANDATE is not updated after payment run?

[former_member268111]

Hello dear Supporters,

SAP suggests that after each payment run, the relevant mandate Reference is updated in the Table SEPA_MANDATE.

After a payment run the respective Mandate Reference is updated in the SEPA_MANDATE table but not the field "LASTUSE_DATE". This field should be updated so that the client knows when was this mandate reference last used. and in case the "lastuse_date" is older than 3 years, payment run should not allow usage of this mandat reference.

Any idea if this is configurable through customizing?

Release: EHP6 FOR SAP ERP 6.0

Service package: 21.

Regards,

Rashed popalzai

[former_member268111]

I should also say that we have another mirror system that is a copy of the system we use. There we didnt migrate new customers, all other configurations are same. and there we dont have a problem. I strongly believe that updating the "lastuse_date" alone in the table SEPA_MANDATE has cause the payment runs not to update this field anymore.

any ideas how to solve this? would updating the SEPA_MANDATE_USE Table too would solve the problem?

Thanks,

[AmlanBanerjee]

Rashed,

The SEPA_MANDATE_USE table, is updated after the FPY1 run and contains the Mandate Guid, date and the payment document no.

This table contains all the list of the payment documents that has been generated against the mandate.

During the FPY1 run, there are consistency checks on these two tables, and if they are not in sync it may lead to the failure of the FPY1 job. Check SAP Note 1888285 and 2160487 for your reference.

You can check the FM, SEPA_MANDATES_USE_DB_UPDATE as well.

Now for new customers who, there is no issue as the first payment run happens from SAP and table SEPA_MANDATE and SEPA_MANDATE_USE are updated asynchronously during FPY1 run.

My recommendation would be to migrate the legacy mandates without the last use date in SAP.

This infers you treat them as a new mandate in SAP and during the first FPY1 run, SAP updates the last use date.

Thanks,

Amlan