topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Fri, 27 Apr 2007 11:19:06 GMT

Hi Friends,

I have a customised table with a field BUDTM (Posting date). From this table I want to select the data which are equal to or greater than 01.04.2007.

Kindly guide me.

TIA.

Regards,

Mark K

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:20:35 GMT

select * from ztable into table itab

where budtm >= '20070401'.

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:20:54 GMT

select <fields> ....... where <your fiield >= condition.

Regards Jayant

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:21:18 GMT

select * from ztable into table itab where BUDTM GE '20070401'.

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:22:18 GMT

Data: GV_Date type Custom-table-BUDTM Value '01.04.2007'.

Select <fieldlist>

from custom-table

into table it_itab

where budtm GE gv_date.

santhosh

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:23:15 GMT

p_date

SELECT * FROM ZTABLE

WHERE BUDTM >= p_date.

where p_date is the date parameter and you can input it to be 01.04.2007

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:24:28 GMT

DATA: <VAR> LIKE SY-DATUM VALUE 'YYYYMMDD'.

SELECT

<fld1>

<fld2>

<fld3>

....

INTO [CORRESPONDING FIELDS OF TABLE ] <itab>

FROM <dbtab>

WHERE

BUDTM GE <VAR>.

Regards,

A. Singh

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:27:48 GMT

Hi,

I have tried like this, but not getting the data. But if I look into the table, data is available for the given date.

Kindly suggest me.

Regards,

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:29:49 GMT

How is the data stored in the field? Is it a concatenated value of date and time?

eg: 20070104132056

Sudha

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:33:04 GMT

good

check the begda and endda with in the if statement comarinng with sy-datum.

thanks

mrutyun^

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:45:09 GMT

Hi Mark,

can u paste ur SELECT statement here?

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:46:13 GMT

Hi,

Data is stored as YYYYMMDD.

Why it is not working, I do not understand.

Regards,

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:49:11 GMT

Are u sure there is some data which is GE to the date in your table..

If yes paste the code here may be we can help.

santhosh

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:55:00 GMT

Hi Mark,

Try the below example. Its working fine.

data: begin of itab occurs 0,

ebeln type ebeln,

end of itab.

select ebeln from ekpo

into table itab

where aedat >= '20060421'.

Regards,

Ram

Pls reward points if helpful.

Re: Select statement

Former Member — Fri, 27 Apr 2007 11:55:37 GMT

Look at this code this is working fine.

tables vbak.

data it_vbak like vbak occurs 0 with header line.

select

vbeln

ernam

erdat

from vbak

into table it_vbak

where erdat > '19970122'.

loop at it_vbak.

write:/ it_vbak-vbeln,it_vbak-ernam,it_vbak-erdat.

endloop.

Regards

Haritha.

Re: Select statement

former_member723628 — Fri, 27 Apr 2007 11:55:44 GMT

Mark,

Can you paste a small dump of the table contents showing the date field in question and the select query that you are using.

Regards,

Gajendra

Re: Select statement

Former Member — Fri, 27 Apr 2007 12:06:55 GMT

Hi,

The code is pasted here below.

SELECT ZNUM REASON REMARKS NEW_PIF BELNR BSTNUM

FROM ZFIH0004_1

INTO CORRESPONDING FIELDS OF TABLE IT_DATA

WHERE ZGROUP = ZFIH0004_1-ZGROUP AND

BUDTM = '20070331'.

Regards,

Re: Select statement

Former Member — Fri, 27 Apr 2007 12:08:47 GMT

Hi,

Table contains the data as following:

BUDTM

31.03.2007

Regards,

Re: Select statement

Former Member — Fri, 27 Apr 2007 12:09:16 GMT

what is 'ZFIH0004_1-ZGROUP'?

if it is one of the values of ZGROUP then change the select statement as below

SELECT ZNUM REASON REMARKS NEW_PIF BELNR BSTNUM

FROM ZFIH0004_1

INTO CORRESPONDING FIELDS OF TABLE IT_DATA

WHERE ZGROUP = 'ZFIH0004_1-ZGROUP'

AND BUDTM = '20070331'.

if ZFIH0004_1 is a select-option then change the select statement as below

SELECT ZNUM REASON REMARKS NEW_PIF BELNR BSTNUM

FROM ZFIH0004_1

INTO CORRESPONDING FIELDS OF TABLE IT_DATA

WHERE ZGROUP IN ZFIH0004_1

AND BUDTM = '20070331'.

Message was edited by:

Rajesh

Message was edited by:

Rajesh

Re: Select statement

Former Member — Fri, 27 Apr 2007 12:10:07 GMT

The code is not working because of WHERE ZGROUP = ZFIH0004_1-ZGROUP condition.

You are fetching data from ZFIH0004_1 and specifying the same in where clause in this way. How this will work?

Please specify correct condition for ZGROUP.