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