Types of characteristics InfoObject tables and its structure

Different Types of Tables

When we activate a characteristic, based on the settings we chose while creating characteristic below tables will generate.


1) Master data table
2) Text table
3) SID Table
4) Attribute tables
5) Hierarchy tables.


Master data table:           M-View

While creating characteristic if we select the option “with master data” in “master data/text” tab, then a master table will be generated for that info object upon activation.

Text Table:                       T Table

A text table is created if we flag the “With text” check box while creating and activating the characteristic info object. We can choose how text should look like from the below properties.

SID Table:                        S Table

The SID table is generated when a characteristic is activated unless it is defined as exclusively attribute (Display attribute only).

Attribute Tables:       


If we have selected the option “With master data” (The check box is checked by default) on the “Master data/Texts” tab page, then we can maintain attributes for the master data bearing characteristic on the Attribute tab page. We can define attributes as Display attributes or navigational attributes and we can make this attributes as time independent or time dependent using the settings available on the Attribute tab page.

If we have Display attributes (Time independent), then we will get P Table.
If we have Display attributes (Time dependent), then we will get Q Table.
If we have Navigational attributes (Time independent), then we will get X Table.
If we have Navigation attributes (Time dependent), then we will get Y Table.

Hierarchies Tables:                 H Table

Hierarchies are used in analysis to describe alternative views of the data. Hierarchies comprise a series of nodes that are joined to one another in a tree structure. Usually, the leaves of a hierarchy are represented by characteristic values.

K Table  If we select “with hierarchies” option, then this table will generate.
J Table   If we select “Intervals Permitted in Hierarchy” option, then this table will generate.
I Table   If we select “Time-Dependent Hierarchy Structure” option, then this table will generate.


Navigational attributes and Hierarchy will be discussed in next topic.

Best SAP training in Kerala

Best SAP training in Kochi

Best SAP training in Ernakulam

SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana