Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

call function RV_FTT_GOV_ISSUE_LOG_SEL_REP:PERFORMANCE ISSUE

Former Member

‎2008 Nov 11 9:39 AM

0 Likes
350

Hello everybody,

One of the report uses this function module and its very slow due to poor performance.

When i did the run time analysis i could see that at this function module its consuming more time.

Please suggest how to optimize it and improve its performance.

Thanks in advance

Akmal

...

CONSTANTS:false TYPE c VALUE ' '.
FORM selection_logs_issue
            TABLES pt_incomp_header TYPE v50g_incompletion_data
                   pt_incomp_item   TYPE v50g_incompletion_data
                   pt_selection_log TYPE v50g_selection_log
            USING  ps_alv_variant            LIKE disvariant
                   pv_reporting_type         TYPE v50g_i_reporting_type
                   pv_direction              LIKE veiav-arrivdepa
                   pv_reporting_year         LIKE veiav-datumjahr
                   pv_reporting_month        LIKE veiav-datummona
                   pv_reporting_country_iso2 LIKE t005-intca
                   pv_sel_log_type           TYPE c
                   pv_selection_report_name  LIKE sy-cprog.

  CALL FUNCTION 'RV_FTT_GOV_ISSUE_LOG_SEL_REP'
    EXPORTING
      flow_of_goods            = pv_direction
      flg_simulation           = false
      reporting_type           = pv_reporting_type
      log_type                 = pv_sel_log_type
      reporting_month          = pv_reporting_month
      reporting_year           = pv_reporting_year
      variant                  = ps_alv_variant
      country                  = pv_reporting_country_iso2
      calling_program          = pv_selection_report_name
    TABLES
      selection_log            = pt_selection_log
      incompletion_data_header = pt_incomp_header
      incompletion_data_item   = pt_incomp_item
    EXCEPTIONS
      wrong_reporting_type     = 1
      OTHERS                   = 2.

  IF sy-subrc <> 0.
    MESSAGE w083(eip) WITH '011'.
ENDIF.

Hello everybody,

One of the report uses this function module and its very slow due to poor performance.

When i did the run time analysis i could see that at this function module its consuming more time.

Please suggest how to optimize it and improve its performance.

Thanks in advance

Akmal

...

CONSTANTS:false TYPE c VALUE ' '.
FORM selection_logs_issue
            TABLES pt_incomp_header TYPE v50g_incompletion_data
                   pt_incomp_item   TYPE v50g_incompletion_data
                   pt_selection_log TYPE v50g_selection_log
            USING  ps_alv_variant            LIKE disvariant
                   pv_reporting_type         TYPE v50g_i_reporting_type
                   pv_direction              LIKE veiav-arrivdepa
                   pv_reporting_year         LIKE veiav-datumjahr
                   pv_reporting_month        LIKE veiav-datummona
                   pv_reporting_country_iso2 LIKE t005-intca
                   pv_sel_log_type           TYPE c
                   pv_selection_report_name  LIKE sy-cprog.

  CALL FUNCTION 'RV_FTT_GOV_ISSUE_LOG_SEL_REP'
    EXPORTING
      flow_of_goods            = pv_direction
      flg_simulation           = false
      reporting_type           = pv_reporting_type
      log_type                 = pv_sel_log_type
      reporting_month          = pv_reporting_month
      reporting_year           = pv_reporting_year
      variant                  = ps_alv_variant
      country                  = pv_reporting_country_iso2
      calling_program          = pv_selection_report_name
    TABLES
      selection_log            = pt_selection_log
      incompletion_data_header = pt_incomp_header
      incompletion_data_item   = pt_incomp_item
    EXCEPTIONS
      wrong_reporting_type     = 1
      OTHERS                   = 2.

  IF sy-subrc <> 0.
    MESSAGE w083(eip) WITH '011'.
ENDIF.

Reply
1 REPLY 1
Read only

Former Member

‎2008 Nov 12 4:45 AM

0 Likes
308

Hi,

Regarding the performance issue which you are facing in the Function Module : RV_FTT_GOV_ISSUE_LOG_SEL_REP what you need to do is follow the following steps :

1. First Put an SQL Trace on the transaction code and check whether which particular query is taking time and whether it is the query inside the function module.

2. Also do the Run time Analysis for the transaction code and if possible do the ST12 analysis that will help you to do the analysis for both SQL and Runtime Analysis.

3. After analysing these things you need to write to SAP regarding that by creating an OSS Message and for this function module performance with your analysis.

4. SAP Support will reply you if they have faced the similar issue with some other client and otherwise they will provide you solution how you can solve the performance problem.

Regards,

Harsh