I am using ABAP Extract stage of the Ascential PACK for SAP R/3 to extract data from SAP.
In this stage in ABAP Program tab,
I am using Build SQL Query Option.
I have to select all records where a salesdate belongs to last month only.
Data type of salesdate is DATS in SAP.
Database used for SAP is SQL server 2000.
So I select
Build-->Where tab.
Can u suggest how to do it?
month extraction in where clause of The ABAP Stage
Moderators: chulett, rschirm, roy
Looks like you and "mona lisa" need to talk.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 10
- Joined: Sun Oct 08, 2006 8:01 am
Hello Saraswati,
You can use following WHERE CLAUSE to extract data for any particular or previous month:
SalesDate >= '20090601 and SalesData <= '20090630' ---this is an example for month of june.
If you want to change the month dynamically, you can parameterize WHERE clause and then pass the previous month to WHERE CLAUSE from a sequencer. we use this technique to send sales data for previous month on the first of every month - just an exmaple where we use it.
Regards,
Arun
You can use following WHERE CLAUSE to extract data for any particular or previous month:
SalesDate >= '20090601 and SalesData <= '20090630' ---this is an example for month of june.
If you want to change the month dynamically, you can parameterize WHERE clause and then pass the previous month to WHERE CLAUSE from a sequencer. we use this technique to send sales data for previous month on the first of every month - just an exmaple where we use it.
Regards,
Arun