topic Re: query for deletion in Application Development and Automation Discussions

query for deletion

Former Member — Mon, 28 Jul 2008 13:43:50 GMT

Hi to all.........

Plz tell me the ABAP query for how to delete the duplicate posting months from dfkkop & after

then the query to count the no of rows of dfkkop ??

Thanks & Regards........

Rajeev Shrivastava

Former Member — Mon, 28 Jul 2008 13:45:00 GMT

hi,

You can DESCRIBE <table> LINES w_line.

for calculating the lines.

Regards

Sumit Agarwal

Former Member — Mon, 28 Jul 2008 13:47:23 GMT

hi check this..

tables:marc .

data: it_marc like marc occurs 0.

select-options:s_matnr for marc-matnr .

data: v_count type i .

select matnr

werks

from

marc into table it_marc

where matnr in s_matnr .

delete adjacent duplicates from it_marc comparing werks .

describe table it_marc lines v_count .