topic Re: Table creation in Application Development and Automation Discussions

Table creation

Former Member — Tue, 25 Sep 2007 05:36:32 GMT

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,

Re: Table creation

Former Member — Tue, 25 Sep 2007 05:41:10 GMT

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.

Re: Table creation

Former Member — Tue, 25 Sep 2007 05:42:12 GMT

Hi,

You can use this data element: WKGXXX.

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

Regards,

Re: Table creation

Former Member — Tue, 25 Sep 2007 05:43:39 GMT

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

Re: Table creation

Former Member — Tue, 25 Sep 2007 05:46:24 GMT

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

Re: Table creation

Former Member — Tue, 25 Sep 2007 05:57:57 GMT

Hi,

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

Regards,

Line

Re: Table creation

Former Member — Tue, 25 Sep 2007 06:18:52 GMT

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

Line

Re: Table creation

Former Member — Wed, 26 Sep 2007 07:17:12 GMT

Hi,

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

Regards,