design a database table

[Former Member]

Guys i need to design a database table which takes in 2 currencies and gives the exchange rate like

eg from-field

to-field\

final rate..

Please suggest the exact fields required along with the reference keys.

Regards

Sushanth.

[Former Member]

hi,

in FROM EKKO table u can find the fields what u specified.

WAERS WAERS CUKY 5 0 Currency Key

WKURS WKURS DEC 9 5 Exchange Rate

[Former Member]

hi susanth,

check table EKKO, EKPO

thanks

Sachin

[Former Member]

Hi,

Check the ekko table and the following fields:

waers:- currency key

Wkurs:- exchange rate

Kufix:- fixing of exchange rate

Hope it will work.

Regards

Rajesh Kumar

[Former Member]

u need to design 3 fields......

[shadow]

Hi ,

check purchase order header detail table(ekko) ,u will get these fiels Kufix, waers ,Wkurs.....

Regard's

Shaik.

[Former Member]

Hi,

check fields WAERS :currency key,WKURS:Exchange rate,KUFIX: Fixing of exchange rate,KDATB:Start of validity period,

KDATE:end Start of validity period in EKKO

[Former Member]

hi,

u van use three fields ars type CURR

then create a fields for currency key as CUKY,then give this in the reference field of the currency fields

[JozsefSzikszai]

you should DB table TCURR, because it does exactly what you need.

[Former Member]

Hi,

Declare one currency field and currency key field. Go to currency/quantity fields and Maintain the reference table and reference field for that particular field. For further information you can go to the table TCURR. This may be help full to you.

Regards,

Rajani

[Former Member]

Hi,

Hope this may be helpfull,

WAERS-Currency Key

WKURS-Exchange Rate

These are the two fields which will help you from the table EKKO.

and the check table for WAERS is TCURC