Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to delted from the database table

hi

there is a record in internal table itab1 as below

|0000000110|AGILENT TECHNOLOGIES <TEST1 ><

|0000000110|AGILENT TECHNOLOGIES <TEST2 ><

|0000000110|AGILENT TECHNOLOGIES <TEST3 ><

|0000000110|AGILENT TECHNOLOGIES <TEST4TOTEST5 ><

and there are recored in table ztesttable having 3 fields cutomern number name and email and all are primary key

|0000000110|AGILENT TECHNOLOGIES <TEST1 ><

|0000000110|AGILENT TECHNOLOGIES <TEST2 ><

|0000000110|AGILENT TECHNOLOGIES <TEST3 ><

<b> |0000000110|AGILENT TECHNOLOGIES <TEST4 ><</b>

|0000000110|AGILENT TECHNOLOGIES <TEST4TOTEST5 ><

i want to delted the bolded r ecored ie third value as test 4 which is not in the internal table itab1 ie i want to compare the records with the itab to that of the zdatabase table ztesttable and then delete the recored which do not match to t he internal table

pls suggest the way and code

pls suggest how to delte the recroed which are not in the internal table...

the three fields are cutomer name email in the table and internal table and data as above

basically my aim ot to compare the data in ztable with this internal table and deleted the recoed which do nt match with this internal table

and point to be noted is that customer name and emal all are primary key in the database table.

regards

Arora

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question