topic Re: Table data element related in Application Development and Automation Discussions

Table data element related

mahesh_jagnani — Tue, 28 Aug 2007 10:47:39 GMT

Hi ,

i want to create one field in table which must contain value range between -1000 to 1000 through SM30. i will have to do some arithmatic operation on it through another program.what type of domain i should define while creating table.can u plz tell me.

Re: Table data element related

Former Member — Tue, 28 Aug 2007 10:50:22 GMT

Hi!

Your domain can be INT4, NUMC(5) or DEC types.

Regards

Tamá

Re: Table data element related

Former Member — Tue, 28 Aug 2007 11:20:24 GMT

Hi,

You can use the Data type as NUMC4, so that you can make calculations on it.

Regards,

Vijay.

Re: Table data element related

mahesh_jagnani — Tue, 28 Aug 2007 12:10:54 GMT

i want to restict the user so he only enter value between -1000 and 1000 through SM30.So in domain itself i want to declare value range -1000 to 1000.With numc4 it is not possible .system tells only positive is possibe with numc.

CHAR i can not taken because it will create problem in calculation.

plz tell appropriate solution,

Re: Table data element related

mahesh_jagnani — Tue, 28 Aug 2007 12:11:22 GMT

CHAR i can not taken because it will create problem in calculation.

plz tell appropriate solution,

Re: Table data element related

seshatalpasai_madala — Tue, 28 Aug 2007 12:27:43 GMT

Hi,

Create a DOMAIN in SE11 as follows

1) SE11->Domain->Create->Enter domain name

2) Use the TYPE 'DEC'.

3) Enter the Length as 3

4) Click the checkbox "Sign".

Now you have a DOmain of range -999 to 999.

Regards,

Sesh

Re: Table data element related

mahesh_jagnani — Tue, 28 Aug 2007 12:51:21 GMT

thanks but i want to include -1000 as well as 1000 in that field .here only between -999 and 999 will be allowed.

Re: Table data element related

seshatalpasai_madala — Tue, 28 Aug 2007 12:54:47 GMT

Hi,

If you want to restrict at the domain Level, Itsn ot possible to restrict to -1000 to 1000.

As at the domain level you will give the length and the length can be 3 or 4, if you give 3 it will be -999 to 999 and if you 4 it will be -9999 to 9999. So -1000 to 1000 is not possible at the domain Level.

Regards,

Sesh

Re: Table data element related

mahesh_jagnani — Tue, 28 Aug 2007 13:02:00 GMT

that true but one more option is provided in domain that is value range .can we do it through value range.

Re: Table data element related

mahesh_jagnani — Tue, 28 Aug 2007 13:08:48 GMT

can we restrict the range in domain level.

means define length as 4.

now resrict from -9999 to -1001 and from 9999 to 1001

Re: Table data element related

seshatalpasai_madala — Tue, 28 Aug 2007 13:13:47 GMT

Hi,

Yes you can try giving the INTERVAL under the value range tab.

Try giving -1000 and 1000 and use DEC and length 5.

But you will get an error at the time of Activation.

Saying -ve valus cannot be used in interval.

Regards

Sesh

Re: Table data element related

mahesh_jagnani — Fri, 31 Aug 2007 05:50:58 GMT

can be controlled data entry at using sm30