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: 

ABAP DICTIONARY

Former Member
0 Kudos

In a database table we can Include structure and we can append structure .what is the difference between Include structure and append structure in a database table?

1 ACCEPTED SOLUTION

vinod_vemuru2
Active Contributor
0 Kudos

Hi Srini,

Simple. INCLUDE structure is reusable i.e U can include same structure in many tables. But APPEND structure u can do it in only one table. Once u use SPPEND structure then u can't use it again. Then u may get a doubt why can't we directly add fields in the table instead of APPEND. Reason being we can't use it Tables more than once but always we can refer in programs and FMs. Here INCLUDE and APPEND is structure type.

Thanks,

Vinod.

3 REPLIES 3

matt
Active Contributor
0 Kudos

If you have fields A B C D E, field A being key, and fields D and E are INCLUDEd, then the table at db level will have fields A B C D E.

If you have fields A B C D E, field A being key, and fields D and E are APPENDed, then there are two tables at db level; one with fields A B C, and one with fields A D E.

In both cases, however, in ABAP you treat them as though they were one table with fields A B C D E.

matt

Former Member
0 Kudos

hi

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.

for more info check this link

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

Cheers

Snehi Chouhan

vinod_vemuru2
Active Contributor
0 Kudos

Hi Srini,

Simple. INCLUDE structure is reusable i.e U can include same structure in many tables. But APPEND structure u can do it in only one table. Once u use SPPEND structure then u can't use it again. Then u may get a doubt why can't we directly add fields in the table instead of APPEND. Reason being we can't use it Tables more than once but always we can refer in programs and FMs. Here INCLUDE and APPEND is structure type.

Thanks,

Vinod.