data dictionary

[Former Member]

what is append structure and include structure , wiil those exists in underlying database .

[Former Member]

For append structure

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

for include structure.

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

[Former Member]

what is append structure ?

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.

Adding an Append Structure

Procedure

1.Go to change mode in the maintenance screen of the table where you want to add the append structure.
If the table contains a long field (data type VARC, LCHR or LRAW), you cannot add an append structure.

2.Choose Goto -> Append structures.
Either a dialog box appears in which you can enter the name of the append structure or a list of all the append structures. that were already created for the table appears. If append structures already exist, you have to choose to get the dialog box for entering the name.

3.Enter the append structure name and choose . The name must lie in the customer namespace.
You go to the field maintenance screen of the append structure.

4.Define the fields of the append structure. You can proceed as when creating a normal structure with two restrictions (see Creating Structures).
The fields of an append structure must lie in the customer namespace, that is the field names must begin with ZZ or YY. This prevents conflicts with fields inserted in the table by SAP.

5.An append structure must be flat, that is each field of the append structure must either refer to a data element or be directly assigned a data type, length, decimal places and short text.

6.If you want to create foreign keys or search help attachments for table fields that already exist, you can display these fields with Show appending objects. Proceed as if you wanted to create the foreign key or search help attachment in the underlying table (see Creating Tables).
If a foreign key or search help attachment is already defined for a field in the table, you cannot change this definition with the append structure.

7.Choose Activate.

what is include structure ?

Only flat structures may be included in a table. No field refers to another structure in a flat structure. All the fields of a flat structure therefore refer either to a data element or were directly assigned a data type, field length and decimal places.

A field name may not have more than 16 places in a table. A structure therefore can only be included in a table if none of the field names of the structure are longer than 16 places.

Procedure

1.Place the cursor under the line in which you want to insert the include and choose Edit ->Include -> Insert.

A dialog box appears.

2.Enter the structure name. You can optionally enter a group name (see Named Includes) or a three-place suffix. With the group name, you can access the fields in the include together in ABAP programs.

3.The suffix can be used to avoid name collisions between fields of the include and fields already in the table. The suffix is added to all the fields of the include, whereby the field name is first truncated if necessary.

4.Choose Tickmark .

A line with .INCLUDE in the Fields field and the name of the include in the Field type field is inserted in the field maintenance screen for the table.

5.Select column Key if all the fields in the include should be key fields of the table.

The table key must be at the start of the field list. If you select column Key, you must insert the include after the last key field or between the existing key fields of the table.

If you do not select column Key, none of the included fields is a key field of the table.

6.Choose activate.

reward points if it is usefull.....

Girish

[Former Member]

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.

Pls do reward points.

Regards,

Ameet