Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

STRUCTURE?

Former Member
0 Kudos

HI,

difference between include structure and append structure?

Nayak.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

HI,

Include

1.) You add a field in the name space of SAP (like PRCTR). In this case it is necessary to modify the extract structure and to get an access key via the OSS. The "MOVE-CORRESPONDING" does only work in this case. (This means the field is copied into the extract

structure without adding any code.)

Append

2.) You add a field, that lies in the customer name range. By adding such a field in an append structure you cause no modification and no OSS access key is necessary. Nevertheless the field is not copied into the extract structure automatically, if you choose

this second solution.

Check this SAP help

on append structure and Include Structure

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb54446011d189700000e8322d00/frameset.htm

Difference Between them

http://sap.ittoolbox.com/groups/technical-functional/sap-r3-bw/append-structure-vs-include-structure...

Kishore.

5 REPLIES 5

amit_khare
Active Contributor
0 Kudos

Check this link-

Regards,

Amit

Former Member
0 Kudos

hi,

append structure for perticular use.

include structure for multiple table uses.

more information.

Includes

some thrids.

check...

In addition to listing the individual fields, you can also include the fields of another structure in tables and structures. Individual fields and includes can be mixed as required.

When an include is changed, all the tables and structures that include it are automatically adjusted.

Structure A was included in table B. A new field is inserted in structure A. When structure A is activated, table B is adjusted to this change, that is the new field is also inserted there.

You can assign the include a group name with which the group of fields in the include can be addressed as a whole in ABAP programs.

Includes can also be nested, that is structure A includes structure B which in turn includes another structure C, etc. The maximum nesting depth is limited to nine. The maximum length of a path of nested includes in a table or structure is therefore nine (the table/structure itself not included).

Only flat structures can be included. In a flat structure, every field either refers to a data element or is directly assigned a data type, length and possibly decimal places.

Only structures may be included in a table. Tables, structures and views may be included in a structure.

The length of the field names is more restricted in tables than in structures. In a table, a field name may not have more than 16 places, but in a structure up to 30 places are allowed for the field name. A structure therefore can only be included in a table if none of the field names of the structure are longer than 16 places.

The path of nested includes may only contain one table.

Table TAB1 includes structure STRUCT1, which in turn includes structure STRUCT2. The path of the nested includes here only contains table TAB1. It is also possible to include TAB1 in a further structure STRUCT0,

but no other table TAB2 may be included in TAB1 since in this case a path of nested includes would contain two tables (TAB1 and TAB2).

Append Structures

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.

If you create an append structure for a table or structure, only those enhancements are allowed that are consistent with the enhancement category of the enhanced table or structure. For more information, see Structure Enhancements.

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 theModification 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.

See also:

Message was edited by:

sunil kumar

Former Member
0 Kudos

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 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.

<b>The main difference is

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.

And U can append APPEND STRUCTURES onli after the last filed of the table , but u can include the INCLUDE STRUCTURES any where in between the table fields..</b>

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.

reward if it helps u..

sai ramesh

Former Member
0 Kudos

HI,

Include

1.) You add a field in the name space of SAP (like PRCTR). In this case it is necessary to modify the extract structure and to get an access key via the OSS. The "MOVE-CORRESPONDING" does only work in this case. (This means the field is copied into the extract

structure without adding any code.)

Append

2.) You add a field, that lies in the customer name range. By adding such a field in an append structure you cause no modification and no OSS access key is necessary. Nevertheless the field is not copied into the extract structure automatically, if you choose

this second solution.

Check this SAP help

on append structure and Include Structure

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb54446011d189700000e8322d00/frameset.htm

Difference Between them

http://sap.ittoolbox.com/groups/technical-functional/sap-r3-bw/append-structure-vs-include-structure...

Kishore.