topic Re: Select Querry, in Application Development and Automation Discussions

Select Querry,

Former Member — Mon, 14 May 2007 15:13:29 GMT

Hello friends,

I have date field in my selection screen.

When the user inputs date it should pick records for that date else it should pick for the current date.

My querry is,

Select * from zpmtras into itab

Where ( erdat = sy-datum ) or ( erdat in s_erdat ).

Let me know if this is right and what are the changes that I should make

Ster.

Re: Select Querry,

Former Member — Mon, 14 May 2007 15:15:28 GMT

Hi Ster,

Try this..

if s_erdat[] is initial.

Select * from zpmtras into itab Where erdat = sy-datum.

Else.

Select * from zpmtras into itab Where erdat in s_erdat.

Endif.

Regards

SAB

Re: Select Querry,

Former Member — Mon, 14 May 2007 15:16:55 GMT

should something like this.

if s_erdat[] is initial.

Select * from zpmtras into itab

Where erdat = sy-datum.

else.

Select * from zpmtras into itab

Where erdat in s_erdat.

endif.

Re: Select Querry,

amit_khare — Mon, 14 May 2007 15:19:03 GMT

IF v_date[] is initial.

v_date = sy-datum.

endif.

select 8 from <table> where date = v_date.

Regards,

Amit

Reward all helpful replies.

Re: Select Querry,

Former Member — Mon, 14 May 2007 15:20:15 GMT

Thanks Guys.

Ster.

Re: Select Querry,

Former Member — Mon, 14 May 2007 15:20:46 GMT

Hi Ster,

You will have to separate the date criteria based upon whether the user enters data in the selection screen or not. Currently if the user does not enter data the query will retrieve all the data from the Z table in the database. Your code should look like this:

IF NOT s_erdat[] IS INITIAL.
  SELECT <field list>
  FROM zpmtras
  INTO TABLE itab
  WHERE erdat IN s_erdat.
ELSE.
  SELECT <field list>
    FROM zpmtras
    INTO TABLE itab
    WHERE erdat EQ sy-datum.
ENDIF.