Fetch data from a R3 Table and send to XI

[Former Member]

Hello XI Experts,

I am involved in a scenario where i need to read some data from a Transparent table in R3 send to xi and post a CSV File.

I have worked on look ups at the XI abap stack but i want to know which is the best solution to do this.

What's the best way to read a table from R/3 and send to xi server. Is there any other ways besides Look ups?

Regards,

Anirban.

[Former Member]

Hi Anirban,

Have a ook at this blog

/people/michal.krawczyk2/blog/2005/09/01/xi-importing-an-r3-structure-or-table-into-repository-not-possible

cheers ,

Prash

[Former Member]

Hi,

Yes i have seen that before but that uses a SQL Microsft server and has no direct relation with my Technical landscape.

Thanks anyways,

Anirban.

[MichalKrawczyk]

Hi,

if you need to send some data from a table and this table

is a starting point then this is not a lookup but a standard flow

you can schedule: IDOCs, RFCs, ABAP proxies

to fetch the data and send it to the XI

I suggest using ABAP proxies:

- this approach will be supported

- it's fast to build (you generate the interface)

- easy to monitor (if you have >= WAS 6.20)

if your r3 is <= WAS 6.20 use RFCs or IDOCs

Regards,

michal

[Former Member]

Hi Michal,

Thanks for your comments, If thats the case then -

1. When is look ups advised .

2. Which is a better solution, if i have very few data to fetch with WAS >= 6.20 . Abap Proxy Or a 'Z' Idoc. Anyways is the size of data a consideration in such an implementation?

Thanks again.

Regards,

Anirban.

[MichalKrawczyk]

Hi,

>>>1. When is look ups advised .

a lookup is when somewhere in your

interface flow you have to lookup some data

for example you send data from one system to another but you have to change material numbers before

sending the data to the target system

you know that material numbers are inside some other server so you have to call this sever (very often in a sync way) to lookup the material numbers

so this would be difficult with IDOC for instance

>>> 2. Which is a better solution, if i have very few data to fetch with WAS >= 6.20 . Abap Proxy Or a 'Z' Idoc.

you'll be able to do it quicker with ABAP proxy

if you use a scheduled report that will send the data from r3 then use ABAP proxies

Regards,

michal

[Former Member]

Thanks Michal and a Happy new year !

[MichalKrawczyk]

no problem:)

happy new year

Regards,

michal