Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

INSERT AGAIN ERROR

Former Member
0 Kudos

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.

4 REPLIES 4

Former Member
0 Kudos

you have to declate customer_t like kna1.

it will work!!!

Bye!

Former Member
0 Kudos

declare like this:

data:CUSTOMER_T like KNA1.

but ONE SHOULD NOT INSERT DATA DIRECTLY INTO STANDARD TABLE

Former Member
0 Kudos

t_customer NEEDS to be of type KNA1.

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

0 Kudos

HI

DATA: CUSTOMER_T type KNA1.

INSERT INTO KNA1 FROM CUSTOMER_T.

Regards,

Sesh