topic Re: Data dictinary table in Application Development and Automation Discussions

Data dictinary table

Former Member — Tue, 12 Feb 2008 09:50:51 GMT

Hi Guys,

How to include LIFNR field in MARA table?

What is the difference b/w append structure & include structure in a table?

kavitha

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 09:56:31 GMT

Append structures are like user exits provided by SAP to enhance the Standard tables. It behaves like include structure only, but this append structure is taken care in the SAP version upgrage process, automatically. The name of append structure starts with 'Z' namespace..SAP by default proposes the append structure name with the table name prefixed with 'Z'.

It is always recommended to modiy or append the Standard tables using append structure.

Yeah, its the standard provided for SAP standard table enhancement.

and as you know, Include structures are used to include mulitple fields into a table, even during creation of a table.

Hope this answers your question.

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 09:58:10 GMT

hi,

Please read the append structures document below carefully to understand the difference.

Includes:

With tables and structures it is possible to include the fields of another structure as well as to list the individual fields. Individual fields and includes can be combined as required.

If an include is changed, all the tables and structures that contain this include are automatically adjusted.

Example: Structure X is included in tables A and B. If another field is inserted into structure X, this field is also inserted in tables A and B.

Includes can also be nested, i.e. structure A includes structure B, which in turn includes another structure C etc. The maximum nesting depth is limited to nine. A path of nested includes in a table or structure therefore can have at most length nine (excluding the table/structure itself).

Only flat structures can be included. In a flat structure, each field either refers to a data element or is directly assigned a data type and length by direct type entry.

Only structures can be included in a table. Both tables and structures can be included in a structure, but only one table may lie on a path of nested includes.

Example: Table TAB1 includes structure STRUKT1, which in turn includes structure STRUKT2. Only table TAB1 lies on the path of nested includes. It is also possible to include TAB1 in a further structure STRUKT0, but no other table may be included in TAB1 because in this case two tables (TAB1 and TAB2) would lie on a path of nested includes.

Append Sructures

Append structures are used for enhancements which are not provided for in the standard (special developments, country versions and adding customer fields to SAP standard tables).

An append structure is assigned to exactly one table. There can however be several append structures to one table. If an append structure is created or changed, the table asssigned to it (appending object) is also activated again at activation and the changes also take effect there.

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

Add new fields

Add foreign keys to fields of the appending object

Add search help attachments to fields of the appending object

Appending an append structure or inserting fields in an existing append structure does not lead to the conversion of the table. The fields of the append structure are appended to the database table.

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.

Note: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.

Please reward points if useful

rgds,

harikrishna

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 09:58:20 GMT

Hello,

An append structure is a structure assigned to just one

table. When a table is activated, all append structures for

the table are found and appended to the table.

Append structures are used to add customer fields to SAP tables

An include Structure is a structure which we include under

another structure which is already defined

ref:

Regards,

Gunjna

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 09:58:49 GMT

For append structure

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

for include structure.

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

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 09:58:56 GMT

U can add Z field to Std table at the end only.

append structure is only for one table.

clk on APPEND STRUCTURE to add a new field

U can create one z structure and then , u can include that in any no-of tables. (reusability)

Reward if useful

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 10:00:01 GMT

append structure: once u append a structure u cannot delete the structure.

u can append a structure only at the end of the feilds.

include structure: u can include a structure anywhere in a feilds,i.e in the middile or at last...

u can even delete a include structure directly where as append structure u must delete the entire table

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 10:00:19 GMT

when u want to include group of fiels at the last of the table we need to go for append

when u want to include group of fiels at the middle of the table we need to go for include

once fields appended u need to delete whole of the table if u want particular fields to be deleted

no need to delete whole of the table

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 10:01:29 GMT

Hey,

Ur best bet would be to add an append structure to MARA and add fields to the append structure.

Append structure and Customizing includes both are tools provided by SAP to add fields to SAP standard tables. The only difference between them is that Append structures can be added to any SAP standard table whereas Customizing includes are predefined by SAP in standard tables or standard structures.

Please refer SAP help for more information.

Cheers

Kiran

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 10:03:10 GMT

good

Enhancement using Append structures

Append structures allow you to attach fields to a table without actually having to modify the table itself. You can use the fields in append structures in ABAP programs just as you would any other field in the table.

Click on the append structure tab and opt to create new

structure.

Append structures allow you to enhance tables by adding fields to them that are not part of the standard. With append structures; customers can add their own fields to any table or structure they want.

Append structures are created for use with a specific table. However, a table can have multiple append structures assigned to it

Customers can add their own fields to any table or structure they want.

The customer creates append structures in the customer namespace. The append structure is thus protected against overwriting during an upgrade. The fields in the append structure should also reside in the customer namespace, that is the field names should begin with ZZ or YY. This prevents name conflicts with fields inserted in the table by SAP

Enh. using Customizing includes

Some of the tables and structures delivered with the R/3 standard contain special include statements. These are often inserted in those standard tables that need to have customer-specific fields added to them. Such includes are Customizing includes. (CI).

A Customizing include is a structure that satisfies a special naming convention. (name begins with CI_).

A Customizing include is a structure that satisfies a special naming convention. The name of a Customizing include begins with ‘CI_’ and the include is in the customer namespace .

If enhancements are already planned in the R/3 standard using customer-specific fields, such Customizing includes are included. in the corresponding standard table or standard structure. The Customizing include (that is the definition of the structure itself) is usually first created in the customer system and filled with fields by special Customizing transactions.

Customers can add their own fields to any table or structure they want.

The Customizing include field names must lie in the customer namespace just like field names in append structures. These names must all begin with either YY or ZZ.

Append structures v/s Customizing includes

In contrast to append structures, Customizing includes can be inserted into more than one table.

As an example the customizing include that we created (CI_DEMO) could be a part of multiple tables in the database whereas the append structure (ZDEMO_APPEND) can only be assigned to one table. (here MARA).

This provides for data consistency throughout the tables and structures affected whenever the include is altered.

Reward i fusefull

thanks

mrutyun^

Re: Data dictinary table

Former Member — Tue, 12 Feb 2008 10:10:15 GMT

Hi,

You can find LIFNR field in MARA as MFRNR u can use this field there is realation btw these two u can check this by...

Go to se11~~> mara~~> then find lifnr u will get this field, double click on this u will get it.....

Include structure can be used in any table and can insert any where in table.

Append structure can de used in that table where it is created only that table can use , other thing if we want to delete the append structure hole table has to be deleted.

Regards,

kavitha..