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]

Hi Amlan,

thanks for the explaination.

The client's requirement is that if a sepa mandate in the source system has not been used in the last 3 years. SAP should not allow usage of this recurrent mandata Reference.

someone in the project thought it would be good idea to import the lastuse_date because SAP standard already checks this date and if older than 3 years will block the usage.

however, now we know that manuall update of this Feld generates problem. So we will try to solve the problem and requirement through "valid to" Field.

Thanks again.

Rashed