Passing a table as input to a query

[Former Member]

Hi Experts,

I am new to Visual Composer so this might be a fairly simple question.

My query takes in a input parameter (CUSTOMER ID) and generates an output table. I can easily display this output table in Visual Composer. However my problem is that the query takes in a one CUSTOMER ID, and not a table of CUSTOMER IDs. What I need to do is pass a table of CUSTOMER IDs to the query and iteratively run the Query for each CUSTOMER ID. The output table from the query would be a cumulative output table of all the data from each output table associated with each CUSTOMER ID.

I am not sure how I can do this in Visual Composer.

Thanks!

Osman

[Former Member · Accepted solution]

Hi Osman,

you can pass a whole table into your query. You have to flip port of the table, which is used as input (the table with your customer IDs). In your query (I think it's an ABAP function module) you can bring your result together to an cumulative output table as you need it. Hope this helps.

Also check the Wiki entries:

[ Multiple tables into one dataservice|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/multipletablesintoonedataservice]

[ Combining two tables, BAPIs or queries|https://wiki.sdn.sap.com/wiki/display/VC/Combiningtwotables%2CBAPIsor+queries]

Best Regards,

Marcel

[Former Member]

Hi ,

Marcel is Correct.

You can give all your Customer Ids ina Table as a Input to the Dta service.

For this you have Chnage your Bapi to get the Out Port for Customer Ids after that Right click on that port select the Flip port.

Then you can get the Customer Ids as Input Port and Drag A Table form it .

I hopes you got the Point

Regards,

Govindu