topic Re: Production server data read in Application Development and Automation Discussions

Production server data read

Former Member — Thu, 28 Aug 2008 10:52:19 GMT

Hi Experts

Can we read data from developement client to production client and its database table.

I used the following query,

SELECT ebeln

aedat

lifnr

zterm

FROM ekko CLIENT SPECIFIED INTO table itab

WHERE MANDT = '394'.

But its not working, but it works fine between developement client and the sandbox client.

Can't we read production database tables data.

Suggest me

Regards

Rajaram

Re: Production server data read

GauthamV — Thu, 28 Aug 2008 10:55:25 GMT

hi,

devolopment and sandbox r 2 clients in same server.

but it is different server for quality and production.

u can compare table entries between diff clients using this fm.

RFC_GET_TABLE_ENTRIES

Re: Production server data read

Former Member — Thu, 28 Aug 2008 10:58:48 GMT

so if we want to read from produciton server, we need to configure RFC, is it.

regards

rajaram

Re: Production server data read

Former Member — Thu, 28 Aug 2008 10:59:20 GMT

Hi Raja,

I am not sure but it will work for clients belong to same system(Development/Quality/Production) but not client on another system.

Thanks,

Vinay

Re: Production server data read

former_member755502 — Thu, 28 Aug 2008 11:03:40 GMT

Hi Rajaram,

The answer to your query is NO you can not do that, unless one server's data are replicated on the other. They are different servers. This is done to protect the data stored on production server, which is often very sensitive.

Thank you.

Re: Production server data read

Former Member — Thu, 28 Aug 2008 11:10:05 GMT

Can anyone tell is that possible.

Re: Production server data read

rainer_hbenthal — Thu, 28 Aug 2008 13:07:10 GMT

it is possible, but via select. you need to wrap this select into a function module, build a rfc connection and then call that FM from production with the DESTINATION keyword.