Problem with date in select querry

[Former Member]

Hi Friends,

I need to write a select querry to get the data in the internal table with date as condition.(Ex: Data should be captured in before 31.03.2005)

I have coded in this way, But I am unable to get the data.

SELECT gpart opbel betrw fdgrp INTO CORRESPONDING FIELDS OF TABLE lt_balance1 FROM dfkkop

WHERE fdgrp = s_augrp-low

AND hvorg = '5000'

AND tvorg = '0100'.

AND faedn LE 20050331.

Can any one correct the following code,

Thanx and Regards,

Line

[Former Member]

Hi Friends,

I need to write a select querry to get the data in the internal table with date as condition.(Ex: Data should be captured in before 31.03.2005)

I have coded in this way, But I am unable to get the data.

SELECT gpart opbel betrw fdgrp INTO CORRESPONDING FIELDS OF TABLE lt_balance1 FROM dfkkop

WHERE fdgrp = s_augrp-low

AND hvorg = '5000'

AND tvorg = '0100'.

AND faedn LE 20050331.

Can any one correct the following code,

Thanx and Regards,

Line

[Former Member]

Put the date in Quotes

SELECT gpart opbel betrw fdgrp INTO CORRESPONDING FIELDS OF TABLE lt_balance1 FROM dfkkop

WHERE fdgrp = s_augrp-low

AND hvorg = '5000'

AND tvorg = '0100'.

<b>AND faedn LE '20050331'</b>.

[Former Member]

try this..

data : v_date like sy-datum value '20050331'.

SELECT gpart opbel betrw fdgrp INTO CORRESPONDING FIELDS OF TABLE lt_balance1 FROM dfkkop
WHERE fdgrp = s_augrp-low
AND hvorg = '5000'
AND tvorg = '0100'.
AND faedn LE v_date.

Also check out if there is any data with the values u had given in where condition

[Former Member]

<b>data: v_date type sy-datum.

move '20050331' to v_date</b>.

SELECT gpart opbel betrw fdgrp INTO CORRESPONDING FIELDS OF TABLE lt_balance1 FROM dfkkop

WHERE fdgrp = s_augrp-low

AND hvorg = '5000'

AND tvorg = '0100'.

AND faedn LE <b>v_date.</b>

[Former Member]

Hello ,

DO like this.

data : v_date like sy-datum.

v_date = '20050331'.

SELECT gpart opbel betrw fdgrp INTO CORRESPONDING FIELDS OF TABLE lt_balance1 FROM dfkkop

<b>WHERE fdgrp in s_augrp</b>

AND hvorg = '5000'

AND tvorg = '0100'.

<b>AND faedn LE v_date.</b>

If useful reward

Vasanth