month extraction in where clause of The ABAP Stage

saraswati · Post by **saraswati** » Tue Jul 14, 2009 9:56 am

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?

chulett · Post by **chulett** » Tue Jul 14, 2009 10:43 am

Looks like you and "mona lisa" need to talk.

saraswati · Post by **saraswati** » Tue Jul 14, 2009 11:37 am

The field salesdate contains data like '20090131'.
I used LEFT(salesdate,4) to have first four char of this field.
As per my understanding it should return 2009.

But it is throwing error when I try to "generate program" option.
Comma without preceding colon (after SELECT ?).

Please suggest.

arunsardana · Post by **arunsardana** » Tue Jul 21, 2009 11:40 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