topic Re: Read table QMIH in Application Development and Automation Discussions

Read table QMIH

Former Member — Thu, 11 Jan 2007 18:11:14 GMT

I try to read the table QMIH, with RFC_READ_TABLE, but this function send me SYSTEM_FAILURE --- BUFFER EXCEED,

i am using Sap Connector with .net,

can anybody help, is there another function to obtain data from this table.

Re: Read table QMIH

Jelena_Perfiljeva — Fri, 12 Jan 2007 16:27:29 GMT

I'm not an RFC expert but the description of the DATA_BUFFER_EXCEEDED message says <i>Selected fields do not fit into structure DATA</i>. I'm guessing that the structure of DATA (which is just CHAR 512) and what you are trying to retrieve from QMIH table don't go well together. Try adjusting the content of OPTIONS and FIELDS tables that you are passing to RFC_READ_TABLE. Good luck!

Re: Read table QMIH

Former Member — Fri, 12 Jan 2007 16:51:19 GMT

Hi Roberto

I guess you are not using the tables

OPTIONS LIKE RFC_DB_OPT " Selection conditions in WHERE

FIELDS LIKE RFC_DB_FLD " Req fields

of the function module. In such cases the FM tries to return all the the values which is causing an overflow.

Regards

Kathirvel

Re: Read table QMIH

Former Member — Fri, 12 Jan 2007 17:20:58 GMT

u need to even pass where condition fields to the FM. as such data is hughe it can't be accomapanied in one shot without any conditions so it goes for a dump.

Re: Read table QMIH

Former Member — Fri, 12 Jan 2007 20:29:00 GMT

Hi Kathirvel

I am using the table.

when i use the RFC_READ_TABLE for read EQUZ, it works,

when i use for read QMEL it works.

When I use RFC_READ_TABLE with VBA the message error is SYSTEM_FAILURE, when i use RFC_READ_TABLE with .NET and SAP Connector the message is SAP.Connector.RfcSystemException: Error in ASSIGN statement in the program SAPLSDTX

Regards.

Re: Read table QMIH

Former Member — Sat, 13 Jan 2007 05:51:11 GMT

VBA is not a table in sap.

also, the error connection might be due to not sending field data properly to fields.

Re: Read table QMIH

Former Member — Thu, 18 Jan 2007 16:25:10 GMT

hi, sorry i try to say that when i programming with VisualBasic for Application, the RFC_READ_TABLE send me SYSTEM_FAILURE, I check the fields name and they are right, and there are another tables that send me the same error....

Could you help me.

Regards....

Re: Read table QMIH

Former Member — Thu, 18 Jan 2007 16:30:17 GMT

What are the contents of the table OPTIONS that you are passing to the FM?

Rob

Re: Read table QMIH

Former Member — Thu, 18 Jan 2007 16:57:40 GMT

I use

sappmactiv.RFC_DB_FLD(0).Fieldname = "QMNUM"

sappmactiv.RFC_DB_OPT(0).Fieldname = "QMNUM = '005100067798"

Me.y51.Rfc_Read_Table("", "", "QMIH", 0, 0, Me.y51.RESULTA, Me.y51.CAMPOS, Me.y51.OPCION)

the result in .NET is:

Error in ASSIGN statement in the program SAPLSDTX

but i use

sappmactiv.RFC_DB_FLD(0).Fieldname = "QMNUM"

sappmactiv.RFC_DB_OPT(0).Fieldname = "QMNUM = '005100067798"

Me.y51.Rfc_Read_Table("", "", "QMEL", 0, 0, Me.y51.RESULTA, Me.y51.CAMPOS, Me.y51.OPCION)

the result in .NET is:

sappmactiv.TAB512(0).Wa = "005100067798"

its works.