Symptom
- When accessing the Manage Purchase Orders App the system is returning the error: SQL 2048 error while accessing table C_PURORDMAINTAINHEADERSLIST.
- When accessing other Apps, such as Purchase Order Value, system cannot load tile, givving an error similar to: column store error: search table error: [2620] executor: plan operation failed;currency/unit conversion error,Conversion
- Eventually you can receive a short dump in ECC side:
DBSQL_SQL_ERROR
Exception: CX_SY_OPEN_SQL_DB
ABAP program: CL_MM_PUR_PO_MAINTAIN_DPC_EXT=CP
in the following code:
* select calculated fields from CDS view
SELECT list~purchaseorder,
list~statuskey,
status_text~purchasingdocumentstatusname,
list~purchaseordernetamount,
list~editstate,
rel~weightedrelevance
FROM c_purordmaintainheaderslist AS list
LEFT OUTER JOIN i_purchaseorderrelevance AS rel ON list~purchaseorder
LEFT OUTER JOIN i_purchasingdocumentstatustext AS status_text ON status_text~purcha
AND status_text~langua
FOR ALL ENTRIES IN @et_entityset WHERE list~purchaseorder = @et_entity
INTO TABLE @lt_cds_header_list.
Read more...
Environment
- SAP Fiori
- SAP Fiori for SAP S/4HANA
- SAP S/4HANA
- SAP S/4HANA Cloud Public Edition
Product
Keywords
F1378, F0842, FIORI, S4H, S4HANA, S/4HANA, S/4H, CLOUD, HANA, MM_PO_CRES1, MM_PUR_PO_MAINTAIN, POHEADERLISTS_GET_ENTITYSET, CX_SY_OPEN_SQL_DB, CL_MM_PUR_PO_MAINTAIN_DPC_EXT=CP, DBSQL_SQL_ERROR, C_PURORDMAINTAINHEADERSLIST, CL_MM_PUR_PO_MAINTAIN_DPC_EXT=CM022, C_PURORDVALUEWITHPLND_CDS, C_PURGSPENDOFFCONTRACT_CDS, INVALID CONVERSION TYPE , KBA , MM-FIO-PUR-PO , Fiori UI for Purchase Orders , MM-PUR-PO , Purchase Orders , 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.