Changes in table

[Former Member]

Hi Experts,

I have a Table Maintaince Generator with total 9 Fields(Mandt,Matkl,Wbgez,Zcode_purcatlab,pu_cat_label,Code_domain,dom,code_hierarchy,refer_hierarchy).In those 9 fields, first 2 fields r Primary fields.

I want to update the hierarchy of material groups for 2010 but when I fill in the new entries I get an error message u201CAn entry already exists with the same keyu201D.

There is already a PC Hierarchy 2009 with the same purchasing categories. Objective of this transaction is to be able to maintain different hiearchies, but in two different hierarchies we can have the same purchasing categories. System should check if an entry (material group) already exists for the Code Ref Hier.

I should be able to load these new codes, this is really important to solve the issue ASAP.

Regards

Ganesh

[Former Member]

Hi Ganesh,

Has this table maintenance generated using multiples or single.

Thanks and Regards,

Ranjith Nambiar

[Sm1tje]

Well, then you table definition is not correct. You need another key field (probably a field for holding the year).

[Former Member]

Hi Ganesh,

Please check table primary key, I think you have to add year in the primary key.

Thanks & Regards,

Naresh

[Former Member]

Hi Ganesh ,

As per my analysis , table in client dependent and is having MATKL as key field.

You need

1. to check MATKL , is existing in table or not , when this error is thrown.

2. Debug and check the exact place from where this error is coming . There are chances that you have, some logic is written in

PAI or save event , which throws this message, based on some condition.

3. You can add year as the key field , only when you are sure that it will work fine and is must.

Hope this helps you.

Edited by: Harsh Bhalla on Jan 6, 2010 9:46 PM