topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Fri, 07 Sep 2007 18:29:58 GMT

Hi gurus,

I have a condition where I need to select vkbur, vkgrp, kunnr abd bzirk from knvv for all entries in one of my internal table it_tab01. Now although I have an customer id that is there in both knvv and my internal table it_tab01 but then also nothing is getting copied into it_sales. can you just tell me whats going wrong.

select vkgrp vkbur bzirk kunnr into table it_sales

from knvv

for all entries in it_tab01

where kunnr = it_tab01-custid.

Thanks

Rajeev Gupta

Re: Select statement

Former Member — Fri, 07 Sep 2007 18:33:34 GMT

HI,

The reason could be that the customer id in the it_tab01 is not of the same format as in KNVV...

if that is the case just try using this.

loop aa it_tab01.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = IT_TAB01-CUSTID

IMPORTING

OUTPUT = IT_TAB01-CUSTID.

select single vkgrp vkbur bzirk kunnr into it_sales

from knvv

where kunnr = it_tab01-custid.

IF SY-SUBRC EQ 0.

APPEND IT_SALES.

endloop.

Re: Select statement

Former Member — Fri, 07 Sep 2007 18:42:23 GMT

I believe Mahesh is correct that the format of the data might not match.

I had the same problem in a program yesterday, and I resolved the problem in the manner he describes.

Good luck

Brian

Re: Select statement

Former Member — Fri, 07 Sep 2007 18:42:28 GMT

thanks for the reply Mahesh, but that is not the case, I tried doing what you told me.

Thanks

rajeev Gupta

Re: Select statement

Former Member — Fri, 07 Sep 2007 18:44:46 GMT

hi,

If this logic does not work then you should check with the data in KNVV.. i dont see any other reason apart from this for data not being selected.

Debug the application and get some cust id's and open the table KNVV in se16 and see if you havve values or not..

Thanks

mahesh

Re: Select statement

Former Member — Fri, 07 Sep 2007 18:45:09 GMT

How is it_tab01 declared?

Rob

Re: Select statement

Former Member — Fri, 07 Sep 2007 18:45:15 GMT

Have you run the program in debug and verified the contents of the internal table?

Brian