Table data element related

[mahesh_jagnani]

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.

[Former Member]

Hi!

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

Regards

Tamá

[mahesh_jagnani]

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,

[seshatalpasai_madala]

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

[mahesh_jagnani]

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

[seshatalpasai_madala]

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

[mahesh_jagnani]

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

[mahesh_jagnani]

can we restrict the range in domain level.

means define length as 4.

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

[seshatalpasai_madala]

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

[Former Member]

Hi,

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

Regards,

Vijay.

[mahesh_jagnani]

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,

[mahesh_jagnani]

can be controlled data entry at using sm30