Skip to Content
0
Former Member
Jul 18, 2008 at 04:30 PM

Reg: Date ranges

34 Views

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 avbeln aerdat aeadat akunnr

bmatnr bwerks

into coressponding fields of table it_vbak

from vbak as a inner join vbap as b on avbeln = bvbeln

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