2007 Jul 19 10:51 AM
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.
2007 Jul 19 10:53 AM
2007 Jul 19 10:54 AM
declare like this:
data:CUSTOMER_T like KNA1.
but ONE SHOULD NOT INSERT DATA DIRECTLY INTO STANDARD TABLE
2007 Jul 19 10:55 AM
t_customer NEEDS to be of type KNA1.
then your code should look like: insert t_customer into kna1.
2007 Jul 19 10:58 AM
HI
DATA: CUSTOMER_T type KNA1.
INSERT INTO KNA1 FROM CUSTOMER_T.
Regards,
Sesh