Groups of fields or individual fields can be added to SAP delivered tables using append structures, or customizing includes:
Ø Customizing includes are provided in SAP tables and structures to allow you to add fields to these structures/tables without modifying the tables themselves.
Ø Append structures allow you to add fields to SAP-provided structures and transparent tables that were not provided for in the standard version.
Customizing includes are supplied empty by SAP and are filled in by the customer with the help of special customizing transactions.These includes make it possible to extend (add fields to) tables without modifying the tables themselves and without the risk of additions being overwritten during a Release Upgrade.
Names of customizing includes start with ‘CI_’. If a table does not contain a customizing include, you can still make additions by creating an Append structure. You cannot add your own ‘.INCLUDE CI_’ to an SAP table.
Append structures are intended for additions not provided for in the standard version of SAP tables via customizing includes. They are to be used with SAP transparent tables or structures, not with customer tables.
An Append structure is a structure assigned to exactly one table. However, a single table can have a number of append structures. It is recommended to use only one append structure in a table.
When an append structure is activated, its assigned table is also activated with all of the append structure fields. When a table including an append structure is activated, the append structure fields are found and
added to the table.
Append structures cannot be deleted.
Append structures cannot be used with tables containing fields of data type VARC, LCHR, or LRAW because these data types must be the last field in a table.
Use the Append structures … push-button in the table display screen to add fields to SAP tables.
Fields contained in an Append structure are added to the SAP tables when an upgrade is performed and the appropriate tables are activated.
How many ways you can create Table?
User can create a Database table in two ways. 1.Top-to-bottom approach: In this approach, first fields are defined and later domain and data element are defined. 2.Bottom-to-top approach: In...
Modifying dictionary tables
There are 2 ways to add additional fields to a dictionary table without having to make a modification: 1. Append structures 2. Customizing includes 1. Append structures Append...
Modifying structure of table containing data.
I need to add a new field to the structure of an existing table which contains data.Is there any risk of losing the data if the structure is modified. A1: Use append structure and there is no...