topic Re: Currency Fields in Application Development and Automation Discussions

Currency Fields

Former Member — Tue, 14 Feb 2006 18:58:40 GMT

Hi all,

In the creation of the ztable if I want to include a field which should hold currencies can you please explain me how to create domain,data element and what all should I specify when I include the field in the table.

Regards,

Varun.

Re: Currency Fields

Former Member — Tue, 14 Feb 2006 19:11:10 GMT

Hi Varun,

You want to create a new Domain and date element for Currency field.

USe T/code SE11-> Select radio button Domain

create domain ZDOMAIN assign Data type as 'CURR' . Define the No.of Charctes and decimal places.

USe T/code SE11-> Select radio button Ddata type :

create data element Zdataelem.

Please assign this domain to your custom dataelement ZDATAELEM.

USe T/code SE11~~> enter table name Ztab~~> change

Please assign this data element(ZELEM) to your currency field ZCURR in Ztable (ZTAB).

Then define a cureency key field in Ztable(ZTAB) as ZWEARS with data element as " WEARK".

Assign this Currency key field to your Currency field at Currency/Qty reference field as ZTAB-ZWEARS.

Please check VBAP-NETPR as an example.

Lanka

Re: Currency Fields

Former Member — Tue, 14 Feb 2006 19:15:52 GMT

while creating domain Data type is of type CUKY , while creating domain at the bottom of the screen give the value table as TCURC

u can give the name of domain while creating data element

give the check table as TCURC

Assign foreign key

u can check this in FILCT table field RTCUR

Re: Currency Fields

Former Member — Tue, 14 Feb 2006 19:25:36 GMT

Hi Varun,

You can create any currency field with the data element & a domain of any standard SAP field...or you can create a data element & domain,but make sure to give the reference field & currency key.

Re: Currency Fields

Former Member — Tue, 14 Feb 2006 19:43:49 GMT

Hi Varun

If you want to creat an amount field, you need to define:

- Domain: Data type ---> CURR

Position ---> Depend on the max amount you

need to store

decimals ---> Depend on how many decimals you

need (I suppose Two)

Anyway you can also use a std domain (see domains WERT*)

- Data Element: you have to assign the domain you've

created and insert the descriptions

When you use this domain for your field, you have to assign the reference field, it has to be a field for currency, you should choose in order the main of your amount field.

For example if your field mains an amount is in local currency the reference field should be T001-WAERS.

Remember the reference field is very important for input/output in the screens:

the system'll automatically convert the input/output format ofin amount order of the value of reference field.

Max