SAP b1查询日期输入不使用join

Question

我正在尝试从两个表OINV和INV1中提取发票数据。我需要查询为我提供指定日期范围的结果。下面是我的问题：

SELECT T0."DocDate", T0."NumAtCard", T0."CardName", T1."ItemCode", T1."Quantity", T1."Price", T0."DocTotal" 
FROM "OINV"  T0 LEFT JOIN
     INV1 T1
     ON T0."DocEntry" = T1."DocEntry" 
WHERE T0."CANCELED"  = 'N',  T0."DocDate" >=[%0] AND  T0."DocDate" <=[%1]

当我执行它时，它不会要求输入日期，也不会返回任何东西。当我单独使用OINV表时，日期输入工作得很好，但当我进行连接时就不行了。你知道为什么会发生这种情况吗？

Answer 1

查询：

SELECT T0."DocDate", T0."NumAtCard", T0."CardName", T1."ItemCode", T1."Quantity", T1."Price", T0."DocTotal" 
FROM "OINV"  T0 LEFT JOIN
     INV1 T1
     ON T0."DocEntry" = T1."DocEntry" 
WHERE T0."CANCELED"  = 'N' AND  T0."DocDate" >=[%0] AND  T0."DocDate" <=[%1]

在我的系统上工作正常

删除","并添加"AND"

Answer 2

删除所有列中的"“。

SELECT T0.DocDate, T0.NumAtCard, T0.CardName, T1.ItemCode, T1.Quantity, T1.Price, T0.DocTotal
FROM OINV  T0 LEFT JOIN
     INV1 T1
     ON T0.DocEntry = T1.DocEntry 
WHERE T0.CANCELED  = 'N' AND  T0.DocDate >=[%0] AND  T0.DocDate <=[%1]

Answer 3

在你的代码之前添加这个

 /*SELECT * FROM OINV T0*/
declare @FromDate date
declare @ToDate date
/* WHERE */
set @FromDate = /* T0.DocDate */‘[%0]’
set @ToDate =/* T0.DocDate */ ‘[%1]’