topic Re: Append Structure Vs Include Structure + Help View in Application Development and Automation Discussions

Append Structure Vs Include Structure + Help View

Former Member — Sat, 17 May 2008 16:45:35 GMT

Hi Experts,

1/ Please tell me the difference between these two way of modifying table.

Which one is useful when ?

2/ What is Help View and how it is different from Other Views(Database,Projection,Maintainance) ?

Regards

Sonal

Re: Append Structure Vs Include Structure + Help View

Sm1tje — Sat, 17 May 2008 17:57:00 GMT

1. Append Structures

Append structures are used for enhancements that are not included in the standard. This includes special developments, country versions and adding customer fields to any tables or structures.

An append structure is a structure that is assigned to exactly one table or structure. There can be more than one append structure for a table or structure.

The following enhancements can be made to a table or structure TAB with an append structure:

· Insert new fields in TAB,

· Define foreign keys for fields of TAB that already exist,

· Attach search helps to fields of TAB that already exist,

These enhancements are part of the append structure, i.e. they must always be changed and transported with the append structure.

Customizing Includes

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

If enhancements are already planned in the 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 thus enhance tables and structures of the standard system without themselves having to modify the table and structure definitions. This means that these enhancements will not be lost when upgrading. If a table or structure of the standard system is enhanced with customer fields using a Customizing include, these customer fields are automatically inserted in the new delivered table or structure definition during an upgrade.

If you create a Customizing include for a table or structure, only those enhancements are allowed that are consistent with the enhancement category of the enhanced table or structure. For more information, see Structure Enhancements.

Customers can but need not create a Customizing include and fill it with fields. If there is no Customizing include, there is no error message when the table or structure including it is activated.

A Customizing include can be contained in several tables or structures, so that they remain consistent when the include is modified.

a.Help Views

You have to create a help view if a view with outer join is needed as selection method of a search help.

b.Database Views

A database view is defined in the ABAP Dictionary as a logical view on one or more tables. A database view is automatically created in the underlying database when it is activated. Data about an application object is often distributed on several database tables. A database view provides an application-specific view on such distributed data.

c. Maintenance view.

A maintenance view is used for maintaining the data in this table manually. You can create a maintenance view for database tables (or views) and via transaction SM30 you can maintain (create, change, delete) the data.

d. Projection Views

Projection views are used to hide fields of a table. This can minimize interfaces; for example when you access the database, you only read and write the field contents actually needed.

A projection view contains exactly one table. You cannot define selection conditions for projection views.

There is no corresponding object in the database for a projection view. Access to a projection view is mapped by the SAP System onto the corresponding access to its base table. It is also possible to access pooled tables or cluster tables with a projection view

Re: Append Structure Vs Include Structure + Help View

uwe_schieferstein — Sat, 17 May 2008 20:12:45 GMT

Hello Sonal

If a standard table needs to be enhanced I usually use both kinds of includes:

1.) Create unique APPEND structure for standard table

2.) Include INCLUDE structure into APPEND structure

Standard table

APPEND structure

INCLUDE structure 1
INCLUDE structure 2

The INCLUDE structure usually group customer fields of similar semantics (e.g. address fields).

Advantage of this approach:

I need to touch the standard table only once when I add the APPEND structure.

Any further changes will happen on custom objects located in custom packages.

Regards

Uwe

Re: Append Structure Vs Include Structure + Help View

Former Member — Mon, 19 May 2008 06:21:05 GMT

Hi,

1. Table performance can be increased in 2 ways.

Append structure.

if you wnat to add fields at the end of a table.It is specific to pne particular table.

Include structure

if you want to add fields in between the existing fields as per the requirement, it is reusable.

2. views

Help View is to provide F1 help. it generally deals with Outer joins. Views are nothing but a predefined select query with specific fields . It can not hold dat aphysically.

reward if helpful

rgds

umakanth

Re: Append Structure Vs Include Structure + Help View

Former Member — Mon, 19 May 2008 06:52:30 GMT

hi,

1. Append Structures

Append structures can only be assigned to a single table.

Append structures are created in the custome rnamespace ( ZZ or YY)

In case of new versions of the standard table during upgrade, the append structures are automatically appended to the new version of the standard table

Append structures can not be used with cluster and pool tables

Append structures are created in transaction SE11. Display the standard table fields and press the Append structure button.

When you press the button, SAP sugests a name for the new append structure. After you has accepted the name,

a screen will be shown where you can enter the new fields.

Remember to activate.

2. Customizing Includes

Some of the SAP standard tables contains special include statements called Customizing includes. In contrast to Append structures,

Note that customizing includes are created by SAP, but the customer supply the fields for the include.

Customizing includes begin with CI_ and is part of the customer namespace

One Customizing include can be inserted into more than one table.

You can find Customizing includes in SE11 under structures.

Try to take a look at table RKPF which uses the Customizing include CI_COBL (In an IDES system). Next try to add a field to CI_COBL, and activate it. If you go back to table RKPF you will se that your new field has been added.

The followings are different types of views:

- Database View (SE11)

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

- *Help View * ( SE54)

Help views are used to output additional information when the online help system is called.

When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.

- *Projection View *

Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.

A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.

- *Maintenance View * ( SE54 )

Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.

HELP VIEW in detail

You have to create a help view if a view with outer join is needed as selection method of a search help.

The selection method of a search help is either a table or a view. If you have to select data from several tables for the search help, you should generally use a database view as selection method. However, a database view always implements an inner join. If you need a view with outer join for the data selection, you have to use a help view as selection method.

All the tables included in a help view must be linked with foreign keys. Only foreign keys that have certain attributes can be used here . The first table to be inserted in the help view is called the primary table of the help view. The tables added to this primary table with foreign keys are called secondary tables.

A help view implements an outer join, i.e. all the contents of the primary table of the help view are always displayed. You therefore should not formulate a selection condition for fields in one of the secondary tables of the help view. If records of these secondary tables cannot be read as a result of this selection condition, the contents of the corresponding fields of the secondary table are displayed with initial value.

To create help view pls go through the following link , it may be helpful.

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ecd2446011d189700000e8322d00/frameset.htm

reward points if helpful,

Thanks & regards,

Madhavi.M

Edited by: Madhavi vallepu on May 19, 2008 9:00 AM