Query error

Former Member — Thu, 06 Feb 2014 23:22:58 GMT

Good days experts, I found this query that joins three tables,

SELECT a~BUDAT AS BUDAT a~BWART AS BWART a~AUFNR AS AUFNR
          b~ftrmi AS ftrmi b~stlnr AS stlnr
          c~matnr AS matnr c~werks AS werks
   INTO CORRESPONDING FIELDS OF TABLE gt_result
   FROM AUFM AS a INNER JOIN afko AS b ON a~aufnr = b~aufnr
     INNER JOIN resb AS c ON b~aufnr = c~aufnr
     WHERE a~AUFNR IN SO_AUFNR.

This query is delayed, so i decided to do the following

SELECT a~BUDAT AS BUDAT a~BWART AS BWART a~AUFNR AS AUFNR
          b~ftrmi AS ftrmi b~stlnr AS stlnr
   INTO CORRESPONDING FIELDS OF TABLE gt_result
   FROM AUFM AS a INNER JOIN afko AS b ON a~aufnr = b~aufnr
     WHERE a~AUFNR IN SO_AUFNR.

IF NOT ti_resb IS INITIAL.
     SELECT matnr aufnr
       FROM resb
       INTO TABLE ti_resb
       FOR ALL ENTRIES IN gt_result
       WHERE aufnr = gt_result-aufnr.
ENDIF.

IF NOT gt_result IS INITIAL.
     LOOP AT gt_result ASSIGNING <fs_data>.
       DATA: l_matnr.
       CLEAR: l_matnr.
             SELECT SINGLE matnr INTO l_matnr FROM resb
               WHERE matnr = <fs_data>-matnr.

               <fs_data>-matnr = l_matnr.
     ENDLOOP.
     DELETE ADJACENT DUPLICATES FROM gt_result COMPARING aufnr.
ENDIF.

I need to get the material resb table, do debbug but not get the value, please can guide me where is my mistake.

Best regards.

Re: Query error

Former Member — Fri, 07 Feb 2014 03:00:37 GMT

hi Brojo

SELECT SINGLE matnr INTO l_matnr FROM resb

WHERE matnr = <fs_data>-matnr.

<fs_data>-matnr = l_matnr.

should be:

SELECT SINGLE matnr INTO l_matnr FROM resb

WHERE aufnr = <fs_data>-aufnr.

<fs_data>-matnr = l_matnr.

regards,

Archer

Re: Query error

Former Member — Fri, 07 Feb 2014 03:05:44 GMT

hello Brujo,

Since matnr ,werks and aufnr fields are available in AUFM table it self then why are trying to use RESB table.

topic Query error in Application Development and Automation Discussions

Query error

Re: Query error

Re: Query error