Visual composer: how to combine two BAPIs to get one result table?

[thierry_renault]

Hello,

I'm trying to combine two BAPIs in order to get one result table. Here are the steps:

1. call BAPI_USER_GETLIST

2. for each user found in this call, I would like to get details. So, I call BAPI_USER_GET_DETAIL

3. I would like to get a table with n lines (the # of users) and, on each line displaying data comming from from the first and the second BAPI

Do you have any idea?

Thanks in advance.

Best regards,

Thierry

[JUNG]

Hello,

I think it could be done using VC operator "Union".

Rgds

Gilles

[anja_engelhardt2]

Hi Gilles,

We moved our Wiki. See:

http://wiki.scn.sap.com/wiki/display/EP/Combining+two+tables%2C+BAPIs+or+queries

[Former Member]

Hello Thierry,

create a Z_BAPI.... and define a table with all the data-fields you will see in VC.

in this z_BABI call 1. BAPI_USER_GETLIST and then

2. BAPI_USER_GET_DETAIL. Fill the table with the result and then you can

show it in VC.

Best Regards

Gerd

[thierry_renault]

Hello Gard,

You are right, it's a possibility and I'll use it if I don't fin dany other solution. Nevertheless, I would like to combine these 2 BAPIs without any ABAP programming.

In fact, I want:

- an input form

- a first bapi call (USER_GETLIST)

- for each user, a bapi call (USET_GET_DETAIL)

- a list (table) containing data from both calls

Is it possible?

Best regards,

Thierry

[Former Member]

We have done exactly what Gerd suggested - created one ZBAPI to get all desired user details in one combined BAPI. Done by consultant in a very short time.

Henning

[Former Member]

Thierry,

Add the two BAPIs to your model and then drag the Combine operator onto the model. It can be found in Compose and then by expanding the Additional Operators section at the very bottom. Link the BAPIs to the Combine operator and then the output of the Combine operator to what you would like.

Peter

[Former Member]

I agree with Gerd. As I read the headline of this thread I thought about tha same solution. I had a similar problem in the past. The additional operators in VC are very limited. I hope in future releases there are more opportunities.

Best Regards,

Marcel

[Former Member]

I added a Visual Composer FAQ entry in the WIKI to this topic:

https://wiki.sdn.sap.com/wiki/display/VC/Combiningtwotables