SAP Knowledge Base Article - Preview

2486758 - Error [2620] plan operation failed; Currency/unit conversion error

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

SAP Fiori all versions ; SAP Fiori for SAP S/4HANA all versions ; SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions ; SAP S/4HANA all versions

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.