Skip to Content

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

MAM30_070 performance issue

Hello,

We have serious performance problems between middleware and backend.

The selection of the inventory takes 70sec for 1 sync.... This is way too much.

For the selection of the inventory we have 4800 entries in MAM30_070_GETLIST.

I wrote a little testprogram to measuer the time needed for selection:

*&---------------------------------------------------------------------*
*& Report  ZJVB_TEST_MAM30_070
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  ZJVB_TEST_MAM30_070.

data: itab type TABLE OF MAM_30_INVENTORY_MNG_ITEM,
      wa like LINE OF itab,
      g_start type i,g_end type i,g_start_2 type i,
      g_aantal type i,
      g_detail type i,
      w_counter type i.

get RUN TIME FIELD g_start.

CALL FUNCTION 'MAM30_070_GETLIST'
 EXPORTING
   USER                 = 'CRMJV'
 TABLES
   INVENTORY_LIST       = itab
*   RETURN               =
          .

get RUN TIME FIELD g_start_2.
describe TABLE itab LINES g_aantal.

LOOP AT itab INTO wa .
  CALL FUNCTION 'MAM30_070_GETDETAIL'
    EXPORTING
      USER                 = 'CRMJV'
      MATERIAL             = wa-material
      SERIALNO             = wa-serialno
      EQUIPMENT            = wa-equipment
*   IMPORTING
*     INVENTORY_ITEM       =
*   TABLES
*     CE_INVENTORY         =
*     RETURN               =
*     WSAP_EXTENSION       =
            .
  add 1 to w_counter.
ENDLOOP.

get RUN TIME FIELD g_end.

write:/ 'Start:', g_start.
write:/ 'Na getlist:' , g_start_2.
write:/ 'Aantal watermeters:', g_aantal.

write:/.

write:/ 'Na getdetail:', g_end.
g_detail = g_end - g_start_2.
write:/ 'Tijd nodig voor selectie detail:', g_detail.

To my surprise in the backend the program only runs 10sec. Where are the other 60sec used for? What can I tune?

Kind regards,

jeroen

Former Member

Helpful Answer

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