Get Material Type in SRM

[Former Member]

Hi Gurus,

How to get the material type in SRM? If we enter the material in the product field in the shopping cart, based upon the material type some validation needs to be done in the shopping cart.

Please advise if anybody is having any clue.

Thanks & Regards,

Aswini

[masa_139]

Hi,

How about implementing the DOC_CHECK_BADI ?

Regards,

Masa

[Former Member]

Hi Masa,

Thanks for your suggestion!

We are already using the BADI to create a PR out of shopping cart and in that BADI we have to do the validation based upon the material type. Say, we have selected the product id in the cart and then based upon the material type related to this product id, we will do some validation in the BADI.

Please let me know if any table/field in SRM which stores the material type so that we can refer that field and then will do the validation accordingly.

Thanks & Regards,

Aswini

[masa_139]

DDIC: COMM_PRODUCT-PRODUCT_TYPE

[Former Member]

Hi Masa,

Thanks for the info!

Will test it and let you know if the solution is working fine!

Regards,

Aswini

[Former Member]

Hi,

Now I got to know how to get the material type in SRM. Would like to share the information.

Material along with the material type get replicated into SRM from R/3 system. In COMMPR01 transaction, we can search for the material by entering the number in the product id and then it will show the detail information. When the material is replicated into srm, it will be tagged to both the hierachies R3MATCLASS as well as R3PRODSTYPE. The category id corresponding to the hierachy R3PRODSTYPE will have the format MAT_XXXX where XXXX denotes the material type. e.g. MAT_ESRA where ESRA denotes the material type in R/3. The characters after MAT_ will vary.

The below step is followed to get the material type in SRM:

1. Get the product GUID of the material (product) used int he shopping cart from the BBP_PD transaction. Or the product GUID can be obtained from table COMM_PRODUCT.

2. Get the Hierarchy GUID of R3PRODSTYPE from COMM_HIERACHY.

3. Get the CATEGORY_ID from the table COMM_PRPRDCATR based upon product GUID and HIERARCHY GUID of R3PRODSTYPE.

It will give the result in MAT_XXXX format. The remaining characters after MAT_ represents the material type.

Hope this information will be useful.

Regards,

Aswini

Edited by: Aswini Kumar Sahoo on Sep 18, 2009 5:29 PM

Edited by: Aswini Kumar Sahoo on Sep 18, 2009 5:30 PM