topic Re: Problem while creating with CURR data type fields in Application Development and Automation Discussions

Problem while creating with CURR data type fields

Former Member — Sat, 31 Mar 2012 06:54:04 GMT

I'm trying to create a User defined table with Currency fields, which needs REFERRENCE TABLE and Referrence Fields. i found a field RWBRT of PAYR table which matches my field's datatype. but when i use them as referrence and try to activate the table, i get an error "combination does not exist for Referrence table/field".

Please help me.

Thanks in Advance!

Re: Problem while creating with CURR data type fields

Former Member — Sat, 31 Mar 2012 07:04:11 GMT

use PAYR-RWBTR for referene field. or make ur own currency field say CF in your table ZTABLE and use ZTABLE-CF as reference field.

Message was edited by: VIKAS CHANDRA

Re: Problem while creating with CURR data type fields

koolspy_ultimate — Sat, 31 Mar 2012 07:21:04 GMT

Hi you need to enter the reference table and field for that currency data type.

Just open your ztable and click on currency/quantity fields and in the reference table column adjacent to your currency field just enter VBRK and in the Ref. field column enter waerk.

Now save and activate your tables.

Regards,

koolspy.

Re: Problem while creating with CURR data type fields

Former Member — Sat, 31 Mar 2012 08:48:12 GMT

@VIKAS CHANDRA, not helpful !!!

@Madhumahesh T, WAERK is not CURR field, it is a CUKY.

And misspelled last time, it is RWBTR of PAYR. Still i didnt get clue!

Re: Problem while creating with CURR data type fields

former_member189779 — Sat, 31 Mar 2012 09:25:25 GMT

Have you tried..

Re: Problem while creating with CURR data type fields

Former Member — Sat, 31 Mar 2012 09:49:17 GMT

hi partibhan.... u are doing mistake.. whenever we crate a currency field we have to provide two fields-

Reference field- It is field of CURRENCY KEY(CUKY) type not CURRENCY TYPE(CURR).

Reference table- table containing reference field.

So in your case case u are providing RWBTR which is field of type CURR. look in that table once again and find the reference field of type CUKY. OR as i said you can make an extra field of type CUKY and give this as reference field and your table as reference table.

please reward if useful.

thanks

Re: Problem while creating with CURR data type fields

Former Member — Sat, 31 Mar 2012 10:18:03 GMT

You are right. Its working!!!!!