Application Development 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: 

Currency Field as a Key Field in Z Table

Former Member
0 Kudos
178

I am creating a z table in which i have to make a AMount field as a key field . But it is showing a warning while activating the table stating that "Key field AMTFR has num. type DEC: Buffering not possible, Transport restricted"

How can i clear this warning.

Thanks in advance

1 ACCEPTED SOLUTION

Former Member
0 Kudos
70

Doesn't sound like a good design to have a amount field as the key. Could you give us a background, why you are doing that?

Regards,

Ravi

4 REPLIES 4

Former Member
0 Kudos
71

Doesn't sound like a good design to have a amount field as the key. Could you give us a background, why you are doing that?

Regards,

Ravi

0 Kudos
70

The Table is for Calculating TAX based on the Amount Slab. Fields are

Amount from

Amount to

Valid from (date)

Valid to(DAte)

Add amount

REduce amount

In this i making first four fields as key fields which is giving a warning

0 Kudos
70

In this design I suggest you add one more field to the table called SLAB Code., which will be the key. You can have it as CHAR data type of whatever length you want.

That way its easy to handle, because tomorrow if the slabs change, you are changing the values of the key fields, this way you can avoid that.

You can probably have composite key of Slab code and validity dates.

Regards,

Ravi

Note - Please mark all the helpful answers

0 Kudos
70

Thank you