How to get report on short term loan taking from Banks

Hi Gurus,

My users requires "Fixed Deposit and Buyers credit linkage reports" which will save their time.Whenever they take short term loan from bank,the same time they open Fixed Deposit.

For Fixed deposit,i have created spl Gl indicator and calculating interest through SAP and then we make Z reports.

In Buyers credit,they require following data from SAP:

Name of bank

Bank ref no.

Message date

Value date

BC currency

BC amount(multiple currency)

BC due date

Rate of interest(two col:Libor+margin=Total interest)

No. of days

Rate of interest(two col:Libor+margin=total interest)

Interest payment date

Interest calculation

BC payment alongwith principal & interest

Forward amount in dollars

Spot rate

Bank margin

Forward premium

Net rate

Upfront fees,professional fees

Bank charges

Withholding tax

FRA Form(Forward rate agreement)

BC-Interest ref no.

FRA amount,FRA currency

Rate of interest period.

Pl advise BC matters only.

Regards,

Samar