append structure

[Former Member]

hai sir

for long field ,,,u r not using 'append structure' ,.....give me reason...

[Former Member]

Hi,

No append structures can 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.

Reward if helpful

Regards

Sandipan

[Former Member]

Hi Venu,

Its nice to see that you want to get some details on Append Structure and why it can't be used with long fields.

First of lets see what is an append structure.

Append structures are used for enhancements which are not provided for in the standard.

An append structure is assigned to exactly one table. There can however be several append structures to one table.

An append structure permits the following enhancements to a table or structure:

(a) Add new fields (b) Add foreign keys to fields of the appending object

(c) Add search help attachments to fields of the appending object

Append structures are created by customers in the customer name range and are thus protected against overwriting in upgrades or release upgrades. After a release upgrade, the new versions of the standard tables are imported and fields contained in append structures are appended to the new standard tables.

SAP Clearly states the following with respect to APPEND STRUCTURES.

Append structures can only be created for transparent tables and structures. It is not possible to add fields with an append structure for transparent tables containing a long field. Furthermore, append structures may not be created for tables and structures of the central Basis of the R/3 System.

Hope this helps. Reward if useful.

Thanks and Regards,

Maddineni Bharath.

[Former Member]

hi,

While appending a structure the long fields i.e. LCHAR, LRAW are not fixed variable lengths. while appending this type of structure system cannot append this type of fields as these are not fixed.

manas

[Former Member]

Hi,

We can add new fields to an existing table using

Append Structure

This is the procedure for the Append Structure:

1.Go to change mode in the maintenance screen of the table where you want to add the append structure.

2. Choose Goto -> Append structures.

3. Enter the append structure name and choose enter .

4. Define the fields of the append structure.

You can proceed as when creating a normal structure two restrictions .

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

2.That is the field names must begin with ZZorYY. This prevents conflicts with fields inserted in the table by SAP.

5. Choose Activate.

reward if it is useful

thanks...

[Former Member]

Hi Venu,

You cannot use append structure with long fields because in a

structure the maximum field length is 30 characters.

But for a table the maximum field length is only 16 characters.

when you append structure whose field lengths are greater than 16 characters to a table the database cannot adjust to that change.

So this is a must check condition for appending structures.

Reward points if useful.

Thanks,

Surya Pydikondala

[Former Member]

Hi Venu,

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.

Please check this link .

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

Regards,

Muneesh Gitta.

[Former Member]

Hi

Go through the information regarding append structure....

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.

With Release 4.6C you can define foreign keys for fields that already exist in the table using an append structure. Search helps can also be attached to fields that already exist in the table.

Customers create append structures in their namespace. The append structures are thus protected against overwriting during an upgrade.

The new versions of the standard tables are imported during the upgrade. When the standard tables are activated, the fields contained in the active append structures are appended to the new standard tables. When append structures are added to a table, you therefore do not have to manually adjust the customer modifications to the new SAP version of the table (Transaction SPDD) during the upgrade.

The order of the fields in the ABAP Dictionary can differ from the order of the fields in the database. You therefore do not have to convert the table when you add an append structure or insert fields in an existing append structure. The new fields are simply appended to the table in the database. You can always adjust the structure by adjusting the database catalog (ALTER TABLE).

The new version of the SAP standard table is activated and the new field is appended to the database table.

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.

thanx

Sravani.

Plz reward points if useful.........