between two date query

[Former Member]

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') .

[faisalatsap]

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

[Former Member]

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') .

[Former Member]

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') .

[Former Member]

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') .

[venkat_o]

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') .

or

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

[Former Member]

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

[Former Member]

delete query

[Former Member]

closed