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
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: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
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |