Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Internal table compare does not fetch records.

Former Member
0 Likes
939

I have the following code wherein I am reading an internal table and looking for values in another internal table, I manually checked and there are many that match, In debugger I see that on line 17 sy subrc equals 4, so line 12 Fails, Thanks in advance for any input.


SELECT  MANDANT OBJECTCLAS OBJECTID CHANGENR USERNAME UDATE

         INTO CORRESPONDING FIELDS OF TABLE it_cdhdr

         FROM  CDHDR

         WHERE OBJECTCLAS = 'EINKBELEG'.

SELECT MANDANT OBJECTCLAS OBJECTID CHANGENR TABNAME TABKEY FNAME UNIT_OLD UNIT_NEW CUKY_OLD CUKY_NEW VALUE_NEW VALUE_OLD

        INTO CORRESPONDING FIELDS OF TABLE it_cdpos

        FROM CDPOS

        FOR ALL ENTRIES IN it_cdhdr

ERE OBJECTCLAS = it_cdhdr-OBJECTCLAS."'EINKBELEG'.

"Endif.

LOOP at it_cdpos into wa_cdpos.

   READ TABLE it_cdhdr into wa_cdhdr with key

       MANDANT    = wa_cdpos-MANDANT

       OBJECTCLAS = wa_cdpos-OBJECTCLAS

       OBJECTID   = wa_cdhdr-OBJECTID

       CHANGENR   = wa_cdhdr-CHANGENR.

   if sy-subrc = 0.

     MOVE-CORRESPONDING wa_cdhdr to wa_results.

     MOVE-CORRESPONDING wa_cdpos to wa_results.

     APPEND wa_results to it_results.

     clear :wa_results,wa_cdhdr,wa_cdpos.

   endif.

ENDLOOP.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
916

Have you considered reviewing your READ TABLE criteria?

  1.     MANDANT    = wa_cdpos-MANDANT 
  2.        OBJECTCLAS = wa_cdpos-OBJECTCLAS 
  3.        OBJECTID   = wa_cdhdr-OBJECTID 
  4.        CHANGENR   = wa_cdhdr-CHANGENR. 

Guess you mean to search for:

  1.     MANDANT    = wa_cdpos-MANDANT 
  2.        OBJECTCLAS = wa_cdpos-OBJECTCLAS 
  3.        OBJECTID   = wa_cdpos-OBJECTID 
  4.        CHANGENR   = wa_cdpos-CHANGENR. 

I have the following code wherein I am reading an internal table and looking for values in another internal table, I manually checked and there are many that match, In debugger I see that on line 17 sy subrc equals 4, so line 12 Fails, Thanks in advance for any input.


SELECT  MANDANT OBJECTCLAS OBJECTID CHANGENR USERNAME UDATE

         INTO CORRESPONDING FIELDS OF TABLE it_cdhdr

         FROM  CDHDR

         WHERE OBJECTCLAS = 'EINKBELEG'.

SELECT MANDANT OBJECTCLAS OBJECTID CHANGENR TABNAME TABKEY FNAME UNIT_OLD UNIT_NEW CUKY_OLD CUKY_NEW VALUE_NEW VALUE_OLD

        INTO CORRESPONDING FIELDS OF TABLE it_cdpos

        FROM CDPOS

        FOR ALL ENTRIES IN it_cdhdr

ERE OBJECTCLAS = it_cdhdr-OBJECTCLAS."'EINKBELEG'.

"Endif.

LOOP at it_cdpos into wa_cdpos.

   READ TABLE it_cdhdr into wa_cdhdr with key

       MANDANT    = wa_cdpos-MANDANT

       OBJECTCLAS = wa_cdpos-OBJECTCLAS

       OBJECTID   = wa_cdhdr-OBJECTID

       CHANGENR   = wa_cdhdr-CHANGENR.

   if sy-subrc = 0.

     MOVE-CORRESPONDING wa_cdhdr to wa_results.

     MOVE-CORRESPONDING wa_cdpos to wa_results.

     APPEND wa_results to it_results.

     clear :wa_results,wa_cdhdr,wa_cdpos.

   endif.

ENDLOOP.

5 REPLIES 5
Read only

Former Member
0 Likes
917

Have you considered reviewing your READ TABLE criteria?

  1.     MANDANT    = wa_cdpos-MANDANT 
  2.        OBJECTCLAS = wa_cdpos-OBJECTCLAS 
  3.        OBJECTID   = wa_cdhdr-OBJECTID 
  4.        CHANGENR   = wa_cdhdr-CHANGENR. 

Guess you mean to search for:

  1.     MANDANT    = wa_cdpos-MANDANT 
  2.        OBJECTCLAS = wa_cdpos-OBJECTCLAS 
  3.        OBJECTID   = wa_cdpos-OBJECTID 
  4.        CHANGENR   = wa_cdpos-CHANGENR. 
Read only

0 Likes
916

Thank you!.That fixed it. I guess Syntax checker does not look for those typos , and staring at the screen for a few hours renders the Brain useless.

Read only

Former Member
0 Likes
916

Well, obviously it fails....

Because on line 15 and 16 it should be wa_cdpos instead of wa_cdhdr.

Thanks,

Chandra Indukuri

Read only

0 Likes
916

Burra pani chestalledu Boss.

Read only

0 Likes
916

Don't worry.... some times it happens