Extract MARA using EXCEL RFC

[Former Member]

Hi all,

I have searched everywhere but I didn't have any luck. So hopefully you can help.

I am trying to do the simplest thing and that is, extract some data into Excel using RFC. I can do that with RFC_READ_TABLE for most of the tables but not for any of the MASTER DATA tables like MARA, MARC, LFA1, KNA1 and so on.

In SE37 I get DATA_BUFFER_EXCEEDED.
I have tried few other like /SAPDS/RFC_READ_TABLE and Z_AW_RFC_READ_TABLE which I don't have but also without any luck. It just doesn't extract anything, if I use a small table, then everything is ok (MVKE WORKS, it has only 470 entries).

I would just like to extract MARA table, nothing complicated. If I can put a list of material codes somewhere it would be even better but just MARA table would be a start.

Does someone have like an example which I could try that works for MARA? Possibly thew whole VBA code for Excel?

Thank you all!!

[ChrisSolomon]

Why not use RFC_READ_TABLE but use "row skips" and "row count" in order to read/dump it into "chunks"? Then once in Excel, you can recombine as needed. Those can be HUGE tables, so you won't be able to just "dump" them in one pass easily.

[chunhui]

Use AecorSoft Reporting Excel Add-in for this.

[NTeunckens]

Use "RFC_READ_TABLE" with some of the additional Options mentioned in this Post : link

[Former Member]

You must specify "rowcount" in RFC_READ_TABLE. Otherwise, it will try to load entire table into memory and it will short dump. Check ST22 and you will see the short dump error.

Or you have to use third party software to do such huge table pull for you.