insert syntax

[Former Member]

data: wa_zcitorderout like zcitorderout.
wa_zcitorderout-vbeln = nast-objky. 
insert zcitorderout from wa_zcitorderout accepting duplicate keys.

The error i am getting is "." expected after "WA_ZCITORDEROUT".

[RichHeilman]

Try.....

insert zcitorderout from wa_zcitorderout. 

Regards,

Rich Heilman

[Former Member]

You cannot use ACCEPTING DUPLICATE KEYS with work area. It has to be with an internal table.

[Former Member]

That is valid only in conjunction with "FROM TABLE ". If you need that any duplicate key records should overwrite existing rows, you can use MODIFY ztable FROM wa. This will add rows if there is no record with the same key exist in the table or change if there exists a record with the same key.

Message was edited by:

Srinivas Adavi

[ferry_lianto]

Hi,

You can NOT use option accepting duplicate keys with wa.

Option accepting duplicate keys only work with table itab NOT wa.

INSERT dbtab FROM TABLE itab. or

INSERT (dbtabname) FROM TABLE itab.

Additions

... CLIENT SPECIFIED

... ACCEPTING DUPLICATE KEYS

Please try to build internal table.

data: begin of itab occurs 0.
           include structure zcitorderout.
data: end of itab.

data: wa_zcitorderout like zcitorderout.


wa_zcitorderout-vbeln = nast-objky. 

itab = wa_zcitorderout.
append itab.

insert zcitorderout from table itab accepting duplicate keys.

Regards,

Ferry Lianto

[Former Member]

for

insert zcitorderout from wa_zcitorderout. you can only use extension

1. ... CLIENT SPECIFIED

2. ... CONNECTION con

if you are using

INSERT dbtab FROM TABLE itab.

you can use these.

1. ... CLIENT SPECIFIED

2. ... ACCEPTING DUPLICATE KEYS

3. ... CONNECTION con

regards

shiba dutta