topic Re: insert syntax in Application Development and Automation Discussions

insert syntax

Former Member — Thu, 22 Mar 2007 22:15:40 GMT

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".

Re: insert syntax

RichHeilman — Thu, 22 Mar 2007 22:19:27 GMT

Try.....

insert zcitorderout from wa_zcitorderout.

Regards,

Rich Heilman

Re: insert syntax

Former Member — Thu, 22 Mar 2007 22:21:04 GMT

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

Re: insert syntax

Former Member — Thu, 22 Mar 2007 22:23:28 GMT

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

Re: insert syntax

ferry_lianto — Thu, 22 Mar 2007 22:25:26 GMT

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

Re: insert syntax

Former Member — Fri, 23 Mar 2007 03:26:05 GMT

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