topic hI in Application Development and Automation Discussions

hI

Former Member — Mon, 30 Jul 2007 11:58:52 GMT

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'.

MOVE-CORRESPONDING ST_KNA1 TO KNA1.

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'.

SELECT SINGLE * KUNNR LAND1 NAME1 ORT01 TELF1 FROM KNA1 INTO ST_KNA1

WHERE KUNNR EQ ST_KNA1-KUNNR.

IF SY-SUBRC NE 0.MESSAGE I000(0) WITH ' INVALID CUSTOMER NUMBER'.

ENDIF.

ENDCASE.

ENDMODULE. " USER_COMMAND_9001 INPUT

Re: hI

Former Member — Mon, 30 Jul 2007 12:00:40 GMT

Hi,

You need to declare the KNA1 table in the TOP Include

TABLES: KNA1.

Regards

Sudheer

Re: hI

Former Member — Mon, 30 Jul 2007 12:00:43 GMT

hi,

U have to declare KNA1 in tables.

Tables:KNA1.

Re: hI

Former Member — Mon, 30 Jul 2007 12:01:10 GMT

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.

Re: hI

Former Member — Mon, 30 Jul 2007 12:02:31 GMT

if you are using select single *, u should not specify the field names.

Reward for helpful answers.

-Satish

Re: hI

Former Member — Mon, 30 Jul 2007 12:02:59 GMT

Tables:KNA1.

Define the above part of the code Globally. That is, define it in the original program.

Regards,

Pavan

Re: hI

Former Member — Mon, 30 Jul 2007 12:02:59 GMT

hi,

or u can even change code to

remove *

SELECT SINGLE KUNNR LAND1 NAME1 ORT01 TELF1 FROM KNA1 INTO ST_KNA1

WHERE KUNNR EQ ST_KNA1-KUNNR.

regards,

Navneeth K.

Re: hI

Former Member — Mon, 30 Jul 2007 12:03:01 GMT

MOVE-CORRESPONDING ST_KNA1 TO KNA1.

st_knal 6 fields

but kna1 mor than 6. error show.

Re: hI

Former Member — Mon, 30 Jul 2007 12:03:22 GMT

Hi,

I want to only these fields to retrieve or add.

KUNNR LAND1 NAME1 ORT01 TELF1

ram

Re: hI

Former Member — Mon, 30 Jul 2007 12:04:53 GMT

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.