topic Insert Duplicate enteries in the table in Application Development and Automation Discussions

Insert Duplicate enteries in the table

Former Member — Thu, 10 Dec 2009 06:56:08 GMT

Hi gurus,

I want to add duplicate enteries in the table, Iam taking the data from the Selection screen and passing it to the table,

But its not accepting the duplicate enteries, so help me on this matter. my key fields are MATNR and WERKS.

What Statement i have to write for that.

Re: Insert Duplicate enteries in the table

Former Member — Thu, 10 Dec 2009 07:02:11 GMT

Hi Manish,

There is something called Data consistency, whcih ensures that the data is unique & consistent but your requirement seems to be violating these rule.

Why are you trying to add duplicate entry.

MATNR is a key field & it ensures that there wont be any duplicate entries in the table. This is not a feasible requirement.

Regards

Abhii

Edited by: Abhii on Dec 10, 2009 8:02 AM

Re: Insert Duplicate enteries in the table

Former Member — Thu, 10 Dec 2009 07:03:30 GMT

To add duplicate entries try with APPEND

Regards,

Re: Insert Duplicate enteries in the table

patrick1905 — Thu, 10 Dec 2009 07:05:00 GMT

Hi Manish,

there is no way to save a entry that has the same key values as a other's entry primary keys. You have to alter / extend the primary key to do this.

The field you use to extend the primary key should be one that is different to the other entry and is unique in compination with your other key fields.

Primary Keys are unique and can not be used more than one time. Otherwise you data could not be structered efficent by the database engine and you could not select only one row for deleting etc.

Best regards,

Patrick

Re: Insert Duplicate enteries in the table

Former Member — Thu, 10 Dec 2009 07:05:57 GMT

actually I have a FISCAL YEAR field in the table, So when the year change, its entries will remain same and its year will only be change. thats why i want to add duplicate fields in the table

Re: Insert Duplicate enteries in the table

patrick1905 — Thu, 10 Dec 2009 07:07:08 GMT

You should than extend the primary key by that field and it will be possible to add your entries.

Re: Insert Duplicate enteries in the table

Former Member — Thu, 10 Dec 2009 07:09:06 GMT

Hello

What table are you talking about ?

If it Z-table then make field Fiscal Year as KEY FIELD.

Re: Insert Duplicate enteries in the table

Former Member — Thu, 10 Dec 2009 07:10:26 GMT

I am not getting u, plz give some example for it.

Iam using my own Z table

Edited by: Manish Sharma on Dec 10, 2009 8:10 AM

Re: Insert Duplicate enteries in the table

Former Member — Thu, 10 Dec 2009 07:11:27 GMT

if its Ztable then try to give another key field for serial no.

every time for same matnr increase srno by 1 and for another material again strt this counting from 1.

this key field should be your first field...

With regards

Pardeep Sharma

Re: Insert Duplicate enteries in the table

former_member217544 — Thu, 10 Dec 2009 07:17:24 GMT

Hi Manish,

When you are trying to change only a particular field then go for update or modify statement.

update <dbtable>

set <fiscal field> = <vlaue>

where <condition>.

Regards,

Swarna Munukoti

Re: Insert Duplicate enteries in the table

patrick1905 — Thu, 10 Dec 2009 07:18:13 GMT

Hi,

Check "key" in se11 for the field that repesents the year. This will extend your unique primary key by that field and will make it possible to save your entries.

Patrick

Re: Insert Duplicate enteries in the table

Former Member — Thu, 10 Dec 2009 07:20:41 GMT

HI manish,

your can add duplicate entries in your table by removing Key fileds.

keep all fileds as normal fields or non keyfileds. you can do it.

let me know if you still facing the problem.

~linganna

Re: Insert Duplicate enteries in the table

RaymondGiuseppi — Thu, 10 Dec 2009 07:32:47 GMT

If you want to have multiples entries for MATNR+WERKS, one by YEAR, define YEAR as a primary key, primary keys define unique records. (Also use MANDT as the first key)

Regards,

Raymond