Limitations of Pro Rata calculations in Money Market FSCM

[anastasia_medvedeva4]

Dear Experts,

would you be so kind to share experience, if you faced the same case:

Financial contract for rental/leasing/chartering:

1. Daily charge (amount) 1000USD

2. Periodicity of payment is not Daily, can be every 15 days, can be 1 month, can be quarterly, can be yearly

2.1 15 days option

2.2 1 month option

3. Comission with the opposite sign

Challenge is to find the best product type in FSCM brought me to Facilities in FSCM (category 560), there we copied standard 56A to specific product type 56C and customized flows for the Free Fee, which is not dependent on utilization of the Credit Line (Profile).

What is possible: define start&end dates, business partner, amount LS of the charge

What is the limitation: to be able to define the amount to be paid with the periodicity given (15 days or 1 month), user need to calculate out of SAP the Daily charge(1)*periodicity of payments (2) and insert the total amount in the flow field amount, then specify the periodicity and SAP with schedule all the flows till the end of the contract.

for the case 2.1 the condition will be 15000USD per each 15 days

for the case 2.2 the condition will be XXXXXUSD per 1 month, because every month is a different amount, which is based on the actual number of days in the month.

Workaround found: The total credit line should be set-up as daily charge*365 days and the Condition should be 100% for case 2.2 with periodicity 1 month, so the SAP will calculate correspondingly 31000usd per Jan, 28000 per Feb, and so on. For the case 2.1 15000usd should be inserted as Amount and periodicity 15 days.

Now, about the commission, it should be inserted as a Interest or LS, based on the total credit line per Year also, but with the sign "-", because condition charges in Facilities are dependent on the TT, so by nature, they are all negative (outgoing), and customizing in AT11 doesnt change this fact (already opened the incident, and got reply, that not possible to change defaulted value).

Disadvantages of the workaround:

1. There is no place to store the Daily charge amount, since it is not a base of the calculation by SAP standard conditions.

2. User has to calculate the amount of the payment based on the periodicity OUT of SAP for case 2.1, and the Monthly payment (point 2.2) will be looking like 100% charge, which is misleading.

3. User has to update the Total credit line depends on the Leap years, for the leap year it should be 366000usd, for the usual year, should be 365000usd.

Please, let me know, if somebody was able to find more elegant solution for the above mentioned conditions?

Thank you in advance,

Anastasia.