Currency field

[Former Member]

I have question with refernce to the currency fields.

I want to define a Z* table which has 3 key fields which are all 'character' type and also have 4 data fields which is numeric, i have defined them as 'CURR' type .

Character fields:

MATERIAL

PLANT

ORDER

Numeric fields - CURR type

z_process_value1

z_process_value2

now my question is do i need to define an additional field

CURRENCY with type 'CUKY'

because my numeric type fields is refering to CURR type.

any help on this is appreciated, points will be assigned to relevant answers.

thanks

Priya

[Former Member]

I have question with refernce to the currency fields.

I want to define a Z* table which has 3 key fields which are all 'character' type and also have 4 data fields which is numeric, i have defined them as 'CURR' type .

Character fields:

MATERIAL

PLANT

ORDER

Numeric fields - CURR type

z_process_value1

z_process_value2

now my question is do i need to define an additional field

CURRENCY with type 'CUKY'

because my numeric type fields is refering to CURR type.

any help on this is appreciated, points will be assigned to relevant answers.

thanks

Priya

[Former Member]

You don't have to. But you will have to assign a reference field for your currency fields. They can be from a differernt table.

Rob

[Former Member]

can you please give me a example

[Former Member]

in se11 tcode when you are displaying a table there one tab you can find currency/quantity field. Click on that tab and give the rference field name and table name for your currency field thats enough.

i.e. reference field WAERS ref table EKKO. like that.

regards

shiba dutta

[Former Member]

Hi ,

First define CUKY field, then assign this field to REFRENCE FIELD and REFERANCE TABLE(sam etable) .

Ex:

Name of table : ztab

field Datatype Refe Field Ref table

keyfld1

Keyfld2

Keyfld3

fld4 CUKY

fld5 CURR fld4 ZTAB

Rvert back if any issues,

Rewrad with points if helpful.

regards,

Naveen

Message was edited by:

Naveen Deva

[Former Member]

For example:

Table BSET, field HWBAS (a currency field) has T001-WAERS as the reference table and field.

Rob

[KN-Nampoothiry]

Hi Priya,

For all fields that are currency / quantity we need to specify the referance field as the value solely doesn't serve any purpose.

eg. Rs.100 stored as 100 makes no sense or 100 Kg stored as 100. So we specify the reference field in the tab 'Currency/Quantity Fields'.

When you go to tab they would be open already for input if you have specified them as any curr / qty type...i beleive it won't let you activate the table without these..

Anyways i hope this clears the need for a referance field like waers etc for Curr.

<i><b>Reward if useful in understanding/solving/</b></i>

[Former Member]

hi priya,

for every currency field u need to define a CUKY field. i guess u go that part right?

now u need to click on currency/quantities tab and in the reference table column of ur CURR field u need to type the name of ur ztable. and in the ref field u can type WAERK.

now go back to FIELDS tab and create a new field with field name as WAERK, data element as WAERK and data type as CUKY.

this shud solve the issue for u.

regards,

pk

[Former Member]

This message was moderated.