SAP Knowledge Base Article - Preview

2659622 - Manage Purchase Contract app returns no search results and dump raised in backend

Symptom

You are on S/4 HANA 1709. In the Manage Purchase Contract app, search returns no results. When you click on the create icon (the plus "+" icon), you get error "The requested data was not found", and the below dump is raised in the backend.

Category ABAP programming error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program CL_MM_PUR_OA_MAINTAIN_API=====CP
Application Component MM-PUR-OA-CON

Short Text
SQL error "SQL code: 314" occurred while accessing table "CCTRMAINTAIN".

Line SourceCde

1 METHOD if_mm_pur_oa_maintain~get_max_relevance.
2
3 DATA lv_read_cds TYPE abap_bool.
4 lv_read_cds = abap_false.
5 IF is_paging-skip EQ 0.
6 IF iv_search_string IS NOT INITIAL OR it_filter_select_options IS NOT INITIAL OR iv_fi
7 lv_read_cds = abap_true.
8 ENDIF.
9 ENDIF.
10
11 ** To handle the call from get_entity
12 IF it_contract_set IS INITIAL.
13 lv_read_cds = abap_true.
14 ENDIF.
15 IF lv_read_cds EQ abap_true.
>>>>> SELECT MAX( weightedrelevance ) FROM cctrmaintain INTO ev_highest_relevance.
17 ELSE.
18 READ TABLE it_contract_set INTO DATA(ls_first_contract) INDEX 1.
19 ev_highest_relevance = ls_first_contract-weightedrelevance.
20 ENDIF.
21 ENDMETHOD.


Read more...

Environment

  • Fiori Launchpad
  • Manage Purchase Contracts
  • SAP S/4HANA 1709

Product

SAP Fiori for SAP S/4HANA 1709 ; SAP S/4HANA 1709

Keywords

fiori, manage, purchase, contract, app, application, search, result, not, found, dump, backend, back, end, CCTRMAINTAIN, plus, +, create, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, CL_MM_PUR_OA_MAINTAIN_API=====CP, 314, s/4, s4, 1709 , KBA , MM-FIO-PUR-SQ-CON , Fiori UI for Manage Purchase Contracts , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.