In certain business requirements, there is a need to create a classification in ECC which is essentially an extension for a master data. E.g. For Material we need additional attributes such as Packaging Group or for Business Partner we need additional attributes such as Lead Auditor, Certification Expiry Date etc. These information are stored in separate classification tables such as CABN, CAWN, CAWNT and not in the base master data tables (such as MARA or BUPT00 etc). Each class has an associated class type within which the characteristics are defined. When analysis is required based on these characteristics in BW, we need to generate the corresponding classification datasources in ECC and fetch the same into the BW system.
Procedure to generate classification datasources :
Go to t-code CTBW. You will be able to see a list of existing classification datasources. Click on “New Entries” to add a line item wherein you can fill in details for your datasource. Fill in entries such as Basis Datasource (i.e. datasource for which you are creating an extension via the classification datasource), client, class type, Object Table and datasource.
Now click on enter. The datasource name is auto generated and the same will be populated under Datasource column.
Now, we need to define the fields of the datasource. For this, select the line of the datasource and double click on “characteristics”.
Select the required characteristics via F4 and click on enter. SAP automatically generates classification text datasource (seen under Characteristic Datasource) for each characteristics which can be checked via RSA6.
Note : You can check the classification characteristics data type via CL03 t-code.
Click on Save
Click on generate datasource to complete the generation of the classification datasource.
Thus, you have successfully generated your classification datasource. You can now check the data in RSA3. Once, everything looks good there, replicate the datasource in BW system and continue with the corresponding development up to the target object.
Useful Tables :
The below tables will provide information on classification characteristics. You can enter the characteristics name in field ATINN. Please note that internally the characteristics is associated with a number which is different across landscapes (i.e. the number in ATINN can be different in D,Q,P). Hence you can always enter the characteristics name.
CABN – shows the characteristics property.
CAWN – shows the characteristics value (ATWRT) which each characteristic can hold
CAWNT – shows the text value (ATWTB) associated with each characteristic value.
CTBW – shows the fields defined via CTBW t-code against a generated classification datasource
Useful T-codes :
CL03 – To view the classification characteristics details created.
CTBW – To generate the classification datasource
CL20N or CL30N – To view the characteristics values assigned to a particular master data (e.g. For Material Number : 001 Packaging Group : Large)