topic Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Thu, 19 Jul 2007 10:29:03 GMT

Hi Experts,

I am having BEGDA and ENDDA in database. And input is also BEGDA and ENDDA. I want to fetch all the records from the database those are collapsing between Input BEGDA and ENDDA.

urgent.....

Re: Select Statement

Former Member — Thu, 19 Jul 2007 10:32:33 GMT

HI,

Write like this,

begda >= s_begda and

endda <= s_endda.

Thanks

Azad.

Reward if useful.

Re: Select Statement

Former Member — Thu, 19 Jul 2007 10:34:34 GMT

s_begda , s_endda are you input parameters.

edited by Azad.

thanks

Azad.

Re: Select Statement

Former Member — Thu, 19 Jul 2007 10:36:36 GMT

If u have to read HR tables... (PAnnnn )

then u can use FMs or MACROs

HR_READ_INFOTYPE : pass BEGDA = sy-datum and ENDDA = sy-datum

or use macro..

rp-read-infotype pernr nnnn pnnnn BEGDA ENDDA.

If u need to read normal table then

select * from <tab where begda le sy-datum and endda ge sy-datum.

Regards

Prax

Re: Select Statement

varma_narayana — Thu, 19 Jul 2007 10:37:04 GMT

You can Write the SELECT like this.

SELECT <FIELDS> FROM <TABLE>

INTO TABLE <IT>

WHERE begda >= BDGDA

AND ENDDA <= ENDDA.

<b>Reward if helpful</b>

Re: Select Statement

Former Member — Thu, 19 Jul 2007 10:39:15 GMT

Hi,

You can do it this way:

Select f1 f2...

into itab

from dtab

where endda GE sy-datum

and begda LE sy-datum.

Hope it works,

Sandeep.

Re: Select Statement

Former Member — Thu, 19 Jul 2007 10:40:43 GMT

REWARD IF USEFULL

WHERE BEGDA LE SY-DATUM

AND ENDDA GE SY-DATUM.

REGARDS

NARESH