topic Re: simple query . in Application Development and Automation Discussions

simple query .

Former Member — Thu, 22 Feb 2007 14:29:27 GMT

Hello Friends ,

I am tryin to copy a table of 12 fields with a MANDT primary key field in the table . Here is the code below . But it is not getting any data from the table to the internal table . Please advise .

REPORT Ztest.

tables: Ztab.

DATA: t_itab TYPE TABLE OF Ztab with header line.

data: lindex like sy-tabix.

start-of-selection.

SELECT * FROM Ztab

INTO corresponding fields of TABLE t_zyms .

IF NOT t_itab[] IS INITIAL.

insert Ztab FROM table t_itab.

ENDIF.

end-of-selection.

Re: simple query .

amit_khare — Thu, 22 Feb 2007 14:31:18 GMT

Check your table name ins elect query.

SELECT * FROM Ztab

INTO corresponding fields of TABLE t_zyms .

I think it should be t_itab.

Regards,

amit

Reward all helpful replies.

Re: simple query .

Former Member — Thu, 22 Feb 2007 14:32:36 GMT

start-of-selection.

SELECT * FROM Ztab

INTO corresponding fields of TABLE t_itab .

Re: simple query .

Former Member — Thu, 22 Feb 2007 14:34:04 GMT

Hello,

REPORT Ztest.

tables: Ztab.

DATA: t_itab TYPE TABLE OF Ztab with header line.


data: lindex like sy-tabix.

start-of-selection.

SELECT * FROM Ztab
INTO corresponding fields of TABLE  <u><b><i>t_itab</i></b></u> .


IF NOT t_itab[] IS INITIAL.

insert Ztab FROM table t_itab.

ENDIF.

Vasanth

Re: simple query .

Former Member — Thu, 22 Feb 2007 14:34:50 GMT

REPORT Ztest.
tables: Ztab.
DATA: t_itab TYPE TABLE OF Ztab with header line.

data: lindex like sy-tabix.

start-of-selection.

SELECT * FROM Ztab
INTO  corresponding fields of TABLE

t_itab .


IF NOT t_itab[] IS INITIAL.
insert Ztab FROM table t_itab.

ENDIF.

end-of-selection.

Hppe this solves.

Re: simple query .

Former Member — Thu, 22 Feb 2007 14:35:01 GMT

Table t_itab is of type Ztab and not t_zyms .

You need to change the table name in the query to t_itab .

Regards,

Saumya

Re: simple query .

Former Member — Thu, 22 Feb 2007 15:37:13 GMT

sorry i mispelt that it is t_itab . But still not working . Please advise

Re: simple query .

SantoshKallem — Thu, 22 Feb 2007 15:43:52 GMT

try to READ the contents and then insert.

have u checked in debugging. do u geetting value to internal table.

Re: simple query .

Former Member — Thu, 22 Feb 2007 15:46:41 GMT

Hi,

check the table for entries. check the code in debug mode adn try to change ur select statement to know where its goign wrong!

regards,

madhu

Re: simple query .

Former Member — Thu, 22 Feb 2007 15:50:14 GMT

I am not getting any value in the internal table. I am runnin in debug mode and there is not value in internal table after the select query is executed in the debug mode.

I tried the code with other tables which did not have MANDT field as primary key and it worked .

Please advise

Re: simple query .

Former Member — Thu, 22 Feb 2007 15:57:12 GMT

Thank you folks i think i was using the wrong table name My bad

I will reward poiints

Re: simple query .

Former Member — Thu, 22 Feb 2007 16:23:24 GMT

Hi,

Can you please explain what are you trying to achieve from the below code??? you are fetching data from table Ztab and same data you are again trying to insert into Ztab.... this will definitely not happen.....

Data fetching you can do with the below code:

REPORT Ztest.

tables: Ztab.

DATA: t_itab TYPE TABLE OF Ztab with header line.

data: lindex like sy-tabix.

start-of-selection.

SELECT * FROM Ztab INTO TABLE t_itab .

IF NOT t_itab[] IS INITIAL.

insert <table> FROM table t_itab.

ENDIF.

end-of-selection.