SAP Knowledge Base Article - Public

2891800 - Error SQL code 719 happens in application Monitor Purchase Order Items

Symptom

Error SQL code 719 below happens in application 'Monitor Purchase Order Items'.

500,Internal Server Error,{"error":{"code":"SY/530","message":{"lang":"en","value":"Database returned the SQL code 719. Error text: currency/unit conversion error: search table error: Conversion( \"COL$40$\", \"COL$41$\" ), row 23560: could not determine valid conversion rate for value(s) 5000, 5000 from unit '' to unit 'USD' on date

Environment

  • Sourcing and Procurement
  • SAP S/4HANA Cloud Public Edition 1905

Reproducing the Issue

1. Open application 'Monitor Purchase Order Items'

2. Select the currency USD

3. Press Go to shown the entrys

Cause

The issue occurs for Purchase Orders with status 'Draft' and Order Currency stored as empty. No valid Currency unit is stored for such Purchase Orders.

Resolution

We are currently discussing for an optimum solution for such use case.

As a workaround please remove these PO without a Net Value and Currency or enter a value to avoid blank Net Value and Currency.

Keywords

S4, HANA, SQL code 719, Monitor Purchase Order Items , conversion , KBA , CA-GTF-FXU-MM-PUR , Fiori UI by FXU for MM-FIO-PUR , Problem

Product

SAP S/4HANA Cloud 1911