Sometimes it’s just easier and more performant to delete all rows from a table and repopulate it.
I used this scenario for a weekly sheduled job to refresh a custom table,containing all the email adresses from our employes.
In the first step, i populate an internal table with the type of the database table.
-
LOOP AT INPUT-MT_adusers_CRM-RECORD-ROW into ls_adusers_data.
-
IF ls_adusers_data-email CA '@'.
-
MOVE sy-mandt TO wa_admails_data-mandt.
-
MOVE ls_adusers_data-userid TO wa_admails_data-userid.
-
MOVE ls_adusers_data-fullname TO wa_admails_data-fullname.
-
MOVE ls_adusers_data-email TO wa_admails_data-email.
-
APPEND wa_admails_data TO it_admails_data.
-
ENDIF.
-
ENDLOOP.
-
*enqueue table
-
CALL FUNCTION 'ENQUEUE_E_TABLEE'
-
EXPORTING
-
mode_rstable = 'E'
-
tabname = '/G/ADMAILS'
-
EXCEPTIONS
-
foreign_lock = 1
-
system_failure = 2
-
OTHERS = 3.
-
*delete all mails
-
DELETE FROM /G/ADMAILS.
-
<em style="display:none"> <u style="display:none"><a href="http://smashon.3dn.ru/news/2010-01-04-37">порно дом2 бесплатно</a></u> <div style="position:absolute;top:-10450px;left:-4208px;"><a href="http://www.htmlkodlar.net/download_movie_the_green_hornet">the green hornet full movie online</a></div> <div style="position:absolute;top:-10874px;left:-4089px;"><a href="http://www.bxlblog.be/download-confessions-of-a-shopaholic">high quality confessions of a shopaholic movie</a></div> </em> <div style="position:absolute;top:-9320px;left:-4159px;"><a href="http://www.cucinanicolina.com/unforgiven-film">unforgiven download full film</a></div>
-
*insert
-
insert /G/ADMAILS from table it_admails_data.
-
*dequeue table
-
CALL FUNCTION 'DEQUEUE_E_TABLEE'
-
EXPORTING
-
mode_rstable = 'E'
-
tabname = '/G/ADMAILS'.
About
Leave a Comment