topic Re: design a database table in Application Development and Automation Discussions

design a database table

Former Member — Fri, 09 Jan 2009 05:42:08 GMT

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.

Re: design a database table

Former Member — Fri, 09 Jan 2009 06:21:19 GMT

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

Re: design a database table

Former Member — Fri, 09 Jan 2009 06:35:38 GMT

hi susanth,

check table EKKO, EKPO

thanks

Sachin

Re: design a database table

Former Member — Mon, 12 Jan 2009 06:01:17 GMT

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

Re: design a database table

Former Member — Mon, 12 Jan 2009 06:48:09 GMT

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

Re: design a database table

shadow — Fri, 23 Jan 2009 04:51:34 GMT

Hi ,

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

Regard's

Shaik.

Re: design a database table

Former Member — Fri, 23 Jan 2009 05:05:39 GMT

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

Re: design a database table

Former Member — Fri, 23 Jan 2009 07:51:55 GMT

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

Re: design a database table

JozsefSzikszai — Fri, 23 Jan 2009 08:13:09 GMT

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

Re: design a database table

Former Member — Thu, 05 Feb 2009 04:52:08 GMT

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

Re: design a database table

Former Member — Thu, 05 Feb 2009 05:26:32 GMT

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