Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

FILTER OPTION NOT WORKING

former_member902308
Member

‎2023 Mar 21 11:24 AM

0 Likes
700
  • SAP Managed Tags
  • SQL

DECLARE FromDate Date;

DECLARE ToDate Date;

FromDate:=/*select Min(T0.DocDate) from "ORCT" T0*/'[%0]';

ToDate:=/*select Max(T0.DocDate) from "ORCT" T0*/ '[%1]';

SELECT T0."DocDate",T0."DocNum", T0."CardCode", T0."CardName", T0."TrsfrAcct", T0."TrsfrSum", T0."Ref1", T0."Ref2", T0."Comments", T0."JrnlMemo", T0."TransId", T0."BoeNum", T0."PayToCode"

FROM ORCT T0;

DECLARE FromDate Date;

DECLARE ToDate Date;

FromDate:=/*select Min(T0.DocDate) from "ORCT" T0*/'[%0]';

ToDate:=/*select Max(T0.DocDate) from "ORCT" T0*/ '[%1]';

SELECT T0."DocDate",T0."DocNum", T0."CardCode", T0."CardName", T0."TrsfrAcct", T0."TrsfrSum", T0."Ref1", T0."Ref2", T0."Comments", T0."JrnlMemo", T0."TransId", T0."BoeNum", T0."PayToCode"

FROM ORCT T0;

Reply
1 REPLY 1
Read only

SonTran
Active Contributor

‎2023 Mar 21 12:31 PM

0 Likes
580
  • SAP Managed Tags
  • SQL

Hi,

You miss the WHERE clause, try this:

DECLARE FromDate Date;

DECLARE ToDate Date;

FromDate:=/*select Min(T0.DocDate) from "ORCT" T0*/'[%0]';

ToDate:=/*select Max(T0.DocDate) from "ORCT" T0*/ '[%1]';

SELECT T0."DocDate",T0."DocNum", T0."CardCode", T0."CardName", T0."TrsfrAcct", T0."TrsfrSum", T0."Ref1", T0."Ref2", T0."Comments", T0."JrnlMemo", T0."TransId", T0."BoeNum", T0."PayToCode"

FROM ORCT T0
WHERE T0."DocDate" between :FromDate and :ToDate;

Hope this helps,

Son Tran

Hope this helps,
Son Tran