Application Development and Automation 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: 
Read only

INSERT AGAIN ERROR

Former Member
0 Likes
925

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
Read only

Former Member
0 Likes
900

you have to declate customer_t like kna1.

it will work!!!

Bye!

Read only

Former Member
0 Likes
900

declare like this:

data:CUSTOMER_T like KNA1.

but ONE SHOULD NOT INSERT DATA DIRECTLY INTO STANDARD TABLE

Read only

Former Member
0 Likes
900

t_customer NEEDS to be of type KNA1.

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

Read only

seshatalpasai_madala
Product and Topic Expert
Product and Topic Expert
0 Likes
900

HI

DATA: CUSTOMER_T type KNA1.

INSERT INTO KNA1 FROM CUSTOMER_T.

Regards,

Sesh