append and include stucture

Former Member · ‎02-05-2008

what is the difference b/w append structure and

include structure in the database

Edited by: phanidhar yarlagadda on Feb 5, 2008 11:44 AM

Edited by: phanidhar yarlagadda on Feb 5, 2008 11:47 AM

Edited by: phanidhar yarlagadda on Feb 5, 2008 11:50 AM

Former Member · ‎02-05-2008

Hello Phanindar,

Can you please explain your question clearly...?

Regards

--

Sasidhar Reddy Matli.

Former Member · ‎02-05-2008

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.

Reward i fusefull

Vijay · ‎02-05-2008

hi

what i git is you want to know difference between include structure and append structure.

include structure is like the structure is already created in se11 and you can add it into your structure or custom table.INCLUDE structure is used to include fields to several tables. If you add a fields to an include structure all tables that contain that include structure, will be updated too..

append structure is like adding a structure while creating a structure or custom table.An append structure is a structure assigned to just one table. When a table is activated, all append structures for the table are found and appended to the table. Append structures are used to add customer fields to SAP tables.

both these are used to create deep structure eg purchase order have header data and multiple item details for that header data and there we need to have deep structure.

for more chk out this link..

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb61446011d189700000e8322d00/content.htm

regards

vijay

reward points if helpful

Former Member · ‎02-05-2008

INCLUDE Structures:

Include Structure is used to include the structure to a Custom Table.

The same Structure can be Included in any number of Custom Tables.

To Include it in the Custom Table Provide .INCLUDE as field name and Structure name as Field Type.

APPEND Structures:

Append Structure is used to append to the Standard Tables.

The Same Append Structure cannot be appended in more then one Standard DB Table.

We need to create the Append Structure by opening the Table in Display mode and by clicking on the Append Structure button.

Reward Points if useful.

Former Member · ‎02-05-2008

hi,

1. Append Structures

Append structures can only be assigned to a single table.

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

In case of new versions of the standard table during upgrade, the append structures are automatically appended to the new version of the standard table

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.

Remember to activate.

2. Customizing Includes

Some of the SAP standard tables contains special include statements called Customizing includes. In contrast to Append structures,

Note that customizing includes are created by SAP, but the customer supply the fields for the include.

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.

Try to take a look at table RKPF which uses the Customizing include CI_COBL (In an IDES system). Next try to add a field to CI_COBL, and activate it. If you go back to table RKPF you will se that your new field has been added.

reward points if helpful,

kushagra

Former Member · ‎02-05-2008

Hi Sir ,

Please have a look below .Hope it is suitable and simpler solution for your question.

Please do reward if useful.

Thankx.

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.

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.

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.

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 · ‎02-05-2008