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.
SAP Knowledge Base Article - Preview