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,