topic Select Table ? in Application Development and Automation Discussions

Select Table ?

Former Member — Mon, 06 Nov 2006 19:43:53 GMT

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...?

Re: Select Table ?

sridhar_k1 — Mon, 06 Nov 2006 19:48:24 GMT

Select returns orders <= arch_date-highdate.

Regards

Sridhar

Re: Select Table ?

Former Member — Mon, 06 Nov 2006 19:50:47 GMT

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 ..

Re: Select Table ?

sridhar_k1 — Mon, 06 Nov 2006 19:53:46 GMT

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

Theselect excludes ordersfrom 00000000 to HIGH data.

Regards

Sridhar

Message was edited by: Sridhar K