Skip to Content
0
Former Member
Oct 16, 2006 at 02:29 PM

issue

14 Views

Guys'

look at the issue below ,i have one table with

following entries and fields within it

table: zxc

Field: VBELN POSNR ETENR MBDAT EDATU ZDATE

Values:9002077280 10 3 09.10.2006 16.10.2006 11.10.2006

Values:9002077280 10 3 11.10.2006 16.10.2006 13.10.2006

where vbeln,posnr,etenr and mbdat are composite

primary key , my select statement will fetch both these

record in the internal table,but i need to have only

that latest zdate record ,and other should get deleted

that mean from above record with zdate on 13.10.2006 i

should have and delete the other record,keeping in mind

that these should only happen when vbeln,posnr and etenr

are same