‎2007 Jun 05 2:35 PM
hi friends,
how can we restrict the entering of data for field in Table?????
Example is user has to enter the data only between values between 0 to 6.
how to do it?????????
‎2007 Jun 05 2:38 PM
Hi,
good question, u can restrict the values for a partcular field as follows:
In the DOMAIN for that field. Slecet VALUE RANGE TAB, then in the INTERVALS,
give LOWER LIMIT = 0 and UPPER = 6, provide some short text,
Then that particular field will be restricted between 0 & 6.
Revert back if any issues,
Reward with points if helpful.
Regards,
Naveen
‎2007 Jun 05 2:36 PM
Hi Subash,
In the domain under the value range tab you can give this interval (0-6).
Regards,
Vidya.
‎2007 Jun 05 2:38 PM
Hi,
good question, u can restrict the values for a partcular field as follows:
In the DOMAIN for that field. Slecet VALUE RANGE TAB, then in the INTERVALS,
give LOWER LIMIT = 0 and UPPER = 6, provide some short text,
Then that particular field will be restricted between 0 & 6.
Revert back if any issues,
Reward with points if helpful.
Regards,
Naveen
‎2007 Jun 05 2:39 PM
Hi,
You can try to maintain value table (0 to 6) at domain level.
Regards,
Ferry Lianto
‎2007 Jun 05 2:56 PM
even i given lower limit = 0 and upper limit = 6 but system is accepting all values.
how to solve these problem?????????
‎2007 Jun 05 3:00 PM
Hi
The Data type of that field should be NUMC.
Regards
Haritha.
‎2007 Jun 05 3:08 PM
even i tried with NUMC but it is accepting all values???????????
‎2007 Jun 05 3:21 PM
1) Have you re-activated both the domain and data element since you made the change? (It is easy to forget!)
2) This check only works on a screen field based on the data element, not when the field is set internally by ABAP code.
‎2007 Jun 05 3:27 PM
i done activation in both domain and in data element???
am entering the data at database table level......
it is taking all the values?????????
‎2007 Jun 05 4:03 PM
Hi Subash,
How are you entering data at the Database Table Level?
Via a dialog screen - you will find that you see a drop down list of values and you can't enter a value not in the list.
Via ABAP code direct - is your code something like...?
<i>WorkArea-Field</i> = 7.
...
INSERT <i>Table</i> FROM <i>Workarea</i>. "This command doesn't check the possible values
‎2007 Jun 11 8:32 AM
hi experts
what t code can help me to find pending i/r report ?
regards
subhendu chatterjee
‎2007 Jun 11 1:38 PM
hi subhash ...
i had gone thorugh the full conversation of this question ...see
i think you did not unerstood the domain value and value of limits.
it should be of char type ...and you can given the limit as
example
dataelement : sex
domain : sex type CHAR 1.
<b>
0 fish
1 chicken
2 muttom
3 frog
4 dog
5 men
6 women</b>
so that the sex is of type c the vaule range to user is 0 - 6 ... and the range gets it text .
Reward points if it is usefull ...
Girish