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 ONE Support launchpad (Login required).

Search for additional results

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