SELECT*FROM (SELECT e.ROLE,e.USERNAME,d.ZXZTJ,

 CASE WHEN d.ZXZTJ LIKE '%集团%' THEN '1'

  WHEN d.ZXZTJ LIKE '%物业公司%' THEN '2'

  WHEN d.ZXZTJ LIKE '%恒大%' THEN '3' ELSE '0' 

  END AS 'A', d."4ZRCPWY0005_ZSF",

  d."ZXZTJ",

  sum(d."ZSYDFYK") AS d."ZSYDFYK"

 FROM "_SYS_BIC"."system-local.bw.bw2hana.query.zrcpwy0005/ZRCPWY0005_Q014" d

 LEFT JOIN ( SELECT a.USERNAME, a.ROLE, b.PERMISSIONS FROM "SAPABAP1"."/BIC/CM1ZTD_DIS00004000001" a

  left join "SAPABAP1"."/BIC/CM1ZTD_DIS00005000001" b 

 ON a.ROLE = b.ROLE ) e 

 ON e.PERMISSIONS=d.ZXZTJ 

WHERE 1=1 AND e.USERNAME='${fr_username}' ${IF( len ( province2 ) = 0 || province2 = '集团', "and ZXZTJ='集团'", "and ZXZTJ='" + province2 + "'" ) } ) f 

WHERE A=( SELECT MIN ( A ) FROM (SELECT e.ROLE,e.USERNAME,d.ZXZTJ,

 CASE WHEN d.ZXZTJ LIKE '%集团%' THEN '1'

  WHEN d.ZXZTJ LIKE '%物业公司%' THEN '2'

  WHEN d.ZXZTJ LIKE '%恒大%' THEN '3' ELSE'0' END AS 'A',

 d. "4ZRCPWY0005_ZSF",

  d."ZXZTJ",

  d.sum(d."ZSYDFYK") AS d."ZSYDFYK"

 FROM "_SYS_BIC"."system-local.bw.bw2hana.query.zrcpwy0005/ZRCPWY0005_Q014" d

 LEFT JOIN ( SELECT a.USERNAME, a.ROLE, b.PERMISSIONS from "SAPABAP1"."/BIC/CM1ZTD_DIS00004000001" a

 left join "SAPABAP1"."/BIC/CM1ZTD_DIS00005000001" b 

 ON a.ROLE = b.ROLE ) e 

 ON e.PERMISSIONS=d.ZXZTJ 

WHERE 1=1 

AND e.USERNAME ='${fr_username}' ${IF( len ( province2 ) = 0 || province2 = '集团', "and ZXZTJ='集团'", "and ZXZTJ='" + province2 + "'" ) } 

 ) f ) 

这个哪里有问题，这个在orcal里可以远行，在hana里就不行了，是不是语法问题还是格式