give me the corresponding statement for the below statement which should validate in sap datasphere IF(IN("COMP_CD",'6300','6400','6600'),("PO_QTY"*"VERPR"*if("MEINS"='CS',"ARTI_MEASURE_CS",1))/10,"PO_QTY"*"VERPR"*if("MEINS"='CS',"ARTI_MEASURE_CS",1))

To validate the provided statement in SAP Datasphere, the syntax needs to adhere to the specific SQL-like language used by the platform. Your original expression seems to be structured correctly for logic flow but may need some adjustments for clarity and functionality in the context of SAP's syntax. Here is a revised version of your statement, maintaining the intended logic but formatted for better adherence to potential syntactic rules in SAP Datasphere: ```sql IF(IN("COMP_CD", '6300', '6400', '6600'), ("PO_QTY" * "VERPR" * IF("MEINS" = 'CS', "ARTI_MEASURE_CS", 1)) / 10, ("PO_QTY" * "VERPR" * IF("MEINS" = 'CS', "ARTI_MEASURE_CS", 1)) ) ``` ### Explanation: 1. **IF**: This function checks if the "COMP_CD" is within the specified values ('6300', '6400', '6600'). 2. **IN**: This function checks if the value is part of the list provided. 3. **Calculations**: The calculations inside the IF statements remain the same, just formatted for better readability. 4. **Division**: The division by 10 only occurs if the condition is true (i.e., the "COMP_CD" is in the specified list). 5. **Use of proper quotes**: The double quotes around field names and single quotes around string literals are used as is common in SQL. When implementing this in your data model or calculation view in SAP Datasphere, ensure that the names of the columns (like `COMP_CD`, `PO_QTY`, `VERPR`, `MEINS`, and `ARTI_MEASURE_CS`) are exactly as they are in the underlying data model. Adjust them if necessary to match the actual field names.