‎2012 Mar 31 7:54 AM
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!
‎2012 Mar 31 10:49 AM
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
‎2012 Mar 31 8:04 AM
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
‎2012 Mar 31 8:21 AM
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.
‎2012 Mar 31 9:48 AM
@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!
‎2012 Mar 31 10:25 AM
‎2012 Mar 31 10:49 AM
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
‎2012 Mar 31 11:18 AM