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.