I wish to import the data present in a table in ECC and store it in a data/complex table.
The data in this table would look like as follows:
Now, I have to pick up the data from this table and o display the data in a dropdown.
Before I display the data in dropdown, I wish to filter this table so that at any given time, It only displays the data for a particular characteristic.
So, if a text box in my screen has "Characteristic1" set in it, the dropdown below should display following entries:
My question is, is it possible to filter the data table dynamically so that the dropdown values can be adjusted?
as I understand, dropdown fields can ONLY be populated using a data table or a complex table. Is this correct?
Can I use Java side code to manipulate the entries in data/complex table?
What would be the best approach to fulfill this requirement?
Really appreciate your help on this.