SAP business one 查询管理器变量参数写法（SQL&HANA）

原创已于 2025-03-25 18:41:28 修改 · 551 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #SAP #经验分享

于 2024-11-04 15:33:54 首次发布

SAP Business one 专栏收录该内容

26 篇文章

订阅专栏

SAP business one 查询管理器变量参数写法（SQL&HANA）

SQL 版写法：


--大于等于写法
DECLARE @BDate AS date;
SET @BDate =/*SELECT  FROM OINV T0 WHERE T0."DocDate" >= */ '[%0]';

--小于等于写法
DECLARE @EDate AS date;
SET @EDate =/*SELECT  FROM OINV T0 WHERE T0."DocDate" <= */ '[%1]';

--等于写法
DECLARE @Warehouse AS NVARCHAR(8);
SET @Warehouse =/*SELECT  FROM INV1 T1 WHERE T1."WhsCode" = */ '[%2]';

--LIKE写法
DECLARE @Dscription AS NVARCHAR(254);
SET @Dscription =/*SELECT  FROM INV1 T3 WHERE T3."Dscription" LIKE */ '%%[%4]%%';

--然后可以在查询语句里使用以上变量
SELECT * FROM OINV T0
INNER JOIN INV1 T1 ON T0."DocEntry" = T1."DocEntry"
WHERE T0."DocDate" >= @BDate --大于等于
AND T0."DocDate" <= @EDate --小于等于
AND (T1."WhsCode" = @Warehouse OR @Warehouse = '') --等于或者没有输入条件
AND (T1."Dscription" LIKE @Dscription  OR @Dscription  = '') --LIKE或者没有输入条件
;

HANA版写法


--大于等于写法
DECLARE BDate date;
BDate :=/*SELECT  FROM OINV T0 WHERE T0."DocDate" >= */ '[%0]';

--小于等于写法
DECLARE EDate date;
EDate :=/*SELECT  FROM OINV T0 WHERE T0."DocDate" <= */ '[%1]';

--等于写法
DECLARE Warehouse NVARCHAR(8);
Warehouse :=/*SELECT  FROM INV1 T1 WHERE T1."WhsCode" = */ '[%2]';

--LIKE写法
DECLARE Dscription NVARCHAR(254);
Dscription :=/*SELECT  FROM INV1 T3 WHERE T3."Dscription" LIKE */ '%%[%4]%%';

--然后可以在查询语句里使用以上变量
SELECT * FROM OINV T0
INNER JOIN INV1 T1 ON T0."DocEntry" = T1."DocEntry"
WHERE T0."DocDate" >= BDate --大于等于
AND T0."DocDate" <= EDate --小于等于
AND (T1."WhsCode" = Warehouse OR Warehouse = '') --等于或者没有输入条件
AND (T1."Dscription" LIKE Dscription  OR Dscription  = '') --LIKE或者没有输入条件
;