4 Replies Latest reply: Feb 28, 2013 12:59 PM by amine lamkaissi RSS

Opinion on that abap code

amine lamkaissi
Currently Being Moderated

Hi experts,

 

In BW, i am inserting with an abap code some data to a custom SE11 table (ycnv_report)

I am calculating data with three different internal tables and i regroup all data in one internal table from which i am inserting data into my custom sap table.

 

REFRESH wt_report_final.

 

   INSERT LINES OF wt_report2 INTO TABLE wt_report_final.

   REFRESH wt_report2.

   INSERT LINES OF wt_report_x2  INTO TABLE wt_report_final.

   REFRESH wt_report_x2 .

   INSERT LINES OF  wt_report_y2 INTO TABLE wt_report_final.

   REFRESH wt_report_y2.

 

   SORT wt_report_final BY comp_code costcenter chrt_accts gl_account costelmnt /bic/y_tprtnr co_area profit_center y_labbu y_labdiv y_program part_prctr y_labprbu y_ptnrdiv doc_currcy loc_currcy fiscper version.

   DELETE ADJACENT DUPLICATES FROM wt_report_final COMPARING comp_code costcenter chrt_accts gl_account costelmnt /bic/y_tprtnr co_area profit_center y_labbu y_labdiv y_program part_prctr y_labprbu y_ptnrdiv doc_currcy loc_currcy fiscper version.

*  DELETE ADJACENT DUPLICATES FROM wt_report_final COMPARING ALL FIELDS.

 

   IF NOT wt_report_final IS INITIAL.

     INSERT ycnv_report FROM TABLE wt_report_final.

   ENDIF.

 

 

I made tests in DEV, it's working fine.

But before transporting, i would like to know your opinion and any possiblities of enhancements. In Production i have more data to treat and in few years my program will deal with many millions of records.

 

By the way, is there any settings that you recommand me to my SE11 table in my case?

 

Thanks for your help.

 

Amine

Actions