Show TOC

Master Data Types: Attributes, Texts, and HierarchiesLocate this document in the navigation structure

Use

There are three different types of master data in BW:

1. Attributes

Attributes are InfoObjects that are logically subordinate to a characteristic. You cannot select attributes in the query.

Example

You assign the attributes Person responsible for the cost center and Telephone number of the person responsible for the cost center (characteristics as attributes), as well as Size of the cost center in square meters (key figure as attribute) to a Cost Center.

2. Texts

You can create text descriptions for master data or load text descriptions for master data into BW. Texts are stored in a text table.

Example

In the text table, the Name of the person responsible for the cost center is assigned to the master data Person responsible for the cost center.

3. Hierarchies

A hierarchy serves as a context and structure for a characteristic according to individual sort criteria. For more detailed information, see Hierarchies.

Features

Time-dependent attributes:

If the characteristic has at least one time-dependent attribute, a time interval is specified for this attribute. As master data must exist between the period of 01.01.1000 and 12.31.1000 in the database, the gaps are filled automatically (see Maintaining Time-Dependent Master Data ).

Time-dependent texts:

If you create time-dependent texts, the system always displays the text for the key date in the query.

Time-dependent texts and attributes:

If texts and attributes are time-dependent, the time intervals do not have to agree.

Language-dependent texts:

In Creating InfoObjects: Characteristics, you specify whether texts are language-dependent (for example, with product names: German - Auto, English - car) or are not language-dependent (for example, customer names). The system only displays texts in the selected language.

If texts are language-dependent, you have to load all texts with a language indicator.

Only texts exist:

You can also create texts only for a characteristic, without maintaining attributes. When you load texts, the system automatically generates the entries in the SID table.