SAP BW Characteristics

SAP BW CharacteristicsWelcome to the SAP BW characteristics tutorial. If this is the first time you’re trying to create BW characteristics, then this is the right tutorial for you. The steps involved in the process of creating BW characteristics can be a little confusing, but bear with us. We will explain them in detail. This tutorial is part of our free SAP BW course.

Types of SAP BW Characteristics

SAP BW characteristics are primarily used to describe objects such as divisions, plants, G/L accounts, controlling areas, cost centers, materials, customers, profit centers, etc. They are basically descriptive attributes. InfoObject Catalogs hold characteristics and key figures. It is a good practice to create an InfoObject Catalog to hold all relevant characteristics before creating the characteristics.

Characteristics that comprise text, attributes and sometimes hierarchies are called master data characteristics. Master data needs to be loaded into these characteristics through the ETL (extract/transform/load) process.

There are also SAP BW characteristics available for units of measure and time. Unit of measure characteristics provide a basis for key figure values, currencies and other units of measure (i.e. value unit, currency unit). Time characteristics define time reference of business events. Some of the time characteristics provided by SAP are fiscal year (0FISCYEAR), calendar year (0CALYEAR), calendar quarter (0CALQUARTER), calendar month (0CALMONTH), calendar week (0CALWEEK), calendar day (0CALDAY) and fiscal period (0FISCPER).

In addition, there are technical characteristics which are primarily used for administrative purposes (i.e. change ID & request ID).

For the ease of understanding, this tutorial will focus on creating an InfoObject catalog and creating a customer object characteristic with an attribute of region.

Create InfoObject Catalog

Navigate to the data warehousing workbench via transaction code RSA1. In the left pane under Modeling click on InfoObjects as highlighted in the below screen:

Data Warehousing Workbench: Modeling
Data Warehousing Workbench: Modeling

Now, in the middle pane, create an InfoObject catalog by placing your cursor in the InfoObjects blank space, then right click on BW Tutorial and select Create InfoObject Catalog as highlighted in the below screenshot:

Create InfoObject Catalog
Create InfoObject Catalog

In the edit InfoObject screen, give a name and description to the InfoObject catalog and select the InfoObject type Char. Next, click on the create button as highlighted below:

Creating InfoObject Catalog
Creating InfoObject Catalog

Next, click the check button as highlighted in the below screen to check the validity of the catalog:

Checking InfoObject Catalog
Checking InfoObject Catalog

The catalog looks valid. This can be seen from the status message as shown below:

Results of InfoObject Catalog Check
Results of InfoObject Catalog Check

Then click the activate button as highlighted in the below screen to activate the catalog.

Activating InfoObject Catalog
Activating InfoObject Catalog

The InfoObject catalog is activated successfully as can be seen from the status message of the below screen:

Activated InfoObject Catalog
Activated InfoObject Catalog

Navigate to the previous screen by clicking the green back arrow . We can see the newly created InfoObject catalog in the data warehousing workbench:

Newly Created InfoObject Catalog
Newly Created InfoObject Catalog

Create SAP BW Characteristics

We will now create a characteristic for a customer object. To create a characteristic, start by right clicking on the InfoObject catalog that was just created and select Create InfoObject as shown below:

Create Characteristic
Create Characteristic

On the resulting screen, enter name ZBW_CUST1 and description Customer. Instead of creating the characteristic from scratch, you can create the new characteristic from either a reference characteristic or a Template.

Reference Characteristic: If you want to create a new characteristic with the technical properties similar to those of an already existing characteristic, enter the reference characteristic name in this field.

Template: If you want to create the new characteristic with the same structure properties of an already existing characteristic, enter the template name in this field.

Click the enter button as highlighted in the below screen:

Creating Characteristic
Creating Characteristic

In the resulting screen, on the right pane, enter characteristic details. The following data types and character lengths are available for SAP BW characteristics:

Data Type Length
CHAR Number and Letters Character length can be between 1 to 60
NUMC Numbers only Character length can be between 1 to 60
DATS Date Character length 8
TIMS Time Character length 6

For our example of creating a customer object, select the data type CHAR and enter field length of 10 as indicated below:

Create Characteristic Details
Create Characteristic Details

Then click on the Attribute tab. In the resulting screen, click on the create button as highlighted in the below screen to create a new attribute:

Characteristic Attributes
Characteristic Attributes

Next, we will add Region as an attribute to the Customer characteristic. Enter ZRegion1 as attribute name per the following screen:

Create Attribute
Create Attribute

Enter long and short descriptions as Region, select the data type CHAR and enter field length 30. Also note that Attribute Only tickbox is selected by default. This is to identify that this characteristic is exclusively an attribute:

Create Attribute Details
Create Attribute Details

Now, click on the green check as highlighted below to continue:

Save Attribute Details
Save Attribute Details

Click the check button to check the validity of the characteristic:

Check Characteristic
Check Characteristic

The characteristic looks valid if you see the status message as below:

Results of Characteristic Check
Results of Characteristic Check

We will proceed to activate the characteristic by clicking the activate button as highlighted in the below screen:

Activate Characteristic
Activate Characteristic

The system confirms if you want to activate the dependent InfoObject, which is our customer characteristic. To do so, leave the default tickbox selected. Hit enter to activate both characteristic ZBW_CUST1 and attribute ZREGION1:

Activate Dependent InfoObjects
Activate Dependent InfoObjects

You will see a message that all InfoObjects got activated successfully, similar to the below:

Activated InfoObjects
Activated InfoObjects

InfoObject activation will create all the applicable database tables. After activating ZBW_CUST1, you can see the names of the newly created master data and text tables in the Master data/texts tab. BW uses the /BIC/ prefix for all customer-created BW database objects. Conversely, /BI0/ is used for all business content objects. In our example, the name of the text table is /BIC/TZBW_CUST1 and the name of the master data table is /BIC/PZBW_CUST1 as you can see below:

Master Data/Texts Tab
Master Data/Texts Tab

Repeat the preceding steps to create the following characteristics, with the specified settings:

Technical Name Description Data Type Length Exclusively Attribute? Attribute of
ZMATERIAL Material CHAR 18
ZCOSTCENTER Cost Center CHAR 10
ZPROFIT_CTR Profit Center CHAR 10
ZGL_ACCOUNT G/L Account CHAR 10
ZPLANT Plant CHAR 4
ZBUS_AREA Business area CHAR 4 No ZCOSTCENTER
ZCOMP_CODE Company code CHAR 4 No ZCOSTCENTER
ZRT_LOCATIO Retail location CHAR 4 Yes ZCOSTCENTER
ZDIVISION Division CHAR 2 No ZMATERIAL
ZBBP_PROD Product CHAR 32 Yes ZMATERIAL

If needed, you can compounded your characteristics to other InfoObjects. Compounding is necessary if you need to differentiate the characteristic to make it uniquely identifiable. The one-to-many relationship of cost center to controlling areas are a good use case for compounding. For example, if cost center 7001 represents sales in controlling area 40, and it also represents sales in controlling area 50, use compounding to create a unique characteristic for each. Note that InfoObjects defined as attributes cannot be compounded.

Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP BW tutorials.

Navigation Links

Go to next lesson: SAP BW Hierarchy

Go to previous lesson: SAP BEx Query Designer – How to Create a Simple Query?

Go to overview of the course: SAP BW Training

1 thought on “SAP BW Characteristics”

Leave a Reply

Do you have a question and want it to be answered ASAP? Post it on our FORUM here --> SAP FORUM!

Your email address will not be published. Required fields are marked *