Data Buffer Exceeded

[Former Member]

Hi,

I am using the RFC_READ_TABLE call to extract data from 'AFVV' table. I am running into the data buffer exceeded error. Can somebody help? Thanks.

Regards,

V M.

[Former Member]

hi

i had the same mistake

you could solve this mistake, putting all fields that you need. this is my solution.

Part of my code:

  clear : opcion,  CAMPOS.
  MOVE: 'PERNR' TO CAMPOS-FIELDNAME,
        '8'     TO CAMPOS-LENGTH.
   APPEND CAMPOS. CLEAR CAMPOS.
  MOVE: 'LIFNR' TO CAMPOS-FIELDNAME,
        '10'    TO CAMPOS-LENGTH.
   APPEND CAMPOS. CLEAR CAMPOS.
  MOVE: 'BUKRS' TO CAMPOS-FIELDNAME,
        '4'    TO CAMPOS-LENGTH.
   APPEND CAMPOS. CLEAR CAMPOS.
*****
CALL FUNCTION 'RFC_READ_TABLE'
destination dest
  EXPORTING
    QUERY_TABLE                = 'LFB1'
  TABLES
    OPTIONS                    = OPCION
    FIELDS                     = CAMPOS
    DATA                       = TI_data
 EXCEPTIONS
   TABLE_NOT_AVAILABLE        = 1
   TABLE_WITHOUT_DATA         = 2
   OPTION_NOT_VALID           = 3
   FIELD_NOT_VALID            = 4
   NOT_AUTHORIZED             = 5
   DATA_BUFFER_EXCEEDED       = 6
   OTHERS                     = 7.

Regards

Gregory

[agentry_src]

Venki,

This subject is covered pretty thoroughly in the following thread:

[DataBufferExceeded|]

You can also do a search on RFC_READ_TABLE and you will find a few more good messages to use resolving your problem.

You will have to spend some time in SE11 to see which fields to use for your given table.

Good luck,

Mike

[Former Member]

I got my solution using a standard BAPI; didn't have to work with the RFC_READ_TABLE call. But your suggestions should definitely help at a later time. I will consider my question as answered for now. Thanks guys.

Regards,

V M.

[agentry_src]

Hi Venki,

Is that a custom table? What is it used for?

My test instance does not have a table named AFW.

Do you get the data overflow error on other tables (core standard tables)?

Regards,

Mike

[Former Member]

Mike,

Please note the correction A F V V not AFW. Its a DB structure of the quantities/dates/values in the operation.

No, I don't get that error on other core tables. And I followed the exact same steps here as well. Thanks.

Regards,

V M.

[agentry_src]

That makes more sense. And I get the same Data Buffer Exceeded error when I run it from MII. There must be something in the design structure. I did notice that it has no indices which might make sense if it has to search the entire table for data regardless of the filter requirements.

This is getting out of my area of expertise. I suggest that you check with your Basis gurus.

Mike

[Former Member]

The key fields are AUFPL and APLZL.