Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a simple query where i need to pull data with certain match to end date, however its not working.
Master:
Load
[KOSTL] ,
[ENDDA] ,
[PERNR] ,
SQL select ...... from .....
where ENDDA >= '12/31/9999'; // this statement does not seem to get right info. it gets all the data instead of 12/31/9999
Might be a date format issue. Make sure ENDDA is in MM/DD/YYYY format.
SAP usually stores dates in YYYYMMDD. So try
ENDDA >= '99991231'
Thanks