Selection from VEDA table

[Former Member]

Hi,

Please help me out in this regard.

I want to select the document no's VBELN from VEDA table using the date range.

start_date -- VBEGDAT = 01/23/2004

end_date -- VENDDAT = 01/17/2008

Using this date range i want to select the documents.

Please tell me how to do this.

Thanks & Regards

Santhosh

[Former Member]

Try this:

select vbeln

from veda

into table it_tab

where VBEGDAT gt start_date

and VENDDAT lt end_date.

This will select all orders where the start date is on or after 1/23/2004 and the end date is on or before 1/17/2008.

Hope that helps,

Michael

[former_member156446]

Hi Santosh

Veda have POSNR with 000000 so when you say

select vbeln from VEDA

into itab

where vbeln = pa_vbeln. <<<<you will get many vbeln

so if you needed header details then you need to say

select vbeln from VEDA

into itab

where vbeln = pa_vbeln and

posnr = '00000'.