Skip to Content
0
Former Member
Jul 21, 2009 at 06:37 AM

Problem with select * into table

42 Views

Hi expert.

i have a question about select into syntax.

my problem is , i write zreport use data from mseg , mkpf table . i know if any transaction occur with these table in processing report , i never get a correct report. so, my solution is use "select * into table" retrieve data that meet with my condition into my other create table ( like : wa_mseg). and use data in this table only.


***declaration***

DATA:  wa_mseg TYPE STANDARD TABLE OF mseg WITH NON-UNIQUE DEFAULT KEY INITIAL SIZE 100,
             i_mseg TYPE mseg.

***select into***

select  * into table wa_mseg from mseg where X = Y A = C.

***use***

loop at wa_mseg into i_mseg where X = Y
........
......
........
.....


but result still incorrect.

so i think , is possible that transaction occur with mseg table has effect with data i retreive into my table?

anyone please tell me?

Best Regards

Kittisak

Edited by: Kittisak B on Jul 21, 2009 8:38 AM