topic Re: Error in select statement in Application Development and Automation Discussions

Error in select statement

Former Member — Tue, 21 Apr 2009 08:32:13 GMT

Hi All below is the sample code where it is not fetching the data into itab. Please check where i am doing wrong...


REPORT  YP_TEST1.
tables: pernr , pa0001.
select-options:pernr1 for pa0001-pernr.

data: begin of itab occurs 1.
include structure pa0001.
data:end of itab.

start-of-selection.

select * from pa0001 into table itab where pernr in pernr1

when i am inputting pernr into the selection-screen it is not getting the itab to be populated please let me knwo where i am doing wrong....

Regards

sas

Re: Error in select statement

SuhaSaha — Tue, 21 Apr 2009 08:35:24 GMT

Hello,

Code looks OK to me. May be that data doesnot exist in the table PA0001.

BR,

Suhas

Re: Error in select statement

Former Member — Tue, 21 Apr 2009 08:36:44 GMT

could you please copy the code into your system and check please....it is ok definetl y..data is also there i dont know where i am doing wrong!

Regards

sas

Re: Error in select statement

Mohamed_Mukhtar — Tue, 21 Apr 2009 08:37:58 GMT

Hi,

I copied your code in my system . And it is working fine.

Re: Error in select statement

Former Member — Tue, 21 Apr 2009 08:38:11 GMT

Code is 100% fine.

Re: Error in select statement

former_member222860 — Tue, 21 Apr 2009 08:39:30 GMT

I'm getting the values with your code,, pl. check the data

tables: pernr , pa0001.

data: begin of itab occurs 1.
        include structure pa0001.
data:end of itab.

select-options:pernr1 for pa0001-pernr.

start-of-selection.

  select * from pa0001 into table itab where pernr in pernr1.


  loop at itab.
    write:/ itab-pernr.
  endloop.

Re: Error in select statement

kesavadas_thekkillath — Tue, 21 Apr 2009 08:40:48 GMT

just check without employee no input.

Code is fine

Re: Error in select statement

Former Member — Tue, 21 Apr 2009 08:41:02 GMT

It works fine

Re: Error in select statement

SuhaSaha — Tue, 21 Apr 2009 08:42:22 GMT

Hello Dude,

Works very well for me. Did you check in debug mode the data?

Since ITAB is an internal table with "header line", you need to check as ITAB[] else you will end up viewong the "header line" only.

BR,

Suhas

Re: Error in select statement

Former Member — Tue, 21 Apr 2009 08:43:26 GMT

Sas,

Are you sure that the data exists in the system ?

Try to remove pernr in the declaration part of tables.

And activate the code once and try running it.

Re: Error in select statement

Former Member — Tue, 21 Apr 2009 08:45:30 GMT

YOu code is !00% correct.. iam getting values for ur code.. please check once weather u contain the data in ur table.

regards

sivaram

Re: Error in select statement

Former Member — Tue, 21 Apr 2009 09:03:35 GMT

i am so sorry i got confused in different way..

i am just checking in the debug mode it is showing all zeros in header it made confuse.....at the end it is having data....

generally it need to handle the last record in header why is it showing as all zeros in header?any idea?

Regards

sas

Re: Error in select statement

JozsefSzikszai — Tue, 21 Apr 2009 14:11:41 GMT


> generally it need to handle the last record in header why is it showing as all zeros in header?any idea?

it is only true after a LOOP or after a SELECT ... APPEND itab ... ENDSELECT, but not after a SELECT ... INTO TABLE

Re: Error in select statement

Former Member — Tue, 21 Apr 2009 17:52:31 GMT

wow Eric ..Thnkx....Seems intresting

Regards

sas