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
- SAP S/4HANA 1709
Product
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.
SAP Knowledge Base Article - Preview