Production server data read

[Former Member]

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

[GauthamV]

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

[Former Member]

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

regards

rajaram

[Former Member]

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

[Former Member]

Can anyone tell is that possible.

[rainer_hbenthal]

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.

[former_member755502]

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.