topic Re: Error in the module RSQL accessing the database interface. in Application Development and Automation Discussions

Error in the module RSQL accessing the database interface.

Former Member — Mon, 14 Aug 2006 18:43:46 GMT

Hi All,


  IF it_vbak IS NOT INITIAL.
    SELECT matnr meinh umrez umren FROM marm            
      INTO TABLE it_marm                                
      FOR ALL ENTRIES IN it_vbak                        
      WHERE matnr = it_vbak-matnr                       
        and meinh = it_vbak-zieme.                      

    SORT it_marm BY matnr meinh.                        
    DELETE ADJACENT DUPLICATES FROM it_marm.            
  ENDIF.

This simple select statement gives me an dump saying

<b>Error in the module RSQL accessing the database interface. </b>

What is wrong with this statement.

Thanks In Advance.

Re: Error in the module RSQL accessing the database interface.

Former Member — Mon, 14 Aug 2006 18:52:44 GMT

Hi Jr Abaper.

Check the definition of it_marm, the fields should be in the same order as the select field list.

Hope it Helps.

Jesus

Re: Error in the module RSQL accessing the database interface.

Former Member — Mon, 14 Aug 2006 18:55:38 GMT

Make sure you are checking it_vbak[] not initial instead of it_vbak. The way it is written now will attempt the select if there is anything in the header of your internal table even if the table is emtpy.

Message was edited by: Michael Malvey

Re: Error in the module RSQL accessing the database interface.

Former Member — Mon, 14 Aug 2006 18:58:09 GMT

Hi,

Please try this.

IF NOT IT_VBAK[] IS INITIAL.
  ...
ENDIF.

Regards,

Ferry Lianto

Re: Error in the module RSQL accessing the database interface.

RichHeilman — Mon, 14 Aug 2006 18:59:10 GMT

If your structure of IT_MARM is not the same MARM, then you will get an error. A quick fix is to use INTO CORRESPONDING FIELDS OF TABLE


              
INTO CORRESPONDING FIELDS OF TABLE it_marm

Regards,

Rich Heilman