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