on 10-05-2010 4:32 PM
On a form, we noticed a dynamic entry list will limit which values a user may enter by validating against the entry list values. We need to have the same validation occur when a dynamic entry list is used in a table column. Has anyone had success in getting the dynamic entry list to validate the cell values in a table column?
Developement has provided a solution for SP05 in note 1438137.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dan,
It is very much possible, we did it.
1) Take table column/Define table column type as combo box.
2) Now right click on combo box and select "entry list".
3) Select "Dynamic entry list" and search for a BAPI or BI Query to get the dynamic values from the table column (combo box), give the inputs, select out put to show on combo box.
4) You can also slect static entry list if you have very limited value set.
Hope this helps.
Regards,
PradeeP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for the input. This is how we have set up the dynamic entry list. However, the dynamic entry list values are not being enforced.
For a simple example, assume the dynamic entry includes only values '1', '2' and '3'. If the user enters a '4' in the cell, the value is accepted when the table is saved (table is attached to a write enabled query). I need the '4' to be rejected since it's not in the dynamic entry list.
Yes, That is what it will do with COMBO BOX.
Try this, take a combo box right click on the combo box and click entry list. For testing purpose take static entry list and give entry list as (1,2,3) deploy the model. When user writes 4 in the combo box it will show 4 is not in allowed entry list.
Same way, to generate entry list of the combo box dynamically... take a read query and tie it to the combo box while selecting dynamic entry list.
Let me know if this wont solve your issue
Thanks,
PradeeP
I changed the entry list to be static and only included the values 1, 2 and 3. When I open the model and add a new row to the table, it gives no message/error when using the value 4 in that column. Do you have a screen shot of what happens in your system when a table cell value is rejected?
We are running CE 7.1 EhP1 SP05.
Hey Dan,
You are right.... Its a bug... we are also using VC CE 7.1 SP 05....
When I try in form (with combo box) its working fine...I mean its giving error saying "Character string "4" does not exist in the allowed set of values and its not forwarding any values...
but when I use it in table, its not giving any error.
I saw some demos where it was working fine... but those are older sp versions of CE 7.1...
Try to contact SAP VC team on this....
PradeeP
Edited by: pradeep bondla on Oct 6, 2010 12:06 AM
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.