topic Re: Selection from VEDA table in Application Development and Automation Discussions

Selection from VEDA table

Former Member — Thu, 24 Jan 2008 16:01:57 GMT

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 — Thu, 24 Jan 2008 16:08:46 GMT

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 — Thu, 24 Jan 2008 16:15:31 GMT

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