topic Re: ABAP select statement !! in Application Development and Automation Discussions

ABAP select statement !!

Former Member — Wed, 16 Sep 2009 12:23:44 GMT

Hi All,

I want to write a query on SOOD table like:

SELECT OBJTP OBJYR OBJNO OBJDES OWNNAM FROM SOOD INTO TABLE IT_SOOD

WHERE OBJDES LIKE 'String%' AND

( SDDAT BETWEEN LV_LASTRUN AND SY-DATUM ) AND

( SDTIM BETWEEN LV_LASTTIM AND SY-UZEIT ).

but this is not returning me data between the last run date/ last run time and current date/ time.

Can anybody suggest how to modify the above query in order to fetch correct data.

Thanks in Advance !!

Vivek

Re: ABAP select statement !!

Former Member — Wed, 16 Sep 2009 12:28:55 GMT

Hi,

Try this

SELECT OBJTP OBJYR OBJNO OBJDES OWNNAM FROM SOOD INTO TABLE IT_SOOD
WHERE OBJDES LIKE 'String%' AND
( SDDAT BETWEEN LV_LASTRUN AND SY-DATUM ) *OR*
( SDTIM BETWEEN LV_LASTTIM AND SY-UZEIT ).

Regards,

Nandha

Re: ABAP select statement !!

Former Member — Wed, 16 Sep 2009 12:30:10 GMT

You can pass the last run date , Current date into a range and last run time , current time into another range

and pass this in the where conditions ...

SELECT OBJTP OBJYR OBJNO OBJDES OWNNAM FROM SOOD INTO TABLE IT_SOOD

WHERE OBJDES LIKE 'String%' AND

SDDAT in r_sddat AND

SDTIM in r_UZEIT.

or ... U can write the coding as ...

SELECT OBJTP OBJYR OBJNO OBJDES OWNNAM FROM SOOD INTO TABLE IT_SOOD

WHERE OBJDES LIKE 'String%' AND

SDDAT >= LV_LASTRUN AND

SDDAT <= SY-DATUM AND

SDTIM >= LV_LASTTIM AND

SDTIM <= SY-UZEIT .

Re: ABAP select statement !!

Former Member — Wed, 16 Sep 2009 12:45:31 GMT

Hi Vivek Kulkarni,

Using Range is better option..

Also please check how you declared the fileds as mentioned below or not..

LV_LASTRUN type sy-datum.
LV_LASTTIM type SY-UZEIT.

Better to write code for Range and populate it and then pass it in select where condition using IN.

Searcg SCN for more help on how to use RANGE

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: ABAP select statement !!

Former Member — Wed, 16 Sep 2009 12:50:20 GMT

are you sure that, the value 'String%' is of this pattern? i mean the S being upper case and others being in lower case?

because the domain for this field is LOWER CASE ticked, it stores the exact pattern

and you can also try creating a range for the date and time.

data: lv_datum type range of sy-datum,
     lv_uzeit type srange of sy-uzeit.

Re: ABAP select statement !!

Former Member — Wed, 16 Sep 2009 13:02:12 GMT

Hi,

Try this


SELECT OBJTP OBJYR OBJNO OBJDES OWNNAM FROM SOOD INTO TABLE IT_SOOD
WHERE OBJDES LIKE 'String%' AND
( SDDAT >= LV_LASTRUN AND SDTIM >= LV_LASTTIM )
AND
( SDDAT <= SY-DATUM AND SDTIM <= SY-UZEIT ).

Hope this helps.

BR,

Advait

Re: ABAP select statement !!

christine_evans — Wed, 16 Sep 2009 13:04:02 GMT


> Hi All,
> 
> I want to write a query on SOOD table like:
> 
> SELECT OBJTP OBJYR OBJNO OBJDES OWNNAM FROM SOOD INTO TABLE IT_SOOD
>        WHERE OBJDES  LIKE 'String%'  AND
>              ( SDDAT BETWEEN LV_LASTRUN AND SY-DATUM )      AND
>              ( SDTIM BETWEEN LV_LASTTIM AND SY-UZEIT ).
> 
> but this is not returning me data between the last run date/ last run time and current date/  time.
> 
> Can anybody suggest how to modify the above query in order to fetch correct data.
> 
> Thanks in Advance !!
> Vivek

If the last run date was 01.09.2009 and the last run time was 11:00, this code will pick up data for all dates from 01.09.2009 but only if the time value is > 11:00; so if there was a run at 09:00 on 03.09.2009 you won't pick up that record - and I'm assuming that you would want to pick up that record.

I think you should only be applying the time check to records where the date = LV_LASTRUN and for later records you should just be checking the date. Something like:

WHERE (      (            sddat = lv_lastrun   
                            AND  sdtim > lv_lasttim   ) 
                 OR  (            sddat > lv_lastrun )
                  )

Re: ABAP select statement !!

Former Member — Wed, 16 Sep 2009 13:04:07 GMT

Hi All,

Thanks for replies.

problem solved using the comparison operators.

Thanks a Lot !!

Re: ABAP select statement !!

Former Member — Wed, 16 Sep 2009 13:07:18 GMT

Hi,

Can you post the final select query you used so that it will be helpful for others who face similar problem?

Regards,

Vikranth

Re: ABAP select statement !!

sreeramkumar_madisetty — Wed, 16 Sep 2009 13:13:11 GMT

Share your solution with others.

Regards,

Sreeram

Re: ABAP select statement !!

Former Member — Thu, 17 Sep 2009 12:31:01 GMT

Hi All,

I have revised the query using comparison operators as follows:

SELECT OBJTP OBJYR OBJNO OBJDES OWNNAM FROM SOOD INTO TABLE IT_SOOD

WHERE SDTIM >= LV_LASTTIM and SDDAT >= LV_LASTRUN and

OBJDES LIKE 'XXXXXX Purchasing Document%'.

So, now it is giving me desired output as: Selecting OBJTP OBJYR OBJNO OBJDES OWNNAM from SOOD table into internal table IT_SOOD where the time is greater than or equal to last run time and the date is greater than or equal to last run date and the string (OBJDES) like 'XXXXXX Purchasing Document%'.

Thanks for you support !!

Vivek