Application Development and Automation 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: 
Read only

append structure

Former Member
0 Likes
3,740

hi,

can i append a structure into standard SAP table????

plz tell me the steps....

It's urgent.....

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,899

Procedure

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.

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.

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.

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.

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.

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.

Choose .

Result

The table will also be activated when the append structure is activated. The fields of the append structure are appended to the table in the database. Foreign keys or search help attachments for the fields that are already in the table and that were defined with the append structure are also activated.

You can display information about the activation process with Utilities ® Activation log. Errors occurring when the append structure is activated are displayed directly in the activation log.

See also:

Append Structures

6 REPLIES 6
Read only

Former Member
0 Likes
1,899

hi,

Append structures permit you to append customer fields to a SAP standard table without having to

modify the table definition.

An append structure is a structure which is assigned to exactly one table. There can be several append

structures for a table.

When a table is activated, all the active append structures for the table are found and their fields are

appended to the table. If an append structure is created or changed, the table to which it is assigned is

also activated and the changes also take effect there when it is activated.

Like all structures, an append structure defines a type that can be used in ABAP programs.

Please note the following points about append structures:

No append structures may be created for pooled and cluster tables.

If a long field (data type LCHR or LRAW) occurs in a table, it cannot be extended with append structures. This is because such long fields must always be in the last position of the field list, i.e. they

must be the last field of the table.

If you as a customer add an append structure to an SAP table, the fields in this append structure

should be in the customer namespace for fields, that is they should begin with YY or ZZ. This prevents

name collisions with new fields inserted in the standard table by SAP.

If you as a partner have your own reserved namespace for your developments, the fields you select in

append structures should always lie in this namespace.

Hope this helps.

Read only

Former Member
0 Likes
1,899

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.

1.go to se14 (T code for Database Utility.

2.give object name as table name there.

3.press 'edit'

4.u have a tab 'Activate and adjust database changes'

u will get a success message.

Reward Points if useful.

Read only

Former Member
0 Likes
1,899

Check this link.

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

Basically APPEND structures are used to add additional fields to exactly one table

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

You can createappend structureusing SE11 Trans.

Or Using 'Append Struture' / ' Goto --> Append Structure' / 'F5'...

Read only

Former Member
0 Likes
1,900

Procedure

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.

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.

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.

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.

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.

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.

Choose .

Result

The table will also be activated when the append structure is activated. The fields of the append structure are appended to the table in the database. Foreign keys or search help attachments for the fields that are already in the table and that were defined with the append structure are also activated.

You can display information about the activation process with Utilities ® Activation log. Errors occurring when the append structure is activated are displayed directly in the activation log.

See also:

Append Structures

Read only

Former Member
0 Likes
1,899

my program is not run

Read only

0 Likes
1,899

Hi,

Can you pls share the requirement here?

Regards,

Renjith Michael.

http://www.sourceveda.com/