topic Select Criteria in Application Development and Automation Discussions

Select Criteria

Former Member — Mon, 18 Jun 2007 13:55:07 GMT

How we write the select criteria when extracting data from another R/3 using RFC's ....

1) Do we fill the data with Internal table and write select criteria on Internal Table.Thank you....

Re: Select Criteria

Former Member — Mon, 18 Jun 2007 13:59:25 GMT

Hi Alex,

We canot write selects on internal tables ... so that is not a right way to do.. Data Migration between the servers can be done with different methods like LSMW, IDoc ...which depends on how much data you ahve it in your old system ...

Regards,

Santosh

Re: Select Criteria

Former Member — Mon, 18 Jun 2007 14:01:56 GMT

Hi,

You can do that using import and export parameters.

Export from R/3 and import into your RFC.

Thanks,

Deepti

Re: Select Criteria

former_member404244 — Mon, 18 Jun 2007 14:02:08 GMT

Hi,

Generally we don't write select query on internal table.For RFC u need to write the select query in an FM on the RFC side and call the FM in ur R/3.The select query will be on database table of other R/3.

Regards,

Nagaraj

Re: Select Criteria

Former Member — Mon, 18 Jun 2007 14:03:43 GMT

Could you just give a example of how write select query....