‎2008 Feb 15 5:34 AM
hi,
can i append a structure into standard SAP table????
plz tell me the steps....
It's urgent.....
‎2008 Feb 15 5:47 AM
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
‎2008 Feb 15 5:36 AM
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.
‎2008 Feb 15 5:37 AM
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.
‎2008 Feb 15 5:41 AM
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'...
‎2008 Feb 15 5:47 AM
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
‎2008 Feb 15 6:09 AM
‎2008 Feb 15 7:05 AM