topic Sy-datum in Select statement in Application Development and Automation Discussions

Sy-datum in Select statement

Former Member — Fri, 19 Feb 2010 18:16:21 GMT

how to use Sy-datum field in Select statement to get the date 3 days back.I know in this way.

data: prev_date like vbak-erdat.

prev_date = sy-datum - 3 .

But i want to write with SY-DATUM in the Select statement directly. How can we do this ?

DATA: IVBAk TYPE TABLE OF VBak WITH HEADER LINE.
SELECT  VBELN FROM VBAK INTO CORRESPONDING FIELDS OF TABLE IVBAk
  WHERE ERDAT >= ((SY-DATUM)-3). ???

Re: Sy-datum in Select statement

Former Member — Fri, 19 Feb 2010 18:21:50 GMT

U cannot directly use this way ...

SELECT VBELN FROM VBAK INTO CORRESPONDING FIELDS OF TABLE IVBAk

WHERE ERDAT >= ((SY-DATUM)-3). ???

Re: Sy-datum in Select statement

Former Member — Fri, 19 Feb 2010 18:23:19 GMT

Why do you want to do it that way?

rob

Re: Sy-datum in Select statement

Former Member — Fri, 19 Feb 2010 18:24:12 GMT

try the below one.

DATA: prev_date type sy-datum.

prev_date = ( SY-DATUM - 3 ).

SELECT VBELN FROM VBAK INTO CORRESPONDING FIELDS OF TABLE IVBAk

WHERE ERDAT >= prev_date.

Re: Sy-datum in Select statement

Former Member — Fri, 19 Feb 2010 18:28:01 GMT

I am writing a program to execute Open SQL statements dynamically, So i want to get the records which were created (SY-datum) - (number of days).

Re: Sy-datum in Select statement

Former Member — Fri, 19 Feb 2010 19:01:02 GMT

Why don't you declare a parameter for number of days on selection-screen.

Declare a variable to receive the result of Sy-datum - p_days.

And use this result on select.

EX:

selection-screen .....

parameter p_day(2) type n.

DATA: IVBAk TYPE TABLE OF VBak WITH HEADER LINE,

v_diff type sy-datum.

v_diff = sy-datum - p_days.

SELECT VBELN FROM VBAK INTO CORRESPONDING FIELDS OF TABLE IVBAk

WHERE ERDAT >= v_diff. ???

Re: Sy-datum in Select statement

Former Member — Fri, 19 Feb 2010 19:24:19 GMT


> I am writing a program to execute Open SQL statements dynamically, So i want to get the records which were created (SY-datum) - (number of days).

Then you would create a dynamic WHERE with the correct date.

Rob