This content has been marked as final. Show 2 replies
I have an easy question which is driving me crazy!
The purpose is to load table AUFM from SAP. The field BUDAT is a date in following notation: 20/11/2012.
I want to load only the records from 2011 & 2012, therefore I use a where clause, but no records are loaded.
What is wrong in the script:
[MEINS] as [Base Unit_MEINS],
text([MATNR]) as [Material_MATNR],
[SHKZG] as [Debit/Credit_SHKZG],
[WERKS] as [Plant_WERKS],
[AUFNR] as [Order_AUFNR],
[MENGE] as [Quantity_MENGE],
[BUDAT] as [Posting Date_BUDAT],
[BWART] as [Movement Type_BWART];
SQL Select MEINS MATNR SHKZG AUFNR WERKS MENGE BUDAT BWART from AUFM
where BUDAT > '31/12/2010'
Thank you for your help!