Dropdownlist dynamic entry list

[Former Member]

hi all;

I have a problem with dropdown list dynamic entry list... I m using BI System as a data service. My characteristic has a hierarchy in bw system but i cant dynamic entry list with my characterictic in vc. In input value i use my characgteristic name( eg @Company). and in output value i use @key and @text. But when i deploy it dropdown list always empty...

What can i do about this?? Can anyone help me?

[Former Member]

Hi Marcel;

I have some questions.

I want dynamic dropdown list with hierarchy.

for exmp.

i m using this BI infoobjects.

1. ZDIVISION (values = A, B, C, D)

2. ZPRODUCT (values = AA, AB, AC, BA, BB, BC, CA, DA, DB)

Can i do this with one dynamic function modules? Do you have any example or blog about this?

than you for your help!!!

[Former Member]

Hi Ozan,

you want to display a hierachy in a dropdownlist? This is not easy, but should be possible, because the H-Table for hierchies have always the same data structure, so you have to write a function module which creates an internal table like the hierchy. I think the problem is the display in the dropdown, so that the user notice the nodes and the childnodes and so on, maybe you can add 2 spaces for every childnode so that it looks like a tree. I hope your hierachy hasn't a lot of levels.

To the H-table:

the field tlevel is equivalent to the hierchy level so the nodes under the root are 01 child nodes of these nodes have the value 02 and so on.

Via the fileds parentID, ChildId and NextID you have all the information for building your tree in a internal table, which has a key and a text.

The text can be read via the information about the infoObject and the inode is the value, so that you can read the texts from the texttables.

This should be possible for an average abap developer. Looping over H-table and append the values to the internal table...

Maybe I have the time in february to write an prototype then I will write a blog.

Best Regards,

Marcel

[Former Member]

yes i check corresponding data and it is active... Is it only way write function modules???

[Former Member]

Hi Ozan,

you can write your function module as a dynamic function module, so that you can use it for every characteristic, so you can use it several times in your VC models, when you need a drop down.

Just a few hints to do this. Create a return structure in the table parameters with RSTXTLG, RSTXTMD, RSTXTSH for the different text lengths, the key is a char with length 60 (because BI keys are limited to 60 chars the characteristic key and all the compounds characteristics). So you can return dynamicly all the texts and keys with one rfc.

Best Regards,

Marcel

[Former Member]

Anyone help me about this???

[Former Member]

Hi Ozan,

can you check if corresponding data is active in your characteristic? You can also write an ABAP function module which reads the data direct from the characteristic table and retruns it to VC for your dropdownlist.

Best Regards,

Marcel