Duplicates in Material Classification Value

[Former Member]

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

[bastinvinoth]

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

[Former Member]

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

[bastinvinoth]

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

[Former Member]

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.

[former_member420878]

Check TCODE CT04,

[Former Member]

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

Regard's

Smruti