Google+ SAP Beusiness Warehouse Class System - SAP ABAP

SAP Beusiness Warehouse Class System

To help you grasp the Data Source maintenance for classification data from R/3, here is an overview of the classification system in the R/3 system.A class system has the role of describing any object with the help of characteristics and grouping similar objects in classes, to classify them, so that they can be found easier at a later date. You can find an object by using the classes and the characteristics defined in the classes, which serve as search conditions. This means you can be sure to easily find identical or similar objects from the characteristic view.You can classify any object type with the help of the class system.A prerequisite for this is that the required settings are maintained in Customizing for the class system.

Task of the class system: Describe any object with the help of characteristics and group similar objects in classes.

Purpose of the class system: Optimum usage for searching objects
Creating in several steps:
Defining properties (using characteristics)
Creating classes and assigning characteristics to the classes
Assigning objects to the classes (objects are described by characteristics)
Characteristics have values (valuation)
Searching objects with characteristics as search criteria

The process of building a class system consists of several steps:
Defining the properties:
The properties of an object are based on characteristics. The characteristics are created centrally in the R/3 System.
Creating classes:

The objects to be classified must be stored in classes. These classes must be created in the first step. The characteristics are assigned to the classes. Every class must be assigned to a class type.The class type controls the processing of classes as well as the classification and the object search in these classes. A class type always refers to a certain object type, for example, material. Objects of this type can then be classified in classes for this class type.

Assigning objects:

ŸWhen the classes you want to classify have been created, the objects can be assigned to these classes. The objects are described by the characteristics contained in the class. Assigning the characteristic values is called 'characteristic evaluation'. The data required to use the class system is thus made available. The system can then be used to find objects with very specific properties. The characteristics are used in the search as search criteria. The characteristics are evaluated and the entered values are compared to the values of the classified object.

Maintaining Data Sources for Classification Data

Make the following Customizing steps in maintaining a Data Source for classification data. Without this you cannot transfer attributes and texts for class system objects from the source system R/3 into the Business Information Warehouse.

Use the transaction /NSBIW to call the BW IMG of the R/3 System:

Ÿ -> Business Information Warehouse
Ÿ -> Customer-defined Data Sources
Ÿ -> Cross-application components
Ÿ -> Class system
Ÿ -> Maintain Data Sources for classification data
1. Enter a basic Data Source that you want to enhance. Use exactly that BCT Data Source that selects the attributes for the class system attributes in BCT (for example, 0MATERIAL_ATTR).
2. Choose the client, the class type, (for example, 001 material class) and the object table (for example, MARA) from which the classification data is to be transferred.
3. Select the Data Source that you want to assign, and navigate to "characteristics" with a double - click.
4. Choose "New entries" to enter the characteristics and dimensions that you want to assign. You can take the correct IDs of the characteristics or dimensions from the classification master data. Path:

Ÿ -> SAP Menu
Ÿ -> Logistics ...
Ÿ -> Central functions
Ÿ -> Class system
Ÿ -> Master Data
Ÿ -> Class administration

Enter the class type (for example, 001) and the class (for example, CL126 monitors) and display the relevant characteristics. This is where you will find the relevant characteristic IDs required for creating the Data Source. Please note that you can only transfer characteristics with single values in the Data Source. What is more, you cannot use interval values. You can check the evaluation by double clicking on a characteristic > basic data (in the master data). You are recommended also to only transfer characteristics in the Data Source that do not refer to the master data table. You can check the reference by double clicking on a characteristic > additional data (in the master data). If a characteristic links to a master data table field (for example, in the MARA), its attribute values can be extracted with the basic Data Source (for example 0MATERIAL_ATTR). 

5. You can enter an item number if you want to define a sequence within the characteristics. The status is given automatically.

Ÿ N= New, the status appears when a Data Source is created as new.
Ÿ R = Ready, the status is automatically set to R after generation takes place.
Ÿ If you want to change the characteristic, set the status back to N before generating it.
6. Choose "Data Source" to generate the Data Source. At the same time, the system generates the  text Data Sources for the characteristics of the data type CHAR.
7. The prefix 1CL_... is given to all Data Sources generated in this way.

Creating the Data Source in the BW IMG of the R/3 System

a Data Source of a BCT characteristic is used as a basis (a so called Basis Data Source: for example, 0MATERIAL_ATTR for material classification)
Class type: (for example, 001 material class)
Object table (for example, MARA)
Specification for the Data Source characteristics
Enter the characteristic of a class from the selected class type, which you want to extract as an attribute in the Data Source for the basic characteristic.

Resulting structures of the generated Data Sources:

Data Source attribute:

Basic characteristic
Select characteristics from the selected class (attribute)
Time dependency
Every characteristic with the data type CHAR has a text
Data Source generated with the following structure:

  1. Characteristic value
  2. Date valid from
  3. Date valid from
  4. Language keys
  5. Name of the characteristic value (text)

Only classifying characteristics without multiple evaluation and without intervals can be recorded as attributes in the Data Sources.

Classifying characteristics that link to master data tables cannot be a part of a Data Source for extracting classification data. Attributes like this are extracted with the attribute Data Sources of the BCT.

When you use classifying dimensions, no text Data Sources are created. The DataSources entered under dimensions in Release 2.0B are only dummy entries.

If there is no engineering change management activated in Customizing for the class for which you want to generate the Data Sources, the time dependent fields (DATETO and DATEFROM) are brought into the extract structure and filled with the maximum number of area values. In this case, the time-dependent fields (DATETO and DATEFROM) are not visible in the transfer structure. Ÿ If the engineering change management is activated in Customizing for the class for which you want to generate the Data Source, the time dependent fields (DATETO and DATEFROM) are brought into the transfer structure for the User transparent.

When you create the classification Data Source, please note that you must either only enter characteristics in the Data Source that are time-dependent in BW, or, all the characteristics that you enter are not time-dependent. Avoid a combination of the two, since it could lead to inconsistencies in BW.

Every Data Source for classification data is time dependent.If the engineering change management in the classification for a special characteristic is activated, the Data Source can deliver historic constellations. If the engineering change management is not activated, the time interval is set to the maximum area. The text Data Sources also always deliver time-dependent data.

Transport functions for the generated Data Sources are available as of BW Release 2.1C .As of Release 2.1C, the generated attribute Data Sources will be delta compatible for classification Data Sources.

Related Posts

No comments :

Post a Comment