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: 

Table creation

Former Member
0 Kudos

Hi Friends,

I want a table field which accepts number upto '999999999999' and also accepts amount as negative or positive value, can any one please tell me what datatype or reference field I should take while creating a table.

Regards,

1 ACCEPTED SOLUTION

Former Member
0 Kudos

You can create a custom domain for the amount field, specify desired value for the field length. Create data element for this domain and use the same in your custom table.

7 REPLIES 7

Former Member
0 Kudos

You can create a custom domain for the amount field, specify desired value for the field length. Create data element for this domain and use the same in your custom table.

Former Member
0 Kudos

Hi,

You can use this data element: WKGXXX.

Or you can find others data element with Data Type Currency field that have SIGN.

Regards,

Former Member
0 Kudos

Hi,

Use data type CURR length 15 decimals 2.

You can also use the data element MAXBT.

Message was edited by:

Velangini Showry Maria Kumar Bandanadham

Former Member
0 Kudos

Hi Line,

You can use the data elements BREST, KAWRT...

or else create a data element using the domain WERTV8.

<b>Reward points if this helps,</b>

Kiran

0 Kudos

Hi,

What shall I take my dataclass and size catagory as this table will hold daily transactional data.

Regards,

Line

0 Kudos

Hi

Can I take any field type (already used in other tables) for creating a ztable.

Line

Former Member
0 Kudos

Hi,

For the negative value take the data type as INT4 which accepts negative and positive value.

Regards,