What is the difference between .APPEND @ .INCLUDE

[Former Member]

Hi

What is the difference between .APPEND @ .INCLUDE in data dictionary

[matt]

When a table is defined with an INCLUDE, the fields of the include will be part of the underlying table on the database. With an APPEND, the extra fields are incorporated, at a db level, into a seperate table, but with the same key as the master table.

However, at the ABAP level, the table behaves in either case as a single table.

Append structures are very useful in adding additional fields to standard SAP tables, without actually making changes.

matt

[Former Member]

Difference between append & include structure:

Append structures are used for enhancements which are not provided for in the standard (special developments, country versions and adding customer fields to SAP standard tables).

An append structure is assigned to exactly one table. i.e., an append structure can be used only for the table it is created.

Append structures can not be used with cluster and pool tables

Append structures are created in transaction SE11. Display the standard table fields and press the Append structure button.When you press the button, SAP sugests a name for the new append structure. After you has accepted the name, a screen will be shown where you can enter the new fields.

Append structures are created in the custome rnamespace ( ZZ or YY)

An include structure is reusable i.e., can be used in several tables.If you add a field to an include structure, all tables that contain that include structure will be updated.

Customizing includes begin with CI_ and is part of the customer namespace

One Customizing include can be inserted into more than one table.

You can find Customizing includes in SE11 under structures.

Regards,

Maha

[Former Member]

Hi,

to add some additional fields to existing database table we will use structures .

in two ways we can add structures using append,include.

if u add using append it is only for that perticular table.can't reuse that structure in other tables.

if u add using include we can reuse that sructure in any other other tables it acts just like include.

Ex: address fields ading to table using structure.

it can use for employee adress ,

Customer address,

student address.

.include-xxx

xxx = 001

like fields will differ.

if u r inserint long field in table it will add at end of the table

at that time if you are using append it won't add field into table.

[Former Member]

Enhancement using Append structures

Append structures allow you to attach fields to a table without actually having to modify the table itself. You can use the fields in append structures in ABAP programs just as you would any other field in the table.

Click on the append structure tab and opt to create new

structure.

Append structures allow you to enhance tables by adding fields to them that are not part of the standard. With append structures; customers can add their own fields to any table or structure they want.

Append structures are created for use with a specific table. However, a table can have multiple append structures assigned to it

Customers can add their own fields to any table or structure they want.

The customer creates append structures in the customer namespace. The append structure is thus protected against overwriting during an upgrade. The fields in the append structure should also reside in the customer namespace, that is the field names should begin with ZZ or YY. This prevents name conflicts with fields inserted in the table by SAP

Enh. using Customizing includes

Some of the tables and structures delivered with the R/3 standard contain special include statements. These are often inserted in those standard tables that need to have customer-specific fields added to them. Such includes are Customizing includes. (CI).

A Customizing include is a structure that satisfies a special naming convention. (name begins with CI_).

A Customizing include is a structure that satisfies a special naming convention. The name of a Customizing include begins with ‘CI_’ and the include is in the customer namespace .

If enhancements are already planned in the R/3 standard using customer-specific fields, such Customizing includes are included. in the corresponding standard table or standard structure. The Customizing include (that is the definition of the structure itself) is usually first created in the customer system and filled with fields by special Customizing transactions.

Customers can add their own fields to any table or structure they want.

The Customizing include field names must lie in the customer namespace just like field names in append structures. These names must all begin with either YY or ZZ.

Append structures v/s Customizing includes

In contrast to append structures, Customizing includes can be inserted into more than one table.

As an example the customizing include that we created (CI_DEMO) could be a part of multiple tables in the database whereas the append structure (ZDEMO_APPEND) can only be assigned to one table. (here MARA).

This provides for data consistency throughout the tables and structures affected whenever the include is altered.

Regards.