topic Re: problem in insert statement in Application Development and Automation Discussions

problem in insert statement

Former Member — Fri, 22 Dec 2006 07:06:26 GMT

Hi ,

here is my interal table itab2 with following records.

(fields) estnr code version line no LINE_STATUS SALES_MATNR

1> 1002 c001 1022 1 active sm0706

2> 1002 c001 1024 2 cancelled sm0906

to insert these 2 records with the same estnr

please give me the proper INSERT statment for the tableZESTDETAILS

thanks in adavance.

Re: problem in insert statement

Former Member — Fri, 22 Dec 2006 07:09:43 GMT

use modify statment

MODIFY ZMOULD_MAS FROM TABLE IT_TABLEMLDMAS_UP

Re: problem in insert statement

Former Member — Fri, 22 Dec 2006 07:09:44 GMT

1wst check the primary key of ur ztable if it have only estnr and code than it get problem.

for proper command just click f1 in insert.

Re: problem in insert statement

Former Member — Fri, 22 Dec 2006 07:10:57 GMT

what are the primary keys for table ZESTDETAILS?

when u r doing an insert if the primary key field is only estnr it will not accept the duplicate .

you need to make use of all the keys to make it a unique combination.

if u have it as estnr then it will not take as duplicates ..

try this with accepting duplicate keys ..

INSERT dbtab [CLIENT SPECIFIED] FROM TABLE itab. or INSERT (dbtabname) [CLIENT SPECIFIED] FROM TABLE itab.

Addition: ... ACCEPTING DUPLICATE KEYS

regards,

vijay

Re: problem in insert statement

Former Member — Fri, 22 Dec 2006 07:11:42 GMT

You can insert only when your primary key is a combination including ESTNR and CODE. If you have VERSION also in the primary key combition, you can insert these records.

Regards

Eswar