Select Statement

[Former Member]

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

[Former Member]

HI,

Write like this,

begda >= s_begda and

endda <= s_endda.

Thanks

Azad.

Reward if useful.

[Former Member]

s_begda , s_endda are you input parameters.

edited by Azad.

thanks

Azad.

[Former Member]

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

[varma_narayana]

Hi

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>

[Former Member]

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.

[Former Member]

HI

REWARD IF USEFULL

WHERE BEGDA LE SY-DATUM

AND ENDDA GE SY-DATUM.

REGARDS

NARESH