Skip to Content
avatar image
Former Member

Extract MARA using EXCEL RFC

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 10, 2017 at 02:32 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2017 at 11:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 03, 2017 at 10:39 PM

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

    Add comment
    10|10000 characters needed characters exceeded