query for deletion

[Former Member]

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]

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]

hi,

You can DESCRIBE <table> LINES w_line.

for calculating the lines.

Regards

Sumit Agarwal

[Former Member]

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 .