Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem while creating with CURR data type fields

Former Member
0 Likes
4,437

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!

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
2,594

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

6 REPLIES 6
Read only

Former Member
0 Likes
2,594

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

Read only

koolspy_ultimate
Active Contributor
0 Likes
2,594

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.

Read only

Former Member
0 Likes
2,594

@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!

Read only

former_member189779
Active Contributor
0 Likes
2,594

Have you tried..

Read only

Former Member
0 Likes
2,595

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

Read only

Former Member
0 Likes
2,594

You are right. Its working!!!!!