problem in insert statement

[Former Member]

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.

[Former Member]

use modify statment

MODIFY ZMOULD_MAS FROM TABLE IT_TABLEMLDMAS_UP

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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