Dynamic entry list used in a table column

[Dan_M]

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?

[Dan_M · Accepted solution]

Developement has provided a solution for SP05 in note 1438137.

[Former Member · Accepted solution]

For installations with no notes try restricting the values in the query filter. THe query will disallow the values from saving.

[Former Member · Accepted solution]

Hi Dan,

Does this note work if the user manually enters the value in the column of the table and clicks "Save" directly. I believe the note only addresses if you enter a value in the column and hit the "Enter" key to produce a error message.

[PradeepBondla]

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

[Dan_M]

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.

[PradeepBondla]

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

[Dan_M]

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.

[PradeepBondla]

Our system is down today... I can not do it now... will share with you tomorrow.

up to I know it can be achieved... 100 %

Thanks,

PradeeP

Edited by: pradeep bondla on Oct 5, 2010 10:13 PM

[PradeepBondla]

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

[PradeepBondla]

Hi Dan,

I raised message to SAP, they worked on this and came back saying...

This functionality is available from CE 7.1 EhP1 SP06. So you upgrade to SP06 your problem will be solved.

Hope this helps...

Thanks,

PradeeP