help to make a propper selection on the table

Hi There,

I need to do a selection at the table MARD for the checking the current stock at storage location, but there is a problem. In the table MARD there are stock values also for previous period.

Can you please tell me haow I can do the selection on current date?

For example If I want to get the current stock I need to fill in also the curent year and month. How can I write a selection, where the year and month will be copied from the system date.

SELECT * FROM MARD WHERE ( MATNR IN MATNR ) AND

( LGORT IN LGORT) AND

( WERKS IN WERKS ) AND

***********LFGJA is the year taken from the current date '2008' AND

***********LFMON is the month taken from the current date '12'

Thanks in advance for your help,

BR

Saso