Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

appending table *

Former Member
0 Likes
912

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
879

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

6 REPLIES 6
Read only

Former Member
0 Likes
879

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

Read only

Former Member
0 Likes
879

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

Read only

0 Likes
879

Hi ,

thanks but what i ask is not for appending i wont to now what give the ***

before table name

Read only

Former Member
0 Likes
879

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

Read only

Former Member
0 Likes
880

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

Read only

Former Member
0 Likes
879

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