When I execute the following SQL statement, the error occurs "No component exists with the name "CASE""
`SELECT
SUM( CASE ekbe~shkzg
WHEN 'S' THEN ekbe~menge
ELSE ekbe~menge * -1
END ) AS menge_1 ,
"ekbe~shkzg, "借贷
ekbe~lfgja, "参考凭证年度
ekbe~lfbnr, "参考凭证号
ekbe~lfpos "参考凭证项目号
FROM ekbe
WHERE ( ekbe~vgabe = '2' OR ekbe~vgabe = 'P' )
AND ekbe~ebeln = '4500039948' "gt_out-ebeln
GROUP BY lfgja, lfbnr, lfpos`
HI,
When I execute the following SQL statement, the error occurs "No component exists with the name "CASE""
`SELECT
SUM( CASE ekbe~shkzg WHEN 'S' THEN ekbe~menge ELSE ekbe~menge * -1 END ) AS menge_1 , "ekbe~shkzg, "借贷 ekbe~lfgja, "参考凭证年度 ekbe~lfbnr, "参考凭证号 ekbe~lfpos "参考凭证项目号 FROM ekbe WHERE ( ekbe~vgabe = '2' OR ekbe~vgabe = 'P' ) AND ekbe~ebeln = '4500039948' "gt_out-ebeln GROUP BY lfgja, lfbnr, lfpos`
BEST WISHS, Cooper