How do I refer the current date in this sql ?

[Former Member]

Hi

Look at my my sql snippet below at SY-DATUM. How do I refer the current date in this sql ? ( I would like to check if the current date falls between those two dates, currently I am getting error )

"

...

FROM ( /sapsll/prcon

INNER JOIN /sapsll/prcts

ON /sapsll/prcts_{guid_pr = /sapsll/prcon}guid_pr

INNER JOIN /sapsll/tlegsv

ON /sapsll/tlegsv_{lgreg = /sapsll/prcon}lgreg

INNER JOIN /sapsll/ctsnum

ON /sapsll/ctsnum_{guid_ctsnum = /sapsll/prcts}guid_ctsnum

AND /sapsll/ctsnum_{stcts = /sapsll/tlegsv}ctsex

INNER JOIN /sapsll/prgen

ON /sapsll/prgen_{guid_pr = /sapsll/prcts}guid_pr

INNER JOIN /sapsll/ctsnum as a

ON a_{guid_ctsnum = /sapsll/prcts}guid_ctsnum

AND SY-DATUM BETWEEN a_{DATAB AND a}DATBI

)

INTO CORRESPONDING FIELDS OF TABLE lt_product_class_temp

FOR ALL ENTRIES IN lt_product_class

WHERE /sapsll/prcon~congr IN sp$00017"

...

"

thanks

siva

Edited by: Sivanantham kandan on Sep 13, 2008 3:26 AM

Edited by: Sivanantham kandan on Sep 13, 2008 3:27 AM

[former_member188685 · Accepted solution]

SY-DATUM is not part of the table , so it is not possible to do that. but you can do that in reverse.

INNER JOIN /sapsll/ctsnum as a
ON a~guid_ctsnum = /sapsll/prcts~guid_ctsnum
AND a~DATAB  le sy-datum   you can do this....
AND a~DATBI   ge sy-datum
)
INTO CORRESPONDING FIELDS OF TABLE lt_product_class_temp
FOR ALL ENTRIES IN lt_product_class
WHERE /sapsll/prcon~congr IN sp$00017"