Append Structure

[Former Member]

Hi all,

How many append structure can be added for only one table?

How is prepared it??

Reply me soon,

Thx,

S.Suresh

[Former Member]

I'd doubt there is a limit to the number of includes allowed in a table definition. The limit would more likely be on the total length of the record. That limit would like be an interval of 64k.

[Former Member]

hi,

we can add 15 append structures.

Regards,

Sindhu

[Former Member]

you can append maximum 9 structures....

go to se11 --> there is one button on appication tool bar at right top.

-> click on that-> give structure name --> provide data element names -->then create.......

<REMOVED BY MODERATOR>

Thanks and Regard,

khasimsa shaik

Edited by: Alvaro Tejada Galindo on Apr 14, 2008 1:35 PM

[Former Member]

I'd be willing to bet that each include could then contain the 9 or 15 as mentioned, leaving the number virtually unlimited.

Exampe:

table xxx

.include strucA.

.include strucB.

SturcA

.include strucC

.include strucD

.include strucE

.include strucF

StrucB

.include strucG

.include strucH

.include strucI

[Former Member]

You Can append n no. of structure to a DB Table.

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 This graphic is explained in the accompanying text to get the dialog box for entering the name.

3. Enter the append structure name and choose This graphic is explained in the accompanying text. 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

Structure linkCreating 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.

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

6. Choose This graphic is explained in the accompanying text.

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.

Edited by: Naresh Chandra Jha on Apr 14, 2008 1:40 PM

[prasanth_kasturi]

hi i think there is no limit to the number of append structures we add to a table, as i created upto 20 appends for a table

click on appendstructure on application tool bar

or goto---> appendstructures.

after you create the first one then right click on it you have create option

regards

prasanth

[Former Member]

hi,

you can add 9 append structures to a table.

rgds

umakanth