Skip to Content
0

Extract MARA using EXCEL RFC

Jan 10, 2017 at 02:22 PM

128

avatar image

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!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Christopher Solomon
Jan 10, 2017 at 02:32 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Aecorsoft Inc Feb 08, 2017 at 11:12 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Nic Teunckens Mar 03, 2017 at 10:39 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded