Using dynamic structures
Question: During design time the structure of the data service is unknown, as it is going to generated on the customer site after the model was created. How can we use dynamic structures in Visual Composer?
Currently there is no easy or perfect solution for this.
SAP Business Intelligence
For SAP BI this functionality is supported. The structure of many BI queries depends on the result set (e.g. number of months in the columns). For this you have to check the field Dynamic Port on the output port of your Bi data service.
RFC
There is no automatic functionality available. A workaround can be to use multiple fields with datatype String and by manipulating the values in the ABAP.