topic Re: between two date query in Application Development and Automation Discussions

between two date query

Former Member — Thu, 27 Aug 2009 05:42:35 GMT

dear all,

I am new in abap i want to use between dates option in query but i can't

SELECT-OPTIONS : lifnr FOR lfa1-lifnr ,

zaldt FOR payr-zaldt OBLIGATORY,

gjahr FOR bsak-gjahr OBLIGATORY .

previously that fiscal year ( gjahr ) is define in PARAMETERS

PARAMETERS :

gjahr LIKE bsak-gjahr OBLIGATORY ,

how can i used between date of gjahr-low and gjahr-high in following sap query

SELECT belnr FROM bsak INTO zbsad

WHERE bukrs = 'AHL' AND

lifnr = vend_itab-lifnr AND

gjahr = gjahr AND

gsber EQ gsber AND

budat IN zaldt AND

lifnr IN lifnr AND

blart IN ('KZ','ZS') .

Re: between two date query

faisalatsap — Thu, 27 Aug 2009 05:46:24 GMT

Hi, Shahid

USE the following way,

write the following Lines of Code Before this Query too, it will correct when USER Enter only Date in Low not in High in Obligatory it is not necessary to enter the HIGH Date too.

IF gjahr-high = '00000000'.
  gjahr-high = gjahr-low.
ENDIF.

SELECT belnr FROM bsak INTO zbsad
WHERE bukrs = 'AHL' AND
lifnr = vend_itab-lifnr AND
gjahr BETWEEN gjahr-low and gjahr-high and " USE This way
gsber EQ gsber AND
budat IN zaldt AND
lifnr IN lifnr AND
blart IN ('KZ','ZS') .

Regards,

Faisal

Re: between two date query

Former Member — Thu, 27 Aug 2009 05:47:12 GMT

Write Query as below

replace gjahr = gjahr with gjahr IN gjahr

SELECT belnr FROM bsak INTO zbsad
WHERE bukrs = 'AHL' AND
lifnr = vend_itab-lifnr AND
gjahr IN gjahr AND             <<<<<<<<<<<<<<<<
gsber EQ gsber AND
budat IN zaldt AND
lifnr IN lifnr AND
blart IN ('KZ','ZS') .

Re: between two date query

Former Member — Thu, 27 Aug 2009 05:48:58 GMT

Hi Try to use like this.

SELECT belnr FROM bsak INTO zbsad

WHERE bukrs = 'AHL' AND

lifnr = vend_itab-lifnr AND

gjahr in gjahr AND

gsber EQ gsber AND

budat IN zaldt AND

lifnr IN lifnr AND

blart IN ('KZ','ZS') .

Re: between two date query

Former Member — Thu, 27 Aug 2009 05:49:02 GMT

Hi Try to use like this.

SELECT belnr FROM bsak INTO zbsad

WHERE bukrs = 'AHL' AND

lifnr = vend_itab-lifnr AND

gjahr in gjahr AND

gsber EQ gsber AND

budat IN zaldt AND

lifnr IN lifnr AND

blart IN ('KZ','ZS') .

Re: between two date query

venkat_o — Thu, 27 Aug 2009 05:54:37 GMT

Try this way.

<li>

 
SELECT belnr FROM bsak INTO zbsad
WHERE bukrs = 'AHL' AND
 lifnr = vend_itab-lifnr AND
 gjahr  BETWEEN gjahr-low AND gjahr-high AND 
 gsber EQ gsber AND
 budat IN zaldt AND
 lifnr IN lifnr AND
 blart IN ('KZ','ZS') .

SELECT belnr FROM bsak INTO zbsad
WHERE bukrs = 'AHL' AND
 lifnr = vend_itab-lifnr AND
 gjahr  in gjahr AND 
 gsber EQ gsber AND
 budat IN zaldt AND
 lifnr IN lifnr AND
 blart IN ('KZ','ZS') .

Thanks

Venkat.O

Re: between two date query

Former Member — Thu, 27 Aug 2009 07:03:00 GMT

Hi Shahid !

As i got ur question , u can use ( between ) key words to select data between two dates.

For Example...

SELECT belnr FROM bsak INTO zbsad
WHERE bukrs = 'AHL' AND
lifnr = vend_itab-lifnr AND
gjahr between gjahr-low AND  gjahr-high  " Here use between keyword
gsber EQ gsber AND
budat IN zaldt AND
lifnr IN lifnr AND
blart IN ('KZ','ZS') .

Edited by: tahir naqqash on Aug 27, 2009 12:04 PM

Edited by: tahir naqqash on Aug 27, 2009 12:06 PM

Re: between two date query

Former Member — Sun, 14 Nov 2010 18:43:42 GMT

delete query

Re: between two date query

Former Member — Sun, 14 Nov 2010 18:46:12 GMT

closed