topic Re: appending table * in Application Development and Automation Discussions

appending table *

Former Member — Mon, 14 Apr 2008 08:38:51 GMT

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

Re: appending table *

Former Member — Mon, 14 Apr 2008 08:40:52 GMT

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

Re: appending table *

Former Member — Mon, 14 Apr 2008 08:45:28 GMT

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

Re: appending table *

Former Member — Mon, 14 Apr 2008 08:46:53 GMT

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

Pari

Re: appending table *

Former Member — Mon, 14 Apr 2008 08:49:04 GMT

Hi ,

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

before table name

Re: appending table *

Former Member — Mon, 14 Apr 2008 08:49:25 GMT

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

Re: appending table *

Former Member — Mon, 14 Apr 2008 08:52:01 GMT

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