topic Re: ABAP query Problem in Application Development and Automation Discussions

ABAP query Problem

Former Member — Mon, 11 Dec 2006 08:48:10 GMT

Dear All,

I am trying to run this query but it is not giving data :

SELECT vbeln erdat erzet netwr waerk FROM vbak INTO TABLE it_tab

WHERE vbeln ge frpos

and vbeln le topos .

Here frpos and topos are teo variables having values 0 and 9 respectively.

Please reply what can be the problem.

Thanks in Advance

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 08:55:29 GMT

Hi ,

Goto se11 and check if there are records in that range .

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 08:56:34 GMT

Following needs to Checked with You query ,

1) check that internal table structure and the selecting fields sequence is same . other wise use into corresponding

2) check that variables frpos and topos . are declared like VBELN .

3) Make sure that VBAK contains data for sales orders between 0 and 9

Please mark Useful answers

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 08:56:36 GMT

yup there are records in the table for that range

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 08:59:51 GMT

Write the select statment in this way

SELECT vbeln erdat erzet netwr waerk FROM vbak INTO TABLE it_tab

WHERE ( vbeln ge frpos

and vbeln le topos ) .

frpos and topos are of vblen type check if not declare them as vbeln type.

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 09:01:22 GMT

hi,

before passing frpos and topos to vbak

use functional module CONVERSION_EXIT_ALPHA_INPUT and pass the input of frpos and get the ouput from the and then pass it in the querry , do the same thing for topos also . you will get the querry working.

regards,

guru

mark if helpful

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 09:04:25 GMT

Hi ,

What is the data type you have declared for frpos and to topos.

like for matnr it has to be given as,

where matnr = '000000000000000088' .

since it is char field .

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 09:05:35 GMT

hi...

jus try the code i hav modified from ur's. it wil work...reward if useful.

SELECT vbeln erdat erzet netwr waerk

FROM vbak

INTO <b>corresponding fields of</b> TABLE it_tab

WHERE vbeln ge frpos

and vbeln le topos

all the best.

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 09:07:29 GMT

Hi,

Data read is not placed in the output area, conversion is required.

regards,

pankaj singh

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 09:07:55 GMT

Hi,

Write the select statment in this way

SELECT vbeln erdat erzet netwr waerk FROM vbak INTO TABLE it_tab

WHERE <b>vbeln between frpos and topos.</b>

Message was edited by:

Purshothaman P

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 09:11:19 GMT

Thanks a lot everybody ,

we have to convert the inputs by using the function

CONVERSION_EXIT_ALPHA_INPUT as replied by Guru,

Thanks a lot Guru.

Re: ABAP query Problem

Former Member — Mon, 11 Dec 2006 09:12:54 GMT

Hi ,

Reward points yaar.

regards,

Guru