give me the corresponding statement for the below statement which should validate in sap datasphere IF ( IN("COMP_CD",'6300','6400','6600','6500') , IF("WAERS" = 'OMR', "PO_RCPT_DC_CALC"/10, IF("WAERS" = 'AED', -1*"PO_RCPT_DC_CALC"/"PO_RCPT_EXCHG_RTE", "
To convert the provided statement into a syntax that would validate in SAP Datasphere, you would typically need to make adjustments to ensure that the structure and functions are compatible with the SQL-like language used in Datasphere.
Here’s a restructured version of the original statement that should work in SAP Datasphere:
```sql
CASE
WHEN "COMP_CD" IN ('6300', '6400', '6600', '6500') THEN
CASE
WHEN "WAERS" = 'OMR' THEN "PO_RCPT_DC_CALC" / 10
WHEN "WAERS" = 'AED' THEN -1 * "PO_RCPT_DC_CALC" / "PO_RCPT_EXCHG_RTE"
ELSE "PO_RCPT_DC_CALC" * "PO_RCPT_EXCHG_RTE"
END
ELSE
CASE
WHEN "WAERS" = 'AED' THEN "PO_RCPT_DC_CALC"
ELSE "PO_RCPT_DC_CALC" * "PO_RCPT_EXCHG_RTE"
END
END
```
### Explanation:
- **CASE Statement:** This is used to handle conditional logic in SQL-like queries. Within it, you can specify multiple conditions and corresponding results.
- **IN Operator:** This checks if the value in `"COMP_CD"` is one of the specified values.
- **Nested CASE Statements:** This allows for more complex conditional logic, similar to the nested IF statements in your original snippet.
Make sure that the column names (`COMP_CD`, `WAERS`, `PO_RCPT_DC_CALC`, `PO_RCPT_EXCHG_RTE`) exactly match those used in your SAP Datasphere model to avoid any execution errors.