Skip to Content
Former Member
Jan 17, 2018 at 11:42 AM

SAP Hana FMS query problem


Hello all,

I have the following query that I use in a FMS to populate a column named location (names of cities).

It works well until the city '015' is selected, then nothing is populated in the columns. I want to force '010' to be populated when '015' is selected in the header. For all other values, the column populates well.

What could be the problem?

SELECT (CASE T0."U_Location" WHEN '015' THEN '010' ELSE T0."U_Location" END) AS "Location"FROM OINV T0 WHERE T0."U_Location" = $[OINV."U_Location"]