simple qa

[Former Member]

i get err why

select matnr kdmat

into (knmt-matnr , knmt-kdmat )

from knmt.

[Former Member]

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

[hymavathi_oruganti]

U HAVE TO USE SINGLE

select SINGLE matnr kdmat

into (knmt-matnr , knmt-kdmat )

from knmt.

[Former Member]

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

[Former Member]

single,endselect-- dost work

iget--"statment no accessible

[Former Member]

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.

[Former Member]

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 ??

[Former Member]

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

remove it.

[hymavathi_oruganti]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[abdul_hakim]

Hi Liat,

add <b>TABLES KNMT</b> before using your SELECT statement.

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

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

Regards,

Abdul