Visual Composer - dynamic entry list in a form

[Former Member]

Hi everybody,

I have a question about Visual Composer (NW7.1).

My goal is it to create a dynamic form within VC iView. As data source I want to use (reads) values from a customizing table and displayed them in a drop down menu. After selecting a drop down value, all its elements shall be presented dynamic in a form. My question is if VC is supporting that technically or not. I have tried different approaches but it is not working.

Does anybody have some suggestions???

For example:

To show all customer data in a form, I set a reference in my customizing table that refers to my KNA1 table. If I want to show all suppliers data, I want to refer to my customizing with a reference to table LFA1. The form should display all the elements of KNA1 or LFA1. Is something like that technically possible?? HELP!

Thank you for your help in advance.

[anja_engelhardt2]

Hi again,

yes, this should be possible but you need to load all the data as far as I can see.

I created some simple model with a drop down list and connected its output to 2 other forms. Via visibility condition for each of the 2 form you can decide which one to display.

Anja

[Former Member]

Hi Anja,

since I see in your profile that you are speaking German, I continue in German

Erstmal danke für deine Antwort.

Das Problem ist, dass Tabellen per Formular geändert werden sollen, die vorher nicht bekannt sind.

Das heisst, die Spaltenzahl ist unbekannt. Bisher konnte ich keinen Weg finden, das Formular dynamisch anzupassen.

Wenn ich dich richtig verstanden habe, müssen bei deiner Idee die beiden Tabellen vorher bekannt sein, oder?!

Gruß

Tom

[Former Member]

Please, Ich spreche nur ein bisschen deutsch, aber ist Recht nicht an andere Benutzer.

Please, speak english.

[Former Member]

here in English:

First of all thank you for your answer.

The problem is that tables shall be changed in a form. These tables are not known. That means that the column names are unknown. Up till now, I could not find a way to adapt a form dynamically.

If I understood you correct, than both tables have to be known first, right?

[anja_engelhardt2]

Hi,

first of all: please keep the communication in English. Other users might be interested as well.

And yes, you understand it correctly: the tables have to be known that you can create a model refering to 2 tables in 2 forms just being visible through visibility condition.

Anja

[anja_engelhardt2]

Hi,

I'm not sure whether I understand correct. So here is what I think you like to do:

1. Having some drop down list to select an entry.

2. Depending on the entry you like to display a form either filled with values of KNA1 table or LFA1 table.

Correct?

Anja

[Former Member]

Hi Anja,

you understood me correct. However this was just an example.

1. Having some drop down list to select an entry.

--> in this drop down list there should be master data objects e.g. customers, suppliers, ...

2. Depending on the entry you like to display a form either filled with values of KNA1 table or LFA1 table.

--> If I choose customers all information should be displayed in the form. If I choose suppliers all supplier's information should be displayed in the form.

My task and my goal is it to use a customizing table in which I save SAP BI InfoObject. In my drop down menu I want to be able to select one of these object (e.g. customer master data). In the next step there should be a dynamic list for my form. That means if I change my object by selecting another drop down item - it will be automatically change the list entries from my new object

How can I do that?

Thank you so much.

Tom