topic Re: simple qa in Application Development and Automation Discussions

simple qa

Former Member — Mon, 16 Jan 2006 10:53:42 GMT

i get err why

select matnr kdmat

into (knmt-matnr , knmt-kdmat )

from knmt.

Re: simple qa

Former Member — Mon, 16 Jan 2006 10:56:35 GMT


select matnr kdmat
into (knmt-matnr, knmt-kdmat )
from knmt.

no space before , ) !

Working example:

TABLES: knmt.

SELECT matnr kdmat

INTO (knmt-matnr, knmt-kdmat)

FROM knmt.

ENDSELECT.

Message was edited by: Rene Guenther

Re: simple qa

hymavathi_oruganti — Mon, 16 Jan 2006 10:58:23 GMT

U HAVE TO USE SINGLE

select SINGLE matnr kdmat

into (knmt-matnr , knmt-kdmat )

from knmt.

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:02:02 GMT

declare tables KNMT.

then as your are not passing any values in WHERE CLAUSE,

select up to 1 rows will be more efficient than select single

so use this.

SELECT MATNR

KDMAT

INTO ( KNMT-MATNR,

KNMT-KDMAT )

UP TO 1 ROWS

FROM KNMT.

ENDSELECT.

Regards

srikanth

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:05:48 GMT

single,endselect-- dost work

iget--"statment no accessible

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:07:55 GMT

this is the include

&----

& Include Zzzzzzzzzz

&----

data : begin of itab2 occurs 0,

matnr like knmt-matnr,

kdmat like knmt-kdmat,

maktx like makt-maktx,

matkl like mara-matkl,

bismt like mara-bismt,

end of itab2.

select single matnr kdmat

into (knmt-matnr , knmt-kdmat )

from knmt.

if sy-subrc = 0.

itab2-matnr = knmt-matnr.

itab2-kdmat = knmt-kdmat.

endif.

endselect.

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:10:29 GMT

tables KNMT.

SELECT MATNR

KDMAT

INTO (KNMT-MATNR,

KNMT-KDMAT)

UP TO 1 ROWS

FROM KNMT.

ENDSELECT.

when i execute my code sample, i am getting matnr values ??

what is the problem then ??

check this code ??

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:11:46 GMT

if you use SELECT-SINGLE, NO need of any ENDSELECT

remove it.

Re: simple qa

hymavathi_oruganti — Mon, 16 Jan 2006 11:12:58 GMT

select matnr kdmat

into (knmt-matnr , knmt-kdmat )

from knmt.

in the above statement u r using,

please clarify, have u declared an internal table with name knmt in the program.

check that once.

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:14:16 GMT

Include tables statement

tables : knmt.

and

select single matnr kdmat
into (knmt-matnr , knmt-kdmat )
from knmt.

if sy-subrc = 0.
itab2-matnr = knmt-matnr.
itab2-kdmat = knmt-kdmat.
endif.

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:15:34 GMT

in your code, i observed unrequired assignment of values ??

for example :knmt-matnr , knmt-kdmat these 2 variables not required to use.

use directly itab2 variables. and in if condition use append .

modified code :

clear itab2.

select single matnr kdmat

into (itab2-matnr , itab2-kdmat )

from knmt.

if sy-subrc = 0.

append itab2. "here we reduced 2 assignments from 2 temp variables to ITAB2 RECORD.

endif.

ONE MORE OBSERVATION :

YOU have NOT USED APPEND ITAB2. so the values coming from KNMT table will not appear in ITAB2 table.

GOT IT ???

added one more observation in the code sample

Message was edited by: Srikanth Kidambi Maruthi

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:20:46 GMT

i dont think it's the select i pass the include.

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:24:32 GMT

pl let me know,whats your exact problem ???

Re: simple qa

Former Member — Mon, 16 Jan 2006 11:40:36 GMT

just curious...

you guys can activate the code with spaces before comma and ending bracket?

into (itab2-matnr , itab2-kdmat )

I would except, that only

into (itab2-matnr, itab2-kdmat)

is the correct syntax.

Re: simple qa

abdul_hakim — Mon, 16 Jan 2006 12:04:25 GMT

Hi Liat,

add TABLES KNMT before using your SELECT statement.

You cannot have SELECT SINGLE and ENDSELECT combination,since you are not looping in this case.

Please refer to OPEN SQL libarary in http://help.sap.com

Regards,

Abdul