2486758 - Error [2620] plan operation failed; Currency/unit conversion error | SAP Knowledge Base Article

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

Product

SAP Fiori all versions ; SAP Fiori for SAP S/4HANA 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 ONE Support launchpad (Login required).

Search for additional results

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