2007 Jul 30 12:58 PM
Hi,
Iam getting the error at the bold letters.
First error is it is asking KNA1 is Unknown.
Second error is it is asking "KUNNR LAND1 NAME1 ORT01 TELF1" is not expected.
TYPES:
BEGIN OF TY_KNA1,
KUNNR TYPE KNA1-KUNNR,
LAND1 TYPE KNA1-LAND1,
NAME1 TYPE KNA1-NAME1,
ORT01 TYPE KNA1-ORT01,
TELF1 TYPE KNA1-TELF1,
END OF TY_KNA1.
DATA:
ST_KNA1 TYPE TY_KNA1.
&----
*& Module USER_COMMAND_9001 INPUT
&----
text
----
MODULE USER_COMMAND_9001 INPUT.
CASE SY-UCOMM.
WHEN 'EXIT'.
LEAVE PROGRAM.
WHEN 'INSERT'.
<b>MOVE-CORRESPONDING ST_KNA1 TO KNA1.</b>
INSERT KNA1.
IF SY-SUBRC EQ 0.
MESSAGE S000(0) WITH 'CUSTOMER RECORD INSERTED'.
ELSE.
MESSAGE E000(0) WITH 'CUSTOMER RECORD NOT INSERTED'.
ENDIF.
CLEAR ST_KNA1.
WHEN 'DISPLAY'.
<b>SELECT SINGLE * KUNNR LAND1 NAME1 ORT01 TELF1 FROM KNA1 INTO ST_KNA1
WHERE KUNNR EQ ST_KNA1-KUNNR.
IF SY-SUBRC NE 0.</b>MESSAGE I000(0) WITH ' INVALID CUSTOMER NUMBER'.
ENDIF.
ENDCASE.
ENDMODULE. " USER_COMMAND_9001 INPUT
2007 Jul 30 1:02 PM
hi,
or u can even change code to
<b>remove *</b>
SELECT SINGLE KUNNR LAND1 NAME1 ORT01 TELF1 FROM KNA1 INTO ST_KNA1
WHERE KUNNR EQ ST_KNA1-KUNNR.
regards,
Navneeth K.
Hi,
Iam getting the error at the bold letters.
First error is it is asking KNA1 is Unknown.
Second error is it is asking "KUNNR LAND1 NAME1 ORT01 TELF1" is not expected.
TYPES:
BEGIN OF TY_KNA1,
KUNNR TYPE KNA1-KUNNR,
LAND1 TYPE KNA1-LAND1,
NAME1 TYPE KNA1-NAME1,
ORT01 TYPE KNA1-ORT01,
TELF1 TYPE KNA1-TELF1,
END OF TY_KNA1.
DATA:
ST_KNA1 TYPE TY_KNA1.
&----
*& Module USER_COMMAND_9001 INPUT
&----
text
----
MODULE USER_COMMAND_9001 INPUT.
CASE SY-UCOMM.
WHEN 'EXIT'.
LEAVE PROGRAM.
WHEN 'INSERT'.
<b>MOVE-CORRESPONDING ST_KNA1 TO KNA1.</b>
INSERT KNA1.
IF SY-SUBRC EQ 0.
MESSAGE S000(0) WITH 'CUSTOMER RECORD INSERTED'.
ELSE.
MESSAGE E000(0) WITH 'CUSTOMER RECORD NOT INSERTED'.
ENDIF.
CLEAR ST_KNA1.
WHEN 'DISPLAY'.
<b>SELECT SINGLE * KUNNR LAND1 NAME1 ORT01 TELF1 FROM KNA1 INTO ST_KNA1
WHERE KUNNR EQ ST_KNA1-KUNNR.
IF SY-SUBRC NE 0.</b>MESSAGE I000(0) WITH ' INVALID CUSTOMER NUMBER'.
ENDIF.
ENDCASE.
ENDMODULE. " USER_COMMAND_9001 INPUT
2007 Jul 30 1:00 PM
Hi,
You need to declare the KNA1 table in the TOP Include
TABLES: KNA1.
Regards
Sudheer
2007 Jul 30 1:00 PM
2007 Jul 30 1:01 PM
hi,
change ur code as follows:
SELECT SINGLE * FROM KNA1 INTO corresponding fields of ST_KNA1
WHERE KUNNR EQ ST_KNA1-KUNNR.
regards,
Navneeth K.
2007 Jul 30 1:02 PM
if you are using select single *, u should not specify the field names.
Reward for helpful answers.
-Satish
2007 Jul 30 1:02 PM
Tables:KNA1.
Define the above part of the code Globally. That is, define it in the original program.
Regards,
Pavan
2007 Jul 30 1:02 PM
hi,
or u can even change code to
<b>remove *</b>
SELECT SINGLE KUNNR LAND1 NAME1 ORT01 TELF1 FROM KNA1 INTO ST_KNA1
WHERE KUNNR EQ ST_KNA1-KUNNR.
regards,
Navneeth K.
2007 Jul 30 1:03 PM
MOVE-CORRESPONDING ST_KNA1 TO KNA1.
st_knal 6 fields
but kna1 mor than 6. error show.
2007 Jul 30 1:03 PM
Hi,
I want to only these fields to retrieve or add.
KUNNR LAND1 NAME1 ORT01 TELF1
ram
2007 Jul 30 1:04 PM
change select statement as
SELECT SINGLE KUNNR LAND1 NAME1 ORT01 TELF1 FROM KNA1 INTO ST_KNA1
WHERE KUNNR EQ ST_KNA1-KUNNR.
regards,
Navneeth K.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |