topic Re: Duplicates in Material Classification Value in Application Development and Automation Discussions

Duplicates in Material Classification Value

Former Member — Fri, 07 Jun 2013 11:32:26 GMT

Hi All,

When executed a query on material and classification type, it has retreieved two different value for the combination of material and classification which is not expected. The value should be unique. The product type field in SAP allows only one value. So we need to delete the classification value for the invalid information.

Material Number	Classification Type	Value
140	Product_Type	Test
140	Product_Type	Test 1

Any pointers how we can achieve this functionality through ABAP.

Thanks,

Srini

Re: Duplicates in Material Classification Value

bastinvinoth — Fri, 07 Jun 2013 11:54:29 GMT

Hi durga srinivas

Functional guys maybe entered two values under that class

check in CL03 , type your class name and type , goto values tab and see , there maybe 2 values there,

that's why its fetching two values i think , just check and confirm.

also check configuration profile CU41

Regards,

Bastin.G

Re: Duplicates in Material Classification Value

Former Member — Fri, 07 Jun 2013 12:02:34 GMT

HI Vinoth,

Thanks for your reply...

As said above there might be having lots of materials with duplicates. So is there a way we can achieve this functionality through a BAPI/ Function module ?

Regards,

Srini

Re: Duplicates in Material Classification Value

bastinvinoth — Fri, 07 Jun 2013 13:22:44 GMT

durga srinivas

use this fm : BAPI_OBJCL_GETDETAIL

CLAF_CLASSIFICATION_OF_OBJECTS

Check these below thread for further proceeding with above fm's

durga srinivas wrote:
As said above there might be having lots of materials with duplicates
Regards,
Srini

if values are wrong(duplicate) means how can abapers identify ? BAPI/FM will work but it retrieved duplicate values again

check with your functional guyregarding duplicate values

Regards,

Bastin.G

Re: Duplicates in Material Classification Value

Former Member — Fri, 07 Jun 2013 13:32:59 GMT

Hi Durga,

Use BAPI_OBJCL_GETDETAIL to read the existing Characteristic Values and then use BAPI_OBJCL_CHANGE to update the characteristic Values.

BR,

Ankit.

Re: Duplicates in Material Classification Value

former_member420878 — Fri, 07 Jun 2013 15:40:05 GMT

Check TCODE CT04,

Re: Duplicates in Material Classification Value

Former Member — Sun, 09 Jun 2013 12:14:41 GMT

Can you past your query or code , where you find duplicate value ?

Regard's

Smruti