Extraction of Material Classification Data from R/3 to BW
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.
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.
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.