topic Re: Problem with date in select querry in Application Development and Automation Discussions

Problem with date in select querry

Former Member — Mon, 22 Jan 2007 14:13:41 GMT

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

Re: Problem with date in select querry

Former Member — Mon, 22 Jan 2007 14:15:41 GMT

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

AND faedn LE '20050331'.

Re: Problem with date in select querry

Former Member — Mon, 22 Jan 2007 14:16:39 GMT

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

Re: Problem with date in select querry

Former Member — Mon, 22 Jan 2007 14:17:39 GMT

data: v_date type sy-datum.

move '20050331' to v_date.

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.

Re: Problem with date in select querry

Former Member — Mon, 22 Jan 2007 14:18:45 GMT

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

WHERE fdgrp in s_augrp

AND hvorg = '5000'

AND tvorg = '0100'.

AND faedn LE v_date.

If useful reward

Vasanth