Extraction of Material Classification Data from R/3 to BW

Extraction of Material Classification Data from R/3 to BW

Via Content in SCN

This document would help to extract Material Classification data for the newly added classification characteristics from R/3 to BW system.

First I would explain what is classification, class, objects and characteristics.

Classification:

R/3 supports many ways for those customising it to store additional data fields. For example, many tables support customer defined

additions, but there is also the Cross Application Classification System. The Classification System allows R/3 to hold many varied

additional fields against many different sorts of R/3 "object", for example it might allow you to store a colour against a material. Here

is some terminology:

 
Object - a predefined business entity such as vendor, material, equipment or customer.

Class -  a grouping of Characteristics. To view class definition use t-code: CL03
Characteristics - a property of the object, this is the new field being added. For example a new characteristic might be the color of the material.
Characteristic Value - the actual value of the characteristic, for example a material can be colored blue.

Steps to be followed in SAP ECC side

1)  Goto TCode SBIW->Settings for Application-Specific DataSources->Cross-Application Components->Maintain DataSources for Classification Data

    

2)      In this below screen select DS: 0MATERIAL_ATTR, Class Type: 001(Material Class)
           
          

           

In the above screen shot we can see for each data source generated its corresponding Classification Data Source name starting with 1CL_0MAT***(for MATERIAL_ATTR) gets activated.

3)  Then double click on characteristics on left side. Here we need to maintain the characteristics that we require in BW from the material master.
        Manually enter the characteristics in the screen popping out
  
         

In the above screen shot "N" value indicates datasource has been created
              

4) Then Click on Generate Data Source         

     R/3 side Configuration is now complete, test the extractor using RSA3.

Steps in BW side

Replicate the datasource in BW using t-code: RSDS.