Skip to Content
0

SAP Lumira Freehand SQL - CASE statement

Nov 21, 2016 at 08:13 AM

66

avatar image
Former Member

Hi!
I try to use a CASE -statement in the Freehand SQL but get stucked with the coding;

select
"VBUK-UVALL" AS "Header Status",
CASE "VBUK-UVALL"
WHEN 'A' THEN 'Incomplete'
ELSE 'Complete'
END AS "ColumnA"
from "Local"."INFOSET"."ZCA_TESTAR"

Can anyone help me out?

All the best
Anders

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers