‎2008 Apr 14 9:38 AM
Hi,
what does it mean to append with asterisk like:
SELECT * FROM covp APPENDING TABLE *covp
what is the different from regular into table commend ?
Regards
‎2008 Apr 14 9:49 AM
Hi
Try to check your code, u should find a declaration of an internal table called *COVP.
Something like:
DATA: *COVP LIKE STANDARD TABLE OF COVP.It's not a good thing this definition, because *TABLE is usually used to define an image of dictionary table:
TABLES: COVP,
*COVP.It's usually used this defination when it needs to do several selects of the same table without overwriting the headerline:
* First select
SELECT * FROM COVP WHERE .....
* Second select
SELECT * FROM *COVP WHERE....Max
Edited by: max bianchi on Apr 14, 2008 10:50 AM
‎2008 Apr 14 9:40 AM
hi,
*covp is a table structure(work area ) of covp ... You can find the declaration of this structure in the Top Include program ...
Regards,
Santosh
‎2008 Apr 14 9:45 AM
if inetrnal table contains data's already, INTO statement clears that data and insert a new rows of data...but APPENDING will append a new row,it will not clear the exsting data..
eg:
if internal table contains 10 rows..
INTO table clear the 10 rows and insert a next 10 rows..
now table contains 10 rows...
but APPENDING statement insert a rows from 11th to 20 rows..
now internal table contains 20 rows...
<REMOVED BY MODERATOR>
Regards
Sugumar G
Edited by: Alvaro Tejada Galindo on Apr 14, 2008 5:20 PM
‎2008 Apr 14 9:49 AM
Hi ,
thanks but what i ask is not for appending i wont to now what give the ***
before table name
‎2008 Apr 14 9:46 AM
Hi Frds
Appending Table : Works like APPENDING TABLE itab, except that the read lines are appended to the old contents of the internal table itab.
INTO TABLE : Works like INTO TABLE wa, except that the selected data is not placed in the internal table itab line by line, but in one single operation. In this case, SELECT does not introduce a processing loop, so there can be no ENDSELECT statement.
Reward Me Points
By
Pari
‎2008 Apr 14 9:49 AM
Hi
Try to check your code, u should find a declaration of an internal table called *COVP.
Something like:
DATA: *COVP LIKE STANDARD TABLE OF COVP.It's not a good thing this definition, because *TABLE is usually used to define an image of dictionary table:
TABLES: COVP,
*COVP.It's usually used this defination when it needs to do several selects of the same table without overwriting the headerline:
* First select
SELECT * FROM COVP WHERE .....
* Second select
SELECT * FROM *COVP WHERE....Max
Edited by: max bianchi on Apr 14, 2008 10:50 AM
‎2008 Apr 14 9:52 AM
hi,
There is as such no significance of '*' before table declaration. But in most of the standard programs you find it using in that way ...
Regards,
Santosh