Difference between include structure and Append structure

[Former Member]

Could you please tell me

I have bsis table and it contains append structure in 4.7 SAP System.

my program in 4.7 system contains internal table which used same structure of bsis table ( which contains additonal field in its append structure ).

I need to have same table structure in 4.6 C because I am copying the same program into 4.6 system.

As I could not append structure to bsis table in 4.6C SAP system,

instead of that shall I add the field or Shall include the structure to run .

What is the difference between Include structure and Append structure ( I forgot )

How to achieve this please help me ?

[Former Member]

Hi,

Shortly:

Append structures are used for enhancements that are not included in the standard. An append structure is a structure that is assigned to exactly one table or structure. There can be more than one append structure for a table or structure.

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

Includes are used to group fields, an include structure can be assigned to many tables. If you add a fields to an include structure, all tables/structures, which contain that include structure, will be updated too.

http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21ea6a446011d189700000e8322d00/content.htm

For enhancing SAP standard you can use customising includes too, if there are any in your table.

http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21eb54446011d189700000e8322d00/content.htm

Message was edited by:

Tomasz Kozerski

[ferry_lianto]

Hi Sam,

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

Include Structure is a structure which we include under another structure which is already defined.

Please check this link for more information.

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

Regards,

Ferry Lianto

[Former Member]

Hi

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

An include Structure is a structure which we include under another structure which is already defined

INCLUDE STRUCTURE is a syntax used in ABAP coding. APPEND structure is used to add a existing structure to a Database table or a structure created in SE11

An include structure is NOT the same as an append structure. I tried in a datasource to add a field via an append structure, however I didn´t see the field in the data source. When I changed it to an Include structure everything was ok

see the link for more info

/message/1419481#1419481

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

https://forums.sdn.sap.com/click.jspa?searchID=249641&messageID=2754379

if helps reward points

-charitha.

[jayanthi_jayaraman]

Hi,

Append :

1.you can do the additions only at the end

2.Adding primary key not possible

3.More than 1 append structures used for a table

4.1 append structures can be used for one particular table.

Customizing Include

1.you can add it in any position.

2.YOu can add primary key using this

3.Can be used in more than 1 table

4.Consistency needs to be taken care because there is possiblity of using the same include in many tables

Message was edited by:

Jayanthi Jayaraman

[Former Member]

Hi ,

As you know append structure can be used only once in table ,that to at last of all entries,

Append structures are used for enhancements that are not included in the standard. This includes special developments, country versions and adding customer fields to any tables or structures.

An append structure is a structure that is assigned to exactly one table or structure. There can be more than one append structure for a table or structure.

The following enhancements can be made to a table or structure TAB with an append structure:

Insert new fields in TAB,

Define foreign keys for fields of TAB that already exist,

Attach search helps to fields of TAB that already exist,

These enhancements are part of the append structure, i.e. they must always be changed and transported with the append structure.

When a table or structure is activated, all the append structures of the table are searched and the fields of these append structures are added to the table or structure. Foreign keys and search help attachments added using the append structure are also added to the table. If an append structure is created or changed, the table or structure assigned to it is also adjusted to these changes when the append structure is activated.

Since the order of the fields in the ABAP Dictionary can differ from the order of the fields on the database, adding append structures or inserting fields in such append structures does not result in a table conversion.

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.

The new versions of the standard tables are imported after an upgrade, and the fields, foreign key definitions and search help attachments contained in the append structures are added to the new standard tables at activation.

A standard table contains the fields Field 1, Field 2 and Field 3. An append structure containing the fields ZZA and ZZB is defined for this table. After activating the table, the corresponding database table contains fields Field 1, Field 2, Field 3, ZZA and ZZB.

Further Remarks:

An append structure can only be assigned to exactly one table or structure. If you want to append the same fields to several tables or structures, you can store these fields in an include structure. In this case you must create an append structure for each of these tables or structures and include the include structure there.

Adding an append structure to an SAP standard table is supported by the Modification Assistant.

If you want to insert a field that is to be delivered with the R/3 standard in the next Release in the customer system in advance, you must include it in the table itself as a repair. If you include such a field in an append structure for the table, it will occur twice when the new standard table is imported. This will result in an activation error.

No append structures may be added to tables with long fields (data types VARC, LCHR or LRAW). This is because a long field must always be the last field in the table. However, structures with long fields can be enhanced with append structures.

If a table or structure with an append structure is copied, the fields of the append structure become fields of the target table. Foreign key definitions and search help attachments appended with the append structure are copied to the target table.

Foreign keys for the appended fields must be defined within the append structure. Fields of the table or structure assigned to the append structure may be defined when assigning the key field and foreign key field.

Indexes on the appended fields must be defined in the original table.

A table or structure TAB can only be enhanced with new foreign keys or search help attachments using an append structure. You therefore cannot change an existing foreign key definition or search help attachment for a field of TAB with the append structure.

Thanks

Manju

[Former Member]

hi sam,

append structures are one that are added to the table.it is table specific..

include structures are one which can be added to multiple tables..