topic Re: Reg: Date ranges in Application Development and Automation Discussions

Reg: Date ranges

Former Member — Fri, 18 Jul 2008 16:30:42 GMT

Hi All,

there is a problem in date ranges

i need to fecth data based on create date and date on last change.

vbak-erdat is create date.

vbak-eadat is date on last change

for example

-i have created 2 sales orders yestday.

- today i created 2 sales orders .

-but i have modfiy yestdays sales orders also.

so i need to get today what have created and what i have modfiy data . so know it should get 4 sales orders.

code is like this....

select a_{vbeln a}erdat a_{eadat a}kunnr

b_{matnr b}werks

into coressponding fields of table it_vbak

from vbak as a inner join vbap as b on a_{vbeln = b}vbeln

where a~vbeln in lr_vbeln and date ranges.

so how to write code for date range based on on create date and date on last change.

pls can you help me

thanks

mars

Re: Reg: Date ranges

Former Member — Fri, 18 Jul 2008 16:38:31 GMT

Hello Marreddy,

Do like this :

vbak-erdat is create date.

vbak-eadat is date on last change

select a_{vbeln a}erdat a_{eadat a}kunnr

b_{matnr b}werks

into coressponding fields of table it_vbak

from vbak as a inner join vbap as b on a_{vbeln = b}vbeln

where a_{vbeln in lr_vbeln and ( a}erdat = sy-datum or a~eadat = sy-datum ) .

Thanks,

Greetson

Re: Reg: Date ranges

naimesh_patel — Fri, 18 Jul 2008 16:39:00 GMT

Try like:


select a~vbeln a~erdat a~eadat a~kunnr
b~matnr b~werks
into coressponding fields of table it_vbak
from vbak as a inner join vbap as b on a~vbeln = b~vbeln
where a~vbeln in lr_vbeln 
and ( a~erdat in S_date_range or a~eadat in s_date_range)    "<<

Regards,

Naimesh Patel