Does the tenant pay a fee when making the transfer?

No, the SEPA transfer is free of charge for the tenant.