Termination Date FMS to get End Date if Status is Terminated

[wiz_traceremo]

Hi All Experts,

I am trying to create FMS in Termination Date under Sales Blanket Agreement wherein it will get the value in End Date field if the Status is changed to Terminated but its not getting the correct value.

SELECT T0."EndDate" FROM OOAT T0 WHERE T0."Status" ='F'

We are in SAP B1 Hana. Any suggestions pls. thanks.

[hdolenec]

Try this, set to refresh when field changes Agreement Status

SELECT CASE WHEN $[$1250000036.0.0] = 'T' THEN $[$1250000016.0.0] ELSE $[$1250000022.0.0] END FROM DUMMY