topic Re: Problem with select statement in Application Development and Automation Discussions

Problem with select statement

Former Member — Wed, 23 Dec 2020 13:49:18 GMT

DATA : lv_matnr TYPE matnr,
lv_extwg TYPE extwg.

DATA: BEGIN OF TKOMP OCCURS 10.
INCLUDE STRUCTURE KOMP.
DATA: END OF TKOMP.
"DATA: tkomp TYPE komp.

SELECT SINGLE matnr extwg FROM mara INTO (lv_matnr,lv_extwg)
WHERE matnr = lv_matnr.
IF sy-subrc EQ 0.
tkomp-extwg = lv_extwg.
ENDIF.
WRITE 😕 lv_extwg.

My problem is while execute this statement the output is empty. May i know why?

Please guide me to get a value for lv_extwg... by using mara and komp table.

Re: Problem with select statement

abo — Wed, 23 Dec 2020 14:23:05 GMT

You're reading MARA with key matnr = lv_matnr and at the same time writing the result for MATNR into lv_matnr.

Somehow I don't think this is what you want... also, what is the value of lv_matnr to begin with?

Re: Problem with select statement

Former Member — Wed, 23 Dec 2020 14:33:55 GMT

We will fill TKOMP-EXTWG with the value from MARA?

TKOMP-EXTWG = MARA-EXTWG ?

need to fill the structure tkomp.

Re: Problem with select statement

SimoneMilesi — Wed, 23 Dec 2020 14:48:49 GMT

naveena_10 check your code as Andrea suggested: put a break point on the select and check how you read MARA table...

If this is the full code, you are reading with empty LV_MATNR: whatelse do you expect?

Re: Problem with select statement

Former Member — Wed, 23 Dec 2020 15:01:44 GMT

how to modify this code to get lv_extwg value..?

Re: Problem with select statement

BhargavaTanguturi — Thu, 24 Dec 2020 07:13:17 GMT

SELECT SINGLE extwg FROM mara INTO lv_extwg

WHERE matnr = lv_matnr.

Re: Problem with select statement

matt — Thu, 24 Dec 2020 14:41:48 GMT

You can use the same variable in the WHERE as in the INTO. I've done it many times.

My guess is that data isn't there, or the lv_matnr is in external format and needs to go through that ALPHA conversion exit.

Re: Problem with select statement

abo — Thu, 24 Dec 2020 14:44:24 GMT

It is a tiny bit more confusing, I know it works.

I agree on your hunch.