COVP selection

[Former Member]

Hi All,

         When I execute the transaction KOB1 I am getting a run time error.

My current SAP FIN version is 617. I searched and did not find any relevant OSS notes for my version.

The run time error occurs in program SAPLKAEP include LKAEPFSL in  select COVP view.

Please could someone help.

Thanks & Regards,

Jenny

[Former Member]

Hi All,

         When I execute the transaction KOB1 I am getting a run time error.

My current SAP FIN version is 617. I searched and did not find any relevant OSS notes for my version.

The run time error occurs in program SAPLKAEP include LKAEPFSL in  select COVP view.

Please could someone help.

Thanks & Regards,

Jenny

[RaymondGiuseppi]

No authorized to read/display the pictures (Http 403) ?

Was there some information in ST22 or SM21 (e.g. two much selection criteria raising an error for SQL statement length overflow ?)

Regards,

Raymond

[Former Member]

Hi Raymond,

                The ST22 shows 'Time limit exceeded'. And the runtime error is hapening in the select endselect of COVP

SELECT (VT_FIELDS) INTO CORRESPONDING FIELDS OF GS_COVP_EXT

                         FROM (V_DB_TABLE)

                         WHERE LEDNR = '00'

                         AND   (ld_fields)

                         AND   GJAHR IN GR_GJAHR

                         AND   VERSN IN GR_VERSN

                         AND   WRTTP IN GR_WRTTP

                         AND   KSTAR IN LR_KSTAR

                         AND   PERIO IN GR_PERIO

                         AND   BUDAT IN GR_BUDAT

                         AND   PAROB IN GR_PAROB

                         AND   (VT_VAR_COND).

        CHECK GS_COVP_EXT-KOKRS = GD-KOKRS.

*       optimization of cost element ranges

        CHECK GS_COVP_EXT-KSTAR IN LR_KSTAR_OPT.

* Satrt of note 1607963-3/3: Zeitraumprüfung

        IF lv_auditor = 'X' AND sy-cprog = 'RKPEP003'.

          CALL FUNCTION 'CA_CHECK_DATE'

            EXPORTING

              i_applk           = 'PS-REP'

              i_orgunit         = gs_covp_ext-bukrs

              i_user            = sy-uname

              i_program         = sy-cprog

              i_from_date       = gs_covp_ext-budat

            EXCEPTIONS

              no_authority_date = 1

              no_authority_prog = 2

              wrong_parameter   = 3

              OTHERS            = 4.

          CHECK sy-subrc = 0.

        ENDIF.

* End of note 1607963-3/3: Zeitraumprüfung

*       delta version

        REFRESH: lt_cossa.

        MOVE-CORRESPONDING GS_COVP_EXT TO LT_COSSA.

        CALL FUNCTION 'K_DELTA_VERSNS_CHECK_ENTRY'

          EXPORTING

            DB_STRUCT = LT_COSSA

            TABNAME   = 'COSSA'

          TABLES

            DB_TABLE  = LT_COSSA

          EXCEPTIONS

            OTHERS    = 0.

        LOOP AT LT_COSSA.

          MOVE-CORRESPONDING LT_COSSA TO GS_COVP_EXT.

          APPEND GS_COVP_EXT TO GT_COVP_EXT.

        ENDLOOP.

*       collect master keys into global tables

        MOVE-CORRESPONDING GS_COVP_EXT TO LS_COVP.

        PERFORM COLLECT_MASTER_KEYS_COVP USING LS_COVP.

        PERFORM GUI_COUNTER TABLES GT_COVP_EXT

                            CHANGING LD_EXIT.

        IF NOT LD_EXIT IS INITIAL.

          EXIT.

        ENDIF.

      ENDSELECT.

This code is in include LKAEPFS.

Please let me know if you need any further information.

I am attaching the pictures again.

Thanks,

Jenny

[RaymondGiuseppi]

Not much to do in a standard program : look for OSS notes on performance, reduce selection (increase filtering) and execute in subset of data.

In a specific report, I would have answerer parallelize extraction, but not here.

Definitely mass extractions are not intended for interactive execution, in a long-term perspective try BW (OLAP) or execute the query in a background job.

Regards,

Raymond