Shared Top Border

Enterprise Resource
Planning Portal

 

Advertise | Founder BLOG

ERPGenie.COM ABAP Tips and Tricks Database

THE ultimate
ERP website

 

Forums | Vote for us |

Google    Other Search Options

Home arrow Tips and Tricks arrow ABAP Reports arrow Accessing data in Packages
Accessing data in Packages PDF Print E-mail
User Rating: / 0
PoorBest 
Written by Anon.   
Tuesday, 13 March 2007
Selectct, delete and Insert Statement described... SELECT Statement
Consider using PACKAGE SIZE in SELECT statement when size of resultant itab is significant in size (e.g. when row width and volume of rows is large). Instead of retrieving all data in one select statement a select loop is executed multiple times providing a data package for each loop.
    
  • Do not use APPENDING TABLE with PACKAGE SIZE.
  • The use of PACKAGE SIZE is not recommended if FOR ALL ENTRIES is being used because FAEI defines it’s own package size

    
    Example:
    
    SELECT VBELN PSTYV VGBEL VGPOS FROM LIPS
           INTO TABLE T_LIPS
           PACKAGE SIZE 10000.
    
      LOOP AT T_LIPS.
        …….
      ENDLOOP.
    ENDSELECT.
    
    In this example 10,000 lines are added to the internal table T_LIPS during each select loop.
    
DELETE Statement
Consider using explicit packet technique in DELETE statement when size of driver itab is significant (e.g. when row width and volume of rows is large).
    Example:
    
    DO.
       IF v_current_index >= v_del_lines.
    
         EXIT.
       ENDIF.
    
       FREE t_temp_par_delete[].
       APPEND LINES OF t_par_delete FROM v_start_index TO v_end_index
                                    TO t_temp_par_delete.
    
       v_current_index = v_current_index + p_delpak.
    
    *  Delete the entries in ztmm_par_agg from the internal table
       DELETE ztmm_par_agg FROM TABLE t_temp_par_delete.
       
       COMMIT WORK.
       
       v_start_index = v_start_index + p_delpak.
       v_end_index = v_start_index + p_delpak - 1.
    ENDDO.

  Insert Statement
Consider using explicit packet technique in INSERT statement when size of driver itab is significant (e.g. when row width and volume of rows is large).
Example:
      DO.
    
    
        IF v_current_index >= v_ins_lines.
          EXIT.
        ENDIF.
    
        FREE t_temp_par_insert[].
    
        APPEND LINES OF rt_par_agg FROM  v_start_index TO v_end_index
           TO    t_temp_par_insert.
    
        v_current_index = v_current_index + p_inspak.
    
    *   Insert the entries into ztmm_par_agg from the internal table
        INSERT ztmm_par_agg FROM TABLE t_temp_par_insert.
        IF sy-subrc = 0.
          COMMIT WORK.
        ELSE.
          MESSAGE e001 WITH 'ZTMM_PAR_AGG'(002).
        ENDIF.
    
        v_start_index = v_start_index + p_inspak.
        v_end_index   = v_start_index + p_inspak - 1 .
    
      ENDDO.               


Related Items:

 
< Prev   Next >

Google Search

Google Ads

Shared Bottom Border

Contact Us | Polls | Add URL | Contribute | Privacy | Terms | Feedback

Discussion Forum | BLOG | Consultants: Post your resume | Companies: Advertise on ERPGenie.COM | Post Job
Financials Consultant | Consultant Review | Gallia Consulting | Supply Chain Project | SAP Financials Forum
GenieHoldings.COM, Inc. | Genie Press | WorkflowGenie | ESAGenie | ERPTopSites | ABAP Tips and Tricks | SAP Solutions Database

EDIGenie | Searching Survivor