topic append structure in Application Development and Automation Discussions

append structure

Former Member — Wed, 07 Mar 2007 07:53:00 GMT

append structure in table,what happens when version is upgraded?could u plzz tell me?

Re: append structure

Former Member — Wed, 07 Mar 2007 07:55:51 GMT

when the version is upgraded, the abap dictionary checks whether the appended structure is availble and also checks for consistency.

Regards,

Prasanth

*reward all helpful answers

Re: append structure

Former Member — Wed, 07 Mar 2007 07:57:43 GMT

Hi,

When you are doing Upgrade, it will ask you whether to keep the extra fields which you added in APPEND structure should be kept or to be deleted,

During the Execution of SPAU and SPDD t Codes.

Then if you need them, have to say YES otherwise NO.

Regards,

Anji

Re: append structure

Former Member — Wed, 07 Mar 2007 07:59:45 GMT

Hi soniya

1. .INCLUDE

(which appears in se11 in many tables.)

2. Well,

thats nothing but a technique

of BUNCHING / GROUPING fields

(for ease of re-use)

(instead of again and again

specifying those SET of FIELDS,

in more than 1 table)

(we can as well give each field, field-by-field,

it won't make any difference in database table)

3. However,

Append structure

is FACILITY PROVIDED BY SAP

for customer enhancment of tables.

<b>It behaves differently when

some upgrade is done in that table

by sap itself.

In such case,

when the upgrade occurs,

first the SAP fields (which are added in the standard table)

are first included in the sequence of fields,

AFTER THAT,

our APPEND structure fields,

are appended !!!</b>

regards,

amit m.

Re: append structure

seshatalpasai_madala — Wed, 07 Mar 2007 08:00:01 GMT

Hi,

You create append structures in the customer namespace. This protects them from being overwritten at upgrade or during release upgrade. New versions of standard tables are loaded during upgrades. The fields contained in active append structures are then appended to the new standard tables when these new standard tables are activated for the first time.

From Release 3.0, the field sequence in the ABAP Dictionary can differ from the field sequence in the database. Therefore, no conversion of the database table is necessary when adding an append structure or inserting fields into an existing one. All necessary structure adjustment is taken care of automatically when you adjust the database catalog (ALTER TABLE). The table's definition is changed when it is activated in the ABAP Dictionary and the new field is appended to the database table.

Regards,

Sesh