Extractor for Material Characteristics - Variants

[Former Member]

Hello Gurus,

There are few characteristics that we have configured in ECC system for Materila. If you go to MM01 or MM03-> BASIC DATA 2 -> Client Specific configuration -> There is an option of creating a Cross-Plant CM. You can create additional characteristics once you click the Configure Variant button. There are values that are assigned to the Characteristic Value Assignment.

I would like to know is there a Standard Extractor, that gets these characteristics.

Thanks in advance

Full points to right answers

[Former Member]

a standard extractor won't be available as "classification" (or variant configuration) is not standard SAP either... however, you can have an extractor created by the system for your specific situation:

check the BI customizing transaction in your ECC system (SBIW)

Data Transfer to the SAP Business Information Warehouse >

Settings for Application-Specific DataSources (PI) >

Cross-Application Components >

Classification System >

Maintain Data Sources for Classification Data

(the path above was different in older versions of R/3 and maybe also for ECC 5.0, I checked our system here which is an ECC 6.0)

[Former Member]

Thanks very much for your reply.

I followed the steps you said.

It has created a main datasource by the name of 1CL_OMAT001

And it has also created the following text datasources with the number of characteristics1CL_AZCO001

1CL_AZDE001, 1CL_AZEX001, 1CL_AZLE001, 1CL_AZLE002, 1CL_AZOF001, 1CL_AZPE001 and

1CL_AZSO001.

When I execute the text datasources, it gets me the text master data.

But when I execute the datasource 1CL_OMAT001, it returns me ZERO records.

Any reason why.

thanks in advance

[Former Member]

can't test it at my current client as they don't use classification

as far as I remember, you have different "classes"... did you fill out the correct one in your InfoPackage?

check the tables in ECC... (INOB, CABN, AUSP if I'm not mistaken)

[Former Member]

Thanks for your reply again.

The following are the parameters:-

Basis Datasource : 0MATERIAL_ATTR

Client: 100

Class Type: 001 (Material Class) It does not allow me to select any other class

Obj Table: MARA

Datasource Type: ATTR

Datasource : 1CL_OMAT001

And then I double click on characteristic, to add my characteristics.

The system generates a TEXT DATASOURCE for individual text characteristics, which when using RSA3 gets the relevant data.

But when I execute the datasource 1CL_OMAT001, it does not retrieve any data.

Just to clarify: The SBIW node says "Maintain Data Sources for Classification Data".

Does it mean, it will extract data from the CLASSIFICATION tab of the MM03.

B'cas I am interested in the "BASIC DATA 2" tab -> Client Specific Config-> Configure Variant (button).

Thanks

[Former Member]

hmmm, I (mistakenly) thought that SAP treated them the same way with regards to BI

again, I can't check it here as the client I currently work for doesn't use classification & variant configuration

sorry, I can't be more helpful