Skip to Content
-2
Oct 12, 2019 at 02:59 PM

read last record of each OBJECTID

90 Views Last edit Oct 12, 2019 at 04:21 PM 3 rev

hi every one.

i want when my check box checked
only display last record of each OBJECTID ( Object Value )

SELECT *
  into CORRESPONDING FIELDS OF TABLE it1
  FROM CDHDR AS A
  INNER JOIN CDPOS AS B
  ON A~OBJECTCLAS = B~OBJECTCLAS AND A~OBJECTID = B~OBJECTID AND A~CHANGENR = B~CHANGENR
  WHERE A~OBJECTCLAS IN OBJCLS AND A~OBJECTID IN OBJID AND A~CHANGENR IN CHNGNR
  AND A~USERNAME IN USRNAM AND A~UDATE IN UDATE AND A~UTIME IN UTIME
  AND A~TCODE IN TCODE AND B~TABNAME IN TABNAM AND B~TABKEY IN TABKEY AND B~FNAME IN FNAME .

IF CB1 = ''.
  IT2 = IT1.
ELSE.
?????????
ENDIF.

I would be grateful if you guided me through this.

***********************************************************************************************************************************************

I found the answer

IF CB1 = ''.
  IT2 = IT1.
ELSE.
 loop at it1 into wa1.
   nr = SY-TABIX.
   nr2 = nr + 1.
   read table it1 into wa2 index nr2.
   if wa1-OBJECTID ne wa2-OBJECTID.
     APPEND wa1 TO it2.
   endif.
 ENDLOOP.
ENDIF.