topic Re: Performance issue with tcode SUIM>change documents> For users in Application Development and Automation Discussions

Performance issue with tcode SUIM>change documents> For users

Former Member — Thu, 19 Apr 2012 05:25:44 GMT

Hi ,

Its taking more time when i am running tcode SUIM >Change Documents>for Users report.

I ran ST05 and found that its taking more time in fecthing data from 'CDCLS' cluster table.

Please let me how to improve its performance.

Thanks

Netra

Re: Performance issue with tcode SUIM>change documents> For users

Former Member — Thu, 19 Apr 2012 06:34:25 GMT

Hi,

can you please paste the code which is used to fetch the data fron yhis table.

Re: Performance issue with tcode SUIM>change documents> For users

Former Member — Thu, 19 Apr 2012 08:37:38 GMT

Hi,

Please find the code below.

      SELECT * FROM cdhdr APPENDING TABLE pt_cdhdr
             WHERE objectclas IN pt_sl_objectclas
             AND   objectid   IN pt_sl_objectid
             AND   changenr   IN pt_sl_changenr
             AND   username   IN pt_sl_username
             AND (
                  (
                    udate = date_of_change
                    AND
                    utime >= time_of_change
                   )
                   OR
                    udate > date_of_change
                  )
             AND (
                  (
                    udate = date_until
                    AND
                    utime <= time_until
                   )
                   OR
                    udate < date_until
                 ).
ENDIF.

    SELECT * FROM cdpos CLIENT SPECIFIED APPENDING TABLE pt_cdpos
           FOR ALL ENTRIES IN pt_cdhdr
           WHERE mandant    EQ pt_cdhdr-mandant
           AND   objectclas EQ pt_cdhdr-objectclas
           AND   objectid   EQ pt_cdhdr-objectid
           AND   changenr   EQ pt_cdhdr-changenr
           AND   tabname    IN pt_sl_tabname
           AND   tabkey     IN pt_sl_tabkey.

Re: Performance issue with tcode SUIM>change documents> For users

apoeschl — Thu, 19 Apr 2012 10:54:28 GMT

Hi,

as I don't know on which release you are, I can only recommend to have a look at the following SAP Note:

1668742

Regards,
Andreas

Re: Performance issue with tcode SUIM>change documents> For users

Former Member — Thu, 19 Apr 2012 12:14:52 GMT

As this is in standard code, searching SAP note is standard solution.

other work around is, see if you can create secindary indices in the tables CDPOS and CHDDR.

Hope this helps.