Performance issue with tcode SUIM>change documents> For users

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

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.

[Former Member]

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.

[apoeschl]

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