Sy-datum in Select statement

[Former Member]

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). ???

[Former Member]

U cannot directly use this way ...

SELECT VBELN FROM VBAK INTO CORRESPONDING FIELDS OF TABLE IVBAk

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

[Former Member]

Why do you want to do it that way?

rob

[Former Member]

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).

[Former Member]

>

> 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

[Former Member]

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.

[Former Member]

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. ???