Select Querry,

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[amit_khare]

IF v_date[] is initial.

v_date = sy-datum.

endif.

select 8 from <table> where date = v_date.

Regards,

Amit

Reward all helpful replies.

[Former Member]

Thanks Guys.

Ster.

[Former Member]

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.