Question Re: Material Classification - how to extract? in Technology Q&A

Material Classification - how to extract?

Former Member — Fri, 06 Jul 2007 18:48:21 GMT

Hi Experts,

I have requirement where I need to do extract data from "Classification View" in MM03 transaction.

I think we need to use Material Classification datasources for that.

But I have no idea how to use this datasource - I think thats not deliverd - we need to config this.

Can you please explain how to extract classification data - What all steps do we need to do - any precautions?

Documents/links/steps would be appreciated and encouraged by points

Thanks in advance

Gaurav

Message was edited by:

Gaurav

Re: Material Classification - how to extract?

Former Member — Fri, 06 Jul 2007 19:47:04 GMT

Gauray,

I have to solve a similar requirement once...

Classification is maintained through a series of tables in R/3. The associations between them are kept in Table AUSP (Characteristic Values).

AUSP-KLART (Class Type) = 001 - Materials

AUSP-OBJEK (Key of Object to be Classified) is the Key Value

AUSP-ATWRT (Characteristic Value) Is the value associated with the Object

So, for example, in AUSP,

KLART = 001 (Materials)

OBJEK = 000021 (Material Number)

ATWRT = MECH (Characteristic Value)

To get a better description of the Classification Category, we associated the Class with the appropiate entry in text table CABNT (Characteristic Descriptions). Here field CABNT-ATUE1 (First Line of Heading) provides a better description.

So, basically, we enhanced the 0MATERIAL extractor and added field ZMATCLASS and populated it with the select:

SELECT ATUE1

FROM CABNT

INTO ZMATCLASS

WHERE CABNT-ATINN EQ AUSP-ATINN (Same Internal Characteristic)

AND AUSP-KLART EQ '001' (It's a Material)

AND AUSP-OBJECK EQ "XXXX" (Current Material Number)

This is not the actual code, of course, and maybe I'm missing some minor detail. Just using my memory here... But I least you get the idea... I hope.

Hope it helps.

Regards,

Luis

Re: Material Classification - how to extract?

Former Member — Fri, 06 Jul 2007 20:13:47 GMT

Hi Luis,

Thanks a lot for detailed info.

I thought there were standard extractors available (e.g something like 1CL_OMAT...) with which we can extract the classification data..

I am not sure where I can find the data which I need to extract and I though somehow with these extractors you can extract them instead of custom solution.

Any idea??

Gaurav

Re: Material Classification - how to extract?

Former Member — Fri, 06 Jul 2007 20:33:16 GMT

This one time I had to do it, we didn't have anything standard at hand... That's why we did the custom solution I mentioned before... And it worked perfect!

I'm not familiar with any standard solution (Datasources, etc) for this.

The best way for you to find out is to ask and understand with the Config guys how do they handle the Classifications in R/3 for your Company. Then you'll have a much better idea about what way to go...

Regards,

Luis

Re: Material Classification - how to extract?

Former Member — Fri, 06 Jul 2007 20:41:10 GMT

You need to generate Clasification DS in SAP R/3 Side...

take a look at the Below threads...

Nagesh Ganisetti.

Assign points if it helps.

Re: Material Classification - how to extract?

Former Member — Fri, 06 Jul 2007 20:47:29 GMT

Tcoce: CTBW

Procedure:

1. Enter a basis data source that you want to extend.

2. Select the client, class type, and object table from which you want

to copy classification data.

3. Select the data source to which you want to assign characteristics,

then choose Characteristics.

4. Choose New entries and enter the characteristics you want to assign.

5. If you want to define a sequence for the characteristics, enter position numbers.

4. Statuses are assigned automatically: N = New: this status appears before a new data source has been created.

R = Ready: the status is converted to this status after generation. If you change a characteristic, reset the status to N before generation.

Choose Data source to generate the data source. This also generates the characteristic data sources for characteristics of data type CHAR.

An internal key starting with "1CL_..." is assigned as a data sourcename.

Nagesh Ganisetti.

Assign points if it helps.

Re: Material Classification - how to extract?

Former Member — Fri, 06 Jul 2007 21:36:07 GMT

Thanks again Nagesh,

Few questions:

I need to extend Material so is it that I have to work with "1CL_OMAT001" , Cannot I generate new datsource??

When I clicked characteristics on "1CL_OMAT001" in CTBW - I got 3 characteristics and for 2 chars datasources are like 1CL_AMC_012...What is this for?

So it means only 2 chars are being extracted to BW?

Also for KF, there is no datasource assigned...?

Any idea why thats so?..I m totally lost in this...!!

Thanks

Gaurav

Message was edited by:

Gaurav

Re: Material Classification - how to extract?

Former Member — Mon, 09 Jul 2007 13:55:54 GMT

Help Please!!!

I have no clue how to proceed with this..trying Nagesh's response - but still confused with that questions mentioned above..

Comments from Nagesh reply:

1. Enter a basis data source that you want to extend. - How do I know which datasource I need to extend - all I know is I need to particulat field from material classification - 1CL_OMAT001 is in use - So i need to use this?

2. Select the client, class type, and object table from which you want to copy classification data.- I am not sure abt this? From where can I get this data

3. Select the data source to which you want to assign characteristics,then choose Characteristics. Which datasource?

What is difference between - Basis datasource and Characteristics datasource?

It might be very basic - but I am not getting it!!

Message was edited by:

Gaurav

Message was edited by:

Gaurav

Re: Material Classification - how to extract?

Former Member — Mon, 09 Jul 2007 14:38:06 GMT

Send me your Email_id ... I will send you some documents.

Re: Material Classification - how to extract?

Former Member — Mon, 09 Jul 2007 14:42:59 GMT

Hi Abhishek,

My mail ID is : saurabh_668@yahoo.com

Thanks in advance

Re: Material Classification - how to extract?

Former Member — Mon, 09 Jul 2007 16:59:02 GMT

Gaurav,

1. Provide 0MATERIAL_ATTR Datasource.

2.. Classification Data attched to material contains Class Type and Object table. Which is Client Dependant Settings. Class type you can check with Functional Folks. Object table use F4.

2. Assume your Material Classfication has 30 fields. You need to one field value to BW. you can generate for that perticular Field.

3. Every Clasiffication Data has CHARECTERSTIC and VALUE combination in SAP R/3 Side. Once you define above detials (Step no 2) ... select your DS and go with Charecterstics... there you need to provide Charecterstic for which you want to generate.

Feel free to ask me if you have any Questions. Check with functional folks how Variant Configuration works... which helps you to get good understanding of what is happening in Material Classification view.

I will try to send you an email on Concept of Variant Configuration if i get a chance.

Hope this helps.

Nagesh Ganisetti.

Assign points if it helps.

Re: Material Classification - how to extract?

Former Member — Mon, 09 Jul 2007 17:31:54 GMT

Thanks again Nagesh,

I am planning to do following: let me know if I am wrong somewhere:

1) CTBW->HIghlight 0MATERIAL_ATTR (Basis DS) -> Characteristics -> NEw entries-> from F4 get char which I need to fetch to BW->Save/generate....

I have following question :

Whats the use of characteristics DS?

I think I would ONLY be using 1CL_OMAT001 and not characteristic DS..1CL_AMC_001..?

Thanks in advance

Gaurav

Re: Material Classification - how to extract?

Former Member — Mon, 09 Jul 2007 18:57:48 GMT

Hi Gourav,

I sent you some more information on understanding classification data extraction ... hope you find this useful.

Re: Material Classification - how to extract?

Former Member — Mon, 09 Jul 2007 20:00:07 GMT

Don't worry about that...?

Use your 1CL_OMAT001 which you generated. I can't generate in my current client... as we don't have any Variant Config setup.

I guessing, 1CL_AMC_001 could be used for master data for Charecterstics. In my earlier project, i used only 1CL_OMAT001.

Hope this Helps.

Nagesh Ganisetti.

assign points if it helps.

Re: Material Classification - how to extract?

Former Member — Mon, 09 Jul 2007 20:04:25 GMT

Thanks Nagesh and AB for all help.