topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Tue, 15 May 2007 13:23:14 GMT

hi experts how can i filter records by month of given date. I use the given below statement. but it gives error message. Pls anyone give solution.

SELECT VBELN POSNR EDATU

FROM VBEP

INTO TABLE T_VBEP

WHERE EDATU+4(2) LE 3.

Thanks.

Re: select query

Former Member — Tue, 15 May 2007 13:26:07 GMT

First fetch all records from table.

then in the loop seggregate the records.

SELECT VBELN POSNR EDATU

FROM VBEP

INTO TABLE T_VBEP.

loop at t_vbep.

if t_vbep- EDATU+4(2) gt 4.

delete t_vbep index sy-tabix.

endif.

endloop.

Reward points if useful

Regards

Anji

Re: select query

Former Member — Tue, 15 May 2007 13:27:16 GMT

is it possible in a single query ?

Re: select query

Former Member — Tue, 15 May 2007 13:27:47 GMT

Within select query the condition like edatu+4(2) is not possible,so use within loop endloop.

Reward Points if it is helpful

Thanks

Seshu

Re: select query

Former Member — Tue, 15 May 2007 13:28:57 GMT

You can also do it this way...


DATA: MONTH_INI TYPE SY-DATUM,
          MONTH_END TYPE SY-DATUM.

MONTH_INI = '20070501'.
MONTH_END = '20070531'.

SELECT VBELN POSNR EDATU
FROM VBEP
INTO TABLE T_VBEP
WHERE EDATU BETWEEN MONTH_INI AND MONTH_END.

Greetings,

Blag.

Re: select query

Former Member — Tue, 15 May 2007 13:29:37 GMT

Hi..

SELECT VBELN POSNR EDATU

FROM VBEP

INTO TABLE T_VBEP.

*WHERE EDATU+4(2) LE 3. * remove this line.

delete t_vbep where edatu+4(2) gt 3.

Re: select query

Former Member — Tue, 15 May 2007 13:30:06 GMT

parameter : s_date like sy-datum .

select vbeln posnr edatu from vbep into table t_vbep where edatu le s_date.

Girish

Re: select query

Former Member — Tue, 15 May 2007 13:38:57 GMT

Like this:


SELECT vbeln posnr edatu
  FROM vbep
  INTO TABLE t_vbep
  WHERE edatu LIKE '____03__'
     OR edatu LIKE '____02__'
     OR edatu LIKE '____01__'
     OR edatu LIKE '____00__'.

Rob

Re: select query

Former Member — Tue, 15 May 2007 13:55:05 GMT

parameter : s_date LIKE T009B-POPER .

data : begin_date like sy-datum , end_date like sy-datum.

call function module

G_POSTING_DATE_OF_PERIOD_GET

import parameters :

period = s_date

variant = '24' from the sap or else ask you fi consultant he will tell you the varaint of the period .

year = 2007

Export parameters

from_date = begin_date

to_date = end_date .

select vbeln posnr edatu from vbep into table t_vbep where edatu between begin_date and end_date .

i think this is what the exact technicality

Girish