Select Table ?

[Former Member]

arch_date-high = sy-datum - 730 .

arch_date-sign = 'E'.

arch_date-option = 'BT'.

append arch_date.

select vbeln posnr vbtyp auart kunnr bstnk bstdk

vkorg vtweg vkbur meins abrvw matnr pstyv werks abgru vkaus

prctr netpr netwr waerk route

from zvbakvbap6

into corresponding fields of table tab_zvbakvbap6

where vbeln in l_r_vbeln

and audat in <b>arch_date</b>

and vkorg in l_r_vkorg

and kunnr in l_r_kunnr

and auart in l_r_auart " Sales document type

and auart <> 'LZ'

and werks in l_r_werks.

arch_date-low has nothing in it ...the select statement will return the orders after the arch_date or before ?

I thought it would be any orders after the arch_date-highdate...?

[sridhar_k1]

Select returns orders <= arch_date-highdate.

Regards

Sridhar

[Former Member]

yeah ...but the statement thats there above using IN operator will return orders upto the date ?

This is a bw extract function modules and it seems to me that it should be fetching any orders after the archive date calculated ..but this selection doesnt suggest so ...so i wanted to make sure ..

[sridhar_k1]

Just checked this arch_date-sign = 'E' line,

Theselect excludes ordersfrom 00000000 to HIGH data.

Regards

Sridhar

Message was edited by: Sridhar K