topic Re: Definition in Application Development and Automation Discussions

Definition

Former Member — Mon, 16 Apr 2007 05:53:23 GMT

Hi can any one give simple definition for the below wrt internal table ..

Append

Insert

Read

Modify

Delete

Collect

Kumar

Re: Definition

Former Member — Mon, 16 Apr 2007 05:57:22 GMT

APPEND:

Append is used to add a line to an index table at the end, use the statement:

APPEND <line> TO <itab>.

<line> is either a work area that is convertible to the line type

INSERT:

The INSERT statement allows you not only to insert lines in any type of internal table, but also allows you to change them using a line index. You can insert either a single line or a group of lines into index tables using the index.

READ:

To read a single line of any table, use the statement:

READ TABLE <itab> <key> <result>.

MODIFY:

You can use the MODIFY statement to change lines in tables using their index

MODIFY <itab> FROM <wa> [INDEX <idx>] [TRANSPORTING <f1> <f 2> ... ].

The work area <wa> specified in the FROM addition replaces the existing line in <itab>. The work area must be convertible into the line type of the internal table.

If you use the INDEX option, the contents of the work area overwrites the contents of the line with index <idx>. If the operation is successful, SY-SUBRC is set to 0. If the internal table contains fewer lines than <idx>, no line is changed and SY-SUBRC is set to 4.

DELETE:

To delete lines of any internal table, use the DELETE statement.

COLLECT:

The following statement allows you to summate entries in an internal table:

COLLECT <wa> INTO <itab>.

<itab> must have a flat line type, and all of the fields that are not part of the table key must have a numeric type (F, I, or P). You specify the line that you want to add in a work area that is compatible with the line type.

also see the following links:

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb36c8358411d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb361f358411d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb35f8358411d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb35eb358411d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/06/aafd54fc4011d195280000e8353423/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb36d5358411d1829f0000e829fbfe/frameset.htm

Reward points if useful......

Suresh.....

Re: Definition

Former Member — Mon, 16 Apr 2007 05:57:29 GMT

Hi Kumar,

Go to the ABAPDOCU T code, and there you can find the required hlep for your post.

Regards

Re: Definition

Former Member — Mon, 16 Apr 2007 05:57:30 GMT

Hi,

To add a line to an index table, use the statement:

APPEND <line> TO <itab>.

<line> is either a work area that is convertible to the line type, or the expression INITIAL LINE. If you use <wa>, the system adds a new line to the internal table <itab> and fills it with the contents of the work area. INITIAL LINE appends a blank line containing the correct initial value for each field of the structure. After each APPEND statement, the system field SY-TABIX contains the index of the appended line.

Appending lines to standard tables and sorted tables with a non-unique key works regardless of whether lines with the same key already exist in the table. Duplicate entries may occur. A runtime error occurs if you attempt to add a duplicate entry to a sorted table with a unique key. Equally, a runtime error occurs if you violate the sort order of a sorted table by appending to it.

To add a line to an internal table, use the statement:

INSERT <line> INTO TABLE <itab>.

<line> is either a work area that is compatible with the line type, or the expression INITIAL LINE. The work are must be compatible because the fields in the table key must be filled from fields of the correct type. INITIAL LINE inserts a blank line containing the correct initial value for each field of the structure.

If the table has a unique key and you attempt to insert lines whose key already exists in the table, the system does not add the line to the table, and sets SY-SUBRC to 4. When the system successfully adds a line to the table, SY-SUBRC is set to 0.

To read a single line of any table, use the statement:

READ TABLE <itab> <key> <result>.

For the statement to be valid for any kind of table, you must specify the entry using the key and not the index. You specify the key in the <key> part of the statement. The <result> part can specify a further processing option for the line that is retrieved.

If the system finds an entry, it sets SY-SUBRC to zero, if not, it takes the value 4, as long as it is not influenced by one of the possible additions. If the internal table is an index table, SY-TABIX is set to the index of the line retrieved. If the table has a non-unique key and there are duplicate entries, the first entry is read.

To delete a line using its index, use the following statement:

DELETE <itab> [INDEX <idx>].

If you use the INDEX addition, the system deletes the line with the index <idx> from table <itab>, reduces the index of the subsequent lines by 1, and sets SY-SUBRC to zero. Otherwise, if no line with index <idx> exists, SY-SUBRC is set to 4.

Without the INDEX addition, you can only use the above statement within a LOOP. In this case, you delete the current loop line (<idx> is implicitly set to SY-TABIX).

COLLECT <wa> INTO <itab>.

When the line is inserted, the system checks whether there is already a table entry that matches the key. If there is no corresponding entry already in the table, the COLLECT statement has the same effect as inserting the new line. If an entry with the same key already exists, the COLLECT statement does not append a new line, but adds the contents of the numeric fields in the work area to the contents of the numeric fields in the existing entry.

You should only use the COLLECT statement if you want to create summarized tables. If you use other statements to insert table entries, you may end up with duplicate entries.

To change a single line, use the following statement:

MODIFY TABLE <itab> FROM <wa> [TRANSPORTING <f1> <f 2> ...].

The work area <wa>, which must be compatible with the line type of the internal table, plays a double role in this statement. Not only it is used to find the line that you want to change, but it also contains the new contents. The system searches the internal table for the line whose table key corresponds to the key fields in <wa>.

The system searches for the relevant lines as follows:

Standard tables

Linear search, where the runtime is in linear relation to the number of table entries. The first entry found is changed.

Sorted tables

Binary search, where the runtime is in logarithmic relation to the number of table entries. The first entry found is changed.

Hashed tables

The entry is found using the hash algorithm of the internal table. The runtime is independent of the number of table entries.

If a line is found, the contents of the non-key fields of the work area are copied into the corresponding fields of the line, and SY-SUBRC is set to 0. Otherwise, SY-SUBRC is set to 4. If the table has a non-unique key and the system finds duplicate entries, it changes the first entry.

You can specify the non-key fields that you want to assign to the table line in the TRANSPORTING addition. You can also specify a field <f i > dynamically as the contents of a field <n i > in the form (<n i >). If <n i > is empty when the statement is executed, it is ignored. You can restrict the search to partial fields by specifying offset and length.

For tables with a complex line structure, the usage of the transporting option results in better performance, if the system must not transport unnecessary table-like components.

reward points if useful.

regards,

kiran kumar k

Message was edited by:

kiran kumar

Message was edited by:

kiran kumar

Re: Definition

Former Member — Mon, 16 Apr 2007 06:00:40 GMT

Append ; used for to read data from internal table to work area

Insert ; Use the insert lines statement when you want to insert rows at a place other than the end into the target table.

Read ; this used for to read only specified records only.

Modify ;To modify the contents of one or more rows of an internal table, use the modify statement.

Delete ; used to delete the particular fields

Collect ; it is used for totals

praveen

Re: Definition

Former Member — Mon, 16 Apr 2007 06:23:06 GMT

Hi,

1. APPEND:It appends the records into at end of the internal table

syntex -

APPEND line_spec TO itab .

2.INSERT:it inserts the records in internal table at any where.

syntax -

INSERT line_spec INTO itab_position.

3.READ:It reads the recors from internal table with help of key or index.

syntax:READ TABLE itab { table_key

| free_key

| index } result.

4.MODIFY:This statement changes the content of one or several itab ,that can be specified using the table key or the table index

syntax:MODIFY {itab_line|itab_lines}.

5.DELETE:This statement either deletes one or more rows itab specified with the table key or table index.

6.COLLECT:This statement inserts the contents of a work area wa either as single row into an internal table itab or adds the values of its numeric components to the corresponding values of existing rows with the same key

syntax:COLLECT wa INTO itab .

Pls give Rewards if helpful

Thanks

Vana