WebAug 4, 2009 · Method 1 Declare one more internal Table of same type. Read this rows and append to the new internal table. Method 2 Loop through Table and capture the sy-tabix value in variable. use case or If stmt with in the loop such that u delete other Document but not 10,20.30 rows. for Example. WebDec 15, 2015 · delete adjacent duplicates comparing vendor number invoice number invoice date dtypi. after deletion and you can combine this internal table with the internal table of DTYPC = 'X' . Hope this will solve your issue for sure. After Loop. Delete [internal table] where DTYPI = 'X' or DTYPC = 'X'.
Delete Internal table in same loop- Can we do this? SAP …
WebNov 18, 2008 · SELECT-OPTIONS: s_vbeln FOR vbap-vbeln MODIF ID vbe, s_posnr FOR vbap-posnr MODIF ID vbe. select * from vbap into table it_vbap. assign it_vbap to . loop at assigning . delete . endloop. Inside the loop you just need to specify the field symbol that points to the table , so the current line will be deleted. WebApr 22, 2009 · Hi Shilpi, Delete the entry using the beow syntax. DELETE TABLE table name FROM work area. or get the index of the entry from the internal table and delete it. DELETE internal table name INDEX sy-tabix. Hope this … checker marine service inc
Delete duplicate from internal table SAP Community
WebThe problem in the delete from itab (give all table at a time ) that u don't know which record is not deleted u just have sy-dbcnt but i don't see any other indication so when u doing loop i know which record is exactly not deleted and send some message . p.s. i guess that the delete from itab doing loop inside too . Regards Nina Find us on Privacy WebOct 9, 2007 · I have a query on how to remove the duplicates from an internal table My internal table data is as follows : Cno Catg1 Catg2 01 0 1000 01 2000 0 I want to get only one record as 01 2000 1000 How to get the result. I tried sorted by cno and used delete duplicates but it was not helpful. Is there any other alternative to get this done Please … WebMay 12, 2008 · 4 Answers. This should work. tables: vbak. DATA: BEGIN OF itab OCCURS 0, vbeln LIKE vbak-vbeln, END OF itab. SELECT-OPTIONS s_vbeln for vbak-vbeln. DELETE itab WHERE NOT vbeln IN s_vbeln. loop at it_vbeln . if it_vbeln-vbeln in s_vbeln . … flash furniture contemporary recliner spacers