topic Re: Include structure in a DB table in Application Development and Automation Discussions

Include structure in a DB table

Former Member — Wed, 21 May 2008 11:35:33 GMT

Can anybody tell me the procedure to include an 'Include Structure' into an existing DB table say MARA.

Thanks in advance.

Re: Include structure in a DB table

Former Member — Wed, 21 May 2008 11:39:50 GMT

Hi,

in customized table...in se11 create a structure....and call the that structure in the table ....

.include...in data type ..write the structure which u created.

if u want to append a structure ..there is a tab ...APPEND STRUCTURE ...in that u can declare the feilds in the structure and save and activate and call the structure in table.

u can append a structure only at end of all feilds whereas include u can add anywhere between the feilds.

*******

INCLUDE Structures:

Include Structure is used to include the structure to a Custom Table.

The same Structure can be Included in any number of Custom Tables.

To Include it in the Custom Table Provide .INCLUDE as field name and Structure name as Field Type.

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.

Check this SAP help

on append structure and Include Structure

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

Regards,

Shiva Kumar

Re: Include structure in a DB table

Former Member — Wed, 21 May 2008 11:43:50 GMT

Hi,

include Structure:- Include structures are used to add fields in the middle also.where as append structures adds fields only at the end.In addition to listing the individual fields, you can also include the fields of another structure in tables and structures. Individual fields and includes can be mixed as required.

Regards

Kiran Sure

Re: Include structure in a DB table

Former Member — Wed, 21 May 2008 13:24:06 GMT

Hi,

To include a structure to custom database table:

first ..

-->create a structure with the required fields in SE11 t.code.

-->then include the structure using .include statement.

we can add structures to the database tables using append and include structures.

Append structures allow you to attach fields to a table without actually having to modify the table itself. Table enhancements using append structures therefore do not have to be planned by SAP developers. An append structure can only belong to exactly one table.

In contrast, CI_includes allow you to use the same structure in multiple tables. The include statement must already exist in the SAP table or structure. Table enhancements using CI_includes do, however, have to be planned by SAP developers

regards,

vineela.

Re: Include structure in a DB table

Former Member — Wed, 21 May 2008 15:35:55 GMT

INCLUDE STRUCTURE IN DATABASE TABLE:-

Structures can be added into the database table in two ways

1) By Appending Structures into the database table

2) By Including structures into the database table

Procedure for Including a structure into the database table

Only flat structures may be included in a table. No field refers to another structure in a flat

structure. All the fields of a flat structure therefore refer either to a data element or were directly

assigned a data type, field length and decimal places.

1. Place the cursor under the line in which you want to insert the include and

choose Edit u2192 Include u2192 Insert.

A dialog box appears.

2. Enter the structure name.

3. Choose OK( thats a tick mark ).

A line with .INCLUDE in the Fields field and the name of the include in the Field type field

is inserted in the field maintenance screen for the table.

4. Select column Key if all the fields in the include should be key fields of the table.

The table key must be at the start of the field list. If you select column Key, you must

insert the include after the last key field or between the existing key fields of the table.

If you do not select column Key, none of the included fields is a key field of the table.

5. Choose activate.

You can find information about the activation flow in the activation log, which you can display with

Utilities u2192 Activation log. The activation log is displayed immediately if errors occur when the

table is activated.

Correct me if iam wrong.

Hope this will be useful to u.

cheers,

AKD.