topic Re: INSERT AGAIN ERROR in Application Development and Automation Discussions

INSERT AGAIN ERROR

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

HI,

I TRY TO INSERT DATA IN DATA BASE TABLE

BELOW ERROR SHOWN ANYBODT HELP ME.

''The work area "CUSTOMER_T" is not long enough . ''.

CODING:

INSERT INTO KNA1 VALUES CUSTOMER_T.

KNA1-KUNNR = CUSTOMER_T-KUNNR,

KNA1-ANRED = CUSTOMER_T-ANRED,

KNA1-NAME1 = CUSTOMER_T-NAME1,

KAN1-PFACH = CUSTOMER_T-PFACH,

KAN1-STRAS = CUSTOMER_T-STRAS,

KAN1-PSTLZ = CUSTOMER_T-PSTLZ,

KAN1-ORT01 = CUSTOMER_T-ORT01,

KAN1-TELF1 = CUSTOMER_T-TELF1,

KAN1-TELFX = CUSTOMER_T-TELFX.

Former Member — Thu, 19 Jul 2007 09:53:16 GMT

you have to declate customer_t like kna1.

it will work!!!

Bye!

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

declare like this:

data:CUSTOMER_T like KNA1.

but ONE SHOULD NOT INSERT DATA DIRECTLY INTO STANDARD TABLE

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

t_customer NEEDS to be of type KNA1.

then your code should look like: insert t_customer into kna1.

seshatalpasai_madala — Thu, 19 Jul 2007 09:58:16 GMT

DATA: CUSTOMER_T type KNA1.

INSERT INTO KNA1 FROM CUSTOMER_T.

Regards,

Sesh