COVP selection

Former Member — Mon, 22 Feb 2016 14:48:35 GMT

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

Re: COVP selection

RaymondGiuseppi — Mon, 22 Feb 2016 15:05:06 GMT

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

Re: COVP selection

Former Member — Mon, 22 Feb 2016 15:37:34 GMT

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

Re: COVP selection

RaymondGiuseppi — Mon, 22 Feb 2016 15:54:29 GMT

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

topic Re: COVP selection in Application Development and Automation Discussions

COVP selection

Re: COVP selection

Re: COVP selection

Re: COVP selection