Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sytax Error in SAP HANA

hello evryone,

IF $[$38."U_CustomRate".Number] = 10 THENĀ 

SELECT $[$38."U_AssessValue".Number] / 1.1 FROM DUMMY;

ELSE IF $[$38."U_CustomRate".Number] = 7.5 THEN

SELECT $[$38."U_AssessValue".Number] / 1.075 FROM DUMMY;

ELSE SELECT $[$38."U_AssessValue".Number] / 1.05 FROM DUMMY;

END IF;END IF;

when i applied this FMS For assessable value in Purchase Order This is not showing the result in that column.

Could you please help me for this query.

Former Member
replied

Hi,

Try this:

IF ($[POR1."U_CustomRate".Number] = '10') THEN

(SELECT $[POR1."U_AssessValue".Number]/'1.1' FROM DUMMY);

ELSEIF ($[POR1."U_CustomRate".Number] = '7.5') THEN

(SELECT $[POR1."U_AssessValue".Number] / '1.075' FROM DUMMY);

ELSE

(SELECT $[POR1."U_AssessValue".Number] / '1.05' FROM DUMMY);

END IF;

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question