topic Insert coding error in Application Development and Automation Discussions

Insert coding error

Former Member — Thu, 19 Jul 2007 09:22:47 GMT

hi ,

anybody tell why error this coming.

''Comma without preceding colon (after INSERT ?)''.

INSERT INTO KNA1(KUNNR,ANRED,NAME1,PFACH,STRAS,PSTLZ,ORT01,

TELF1,TELFX) VALUES(

CUSTOMER_T-KUNNR,

CUSTOMER_T-ANRED,

CUSTOMER_T-NAME1,

CUSTOMER_T-PFACH,

CUSTOMER_T-STRAS,

CUSTOMER_T-PSTLZ,

CUSTOMER_T-ORT01,

CUSTOMER_T-TELF1,

CUSTOMER_T-TELFX.

ENDIF.

Re: Insert coding error

Former Member — Thu, 19 Jul 2007 09:29:28 GMT

Hi,

INSERT INTO KNA1 ( KUNNR,ANRED,NAME1,PFACH,STRAS,PSTLZ,ORT01,

TELF1,TELFX ) VALUES(

CUSTOMER_T-KUNNR,

CUSTOMER_T-ANRED,

CUSTOMER_T-NAME1,

CUSTOMER_T-PFACH,

CUSTOMER_T-STRAS,

CUSTOMER_T-PSTLZ,

CUSTOMER_T-ORT01,

CUSTOMER_T-TELF1,

CUSTOMER_T-TELFX ). -

> you miss <b>)</b> .

ENDIF.

Now it will work.

Thanks,

Re: Insert coding error

Former Member — Thu, 19 Jul 2007 09:29:51 GMT

why don't you try to put your values in a structure and then insert it into kna1?

Something like this:

INSERT INTO KNA1 VALUES wa_kna1.

Hope this helps

Re: Insert coding error

Former Member — Thu, 19 Jul 2007 09:30:54 GMT

Hi,

as I know, it's not possible to insert a few fields. You need to go over an internal table like this:

DATA: itab TYPE HASHED TABLE OF KNA1

WITH UNIQUE KEY carrid connid,

wa LIKE LINE OF itab.

wa-carrid = 'UA'. wa-connid = '0011'. wa-cityfrom = ...

INSERT wa INTO TABLE itab.

wa-carrid = 'LH'. wa-connid = '1245'. wa-cityfrom = ...

INSERT wa INTO TABLE itab.

wa-carrid = 'AA'. wa-connid = '4574'. wa-cityfrom = ...

INSERT wa INTO TABLE itab.

...

INSERT KNA1 FROM TABLE itab

Regards

Nicole

Re: Insert coding error

Former Member — Thu, 19 Jul 2007 09:34:55 GMT

hi,

when ur inserting values into internal table ot databse table from a work area which is not given in your query.

INSERT INTO KNA1(KUNNR,ANRED,NAME1,PFACH,STRAS,PSTLZ,ORT01,

TELF1,TELFX) VALUES(

CUSTOMER_T-KUNNR,

CUSTOMER_T-ANRED,

CUSTOMER_T-NAME1,

CUSTOMER_T-PFACH,

CUSTOMER_T-STRAS,

CUSTOMER_T-PSTLZ,

CUSTOMER_T-ORT01,

CUSTOMER_T-TELF1,

CUSTOMER_T-TELFX).

ENDIF.

OR INSERT INTO <INTERNAL TABLE> FROM <WORKAREA>.

IF HELPFUL REWARD SOME POINTS.

with regards,

Suresh.A