topic Changes in table in Application Development and Automation Discussions

Changes in table

Former Member — Thu, 31 Dec 2009 06:25:49 GMT

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

Re: Changes in table

Former Member — Thu, 31 Dec 2009 10:51:36 GMT

Hi Ganesh,

Has this table maintenance generated using multiples or single.

Thanks and Regards,

Ranjith Nambiar

Re: Changes in table

Sm1tje — Thu, 31 Dec 2009 15:32:48 GMT

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

Re: Changes in table

Former Member — Wed, 06 Jan 2010 11:42:52 GMT

Hi Ganesh,

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

Thanks & Regards,

Naresh

Re: Changes in table

Former Member — Wed, 06 Jan 2010 16:15:34 GMT

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