Getting Column from a table?

[Former Member]

Hi all

I have one table with many columns. I want to extract one particular column values and pass it to some RFC which takes this as input one by one say for one value it gives some corresponding value.

Now I want a table in which I can have the column value and the corresponding values from the second RFC.

Can any one help me in doing this

Max. points assured.

[Former Member]

humm? let's say you can create a wrapper RFC or web service, it'd be way easier if your wrapper function can take you one column table (like a list of IDs for example) and process it through the 2 RFCs you're talking about and return a two columns table (like a list of IDs and ID descriptions for example). then call your rfc wrapper or web service within CAF GP or Core.

But if you cannot create a wrapper, it'd be too difficult for me to discuss a solution here. actually i'm not even sure if it's even technically possible and reasonable to do it without such wrapper. maybe somebody else knows of a decent solution...

[Former Member]

Hello Andre

Thanks for a respone.

The situation is :

I have 2 external services 'A' and 'B'.

I make them as the Entity Services.

Now 'A' takes some inputs and gives the outputs, I mapped theses outputs to a table and at run time passing some input I can see the outputs in the table.

Now 'B' takes input that are in the column of a table that is created at runtime and gives some output corresponding to the inputs from the table.

I make another table in which I want the fields form those those two Entity Services.

I want to know how we can do this. This time I am not doing any calculation just fetching the values only.

I think the problem is some more clear.

[Former Member]

ok. if that's the way you want to go about then you could do it via the CAF application service layer. that application service would then be your wrapper service.

[Former Member]

Hi Andre

I am using CAF only but not able to get the result. Do you help me in giving some sloution or some blog etc. that make my work easier.

Thanks

[Former Member]

I'd suggest that you create a third entity (Entity C) service that contains Entity A and Entity B. You can then pick the corresponding columns from either entities. So it would be something like entityC.entityARef.col1, entityC.entityBRef.col2 ...

Thanx,

Mahesh