updating database table - not working

[Former Member]

Hi ,

My database table 1 is having multiple data for a primary key

example :

table 1:

GLOBMATNR -> Primary key

WERKS --> non primary key -- multiple for globmatnr

MBLNR --> non primary key -- multiple for globmatnr

MBLPO--> non primary key --

BUKRS --> non primary key -- multiple for globmatnr

i m using below statement to make entry into the table.. but this insert is not working.. I stead of putting 30 entries its just inserting 1 entry..

Can any one help me in this..?

INSERT table1 FROM TABLE internal_table ACCEPTING DUPLICATE KEYS.

Edited by: neha gupta on Oct 29, 2010 1:25 PM

[Former Member]

Hi,

Hit F1 on ACCEPTING DUPLICATE KEYS. You will identify why it is inserting 1 line only. I hope the table is a custom table. For fields which can have multiple values, make it primary key.

In your example table, GLOBMATNR, WERKS, MBLNR could be primary keys if WERKS is in one company code only. If not add BUKRS also

Hope it helps

Sujay

[Former Member]

Moderator message - Please do not ask or answer basic questions or questions that are easily searchable - thread locked Rob