Data retraction from BEx Query output to ECC System

[Former Member]

Hello All,

I have the following requirement in my current Project

I need to  load Bex Query Output data into Ecc System . In order to solve this i have gone through one Program which is avaliable on the web.

According to that , i need to write an ABAP Progam in ECC System , which will read the data and store in  one internal table e.t.c

But , when we have open hub destination , why cant we use open hub destination to send the data from query output to Transparent table ????

I observed in 7.3 version BW System , we can use Query output as source .

Can Anyone hlep me in this??

Regards,

Vamshi

[ccc_ccc]

Hi Vamshi,

You can use query as datasource.

To make any query as datasource goto RSRT click on "Properties" button and lick on"Query is used as infoprovider", prerequisite is query should not contain any variables.

Thank you,

Nanda

[Former Member]

HelloNanda,

I have variable in my Bex Query . Will i not be able to use query as source in this scenario?

Thanks,

vamshi

[ccc_ccc]

Hi Vamshi,

Yes, however there is way, you can implement variable logic in DTP filter.

Or

Create customized table like RANGE structure and fill variables values as per requirement and read values in DTP filter and execute DTP.

Please let me know your requirement.

Thank you,

Nanda