topic Re: SELECT in Application Development and Automation Discussions

SELECT

Former Member — Fri, 07 Sep 2007 12:00:51 GMT

HI Guys

iam using following part of query,

SELECT

mseg~BWART

from mseg

inner join

mkpf on mkpf_{mblnr EQ mseg}mblnr

into table itab

where mkpf~budat in zdate and

mseg~werks in zpl.

mseg~werks in zpl is not working, it gives invalid data. its not giving the range of values, returns all values.

how to solve , pls give me any suggestion.

Regards

Rajaram

Re: SELECT

seshatalpasai_madala — Fri, 07 Sep 2007 12:03:39 GMT

Hi,

Check if <b>zpl</b> is having any values.

Regards,

Sesh

Re: SELECT

Former Member — Fri, 07 Sep 2007 12:04:09 GMT

hi,

r u using parameters or select-option?

Re: SELECT

JozsefSzikszai — Fri, 07 Sep 2007 12:05:13 GMT

hi Raja,

first you have to check during runtime (in debug), if zpl contains the right data.

Re: SELECT

Former Member — Fri, 07 Sep 2007 12:07:03 GMT

HI,

SELECT

mseg~BWART

into table itab

from mseg

inner join

mkpf ON mkpf_{mblnr EQ mseg}mblnr

where mkpf~budat IN zdate AND

mseg~werks in zpl.

The above code should not give any error.

Regards,

Rama Murthy.P

Re: SELECT

varma_narayana — Fri, 07 Sep 2007 12:08:12 GMT

Hi..

How did u declare ZPL..

Give the code to identify..

regards..

Re: SELECT

Former Member — Fri, 07 Sep 2007 12:09:22 GMT

Parameter.

Re: SELECT

RaymondGiuseppi — Fri, 07 Sep 2007 12:17:04 GMT

I got no problem with your syntax, i defined select-options:

  SELECT-OPTIONS zdate FOR mkpf-budat.
  SELECT-OPTIONS zpl FOR mseg-werks.

Could you give more lines of your code

Regards

Re: SELECT

Former Member — Fri, 07 Sep 2007 12:17:17 GMT

hi raja,

plz send ur code of declaration of both parameters which u r comparing.

then i hope i can help u.

thanks

seema

Re: SELECT

Former Member — Fri, 07 Sep 2007 12:22:58 GMT

am using select-option

Re: SELECT

Former Member — Fri, 07 Sep 2007 12:24:12 GMT

SELECT-OPTIONS: zpl FOR mseg-WERKS OBLIGATORY.

SELECT mseg~mblnr

mkpf~budat

mseg~kdauf

mseg~kdpos

mseg~matnr

mseg~werks

mseg~erfmg

mseg~erfme

mseg~BWART

from mseg

inner join

mkpf on mkpf_{mblnr EQ mseg}mblnr

into table itab

where mkpf~budat in zdate and

mseg~werks in zpl and

mseg~kdauf ne ' ' and

( mseg~BWART = '601' or

mseg~bwart = '602').

Re: SELECT

Former Member — Fri, 07 Sep 2007 12:24:48 GMT

ok so send me ur code.

Re: SELECT

Former Member — Fri, 07 Sep 2007 12:39:27 GMT

hi,

I wrote this code and its giving right output.

TABLES : mseg,mkpf.

DATA : BEGIN OF itab OCCURS 0,

mblnr LIKE mseg-belnr,

budat LIKE mkpf-budat,

matnr LIKE mseg-matnr,

werks LIKE mseg-werks,

END OF itab.

SELECT-OPTIONS: zpl FOR mseg-werks OBLIGATORY,

zdate FOR mkpf-budat.

SELECT mseg_{mblnr mkpf}budat mseg_{matnr mseg}werks

FROM mseg INNER JOIN mkpf

ON mkpf_{mblnr EQ mseg}mblnr

INTO TABLE itab

WHERE mkpf~budat IN zdate AND

mseg~werks IN zpl.

LOOP AT itab.

WRITE:/ itab-mblnr.

ENDLOOP.

Re: SELECT

RaymondGiuseppi — Fri, 07 Sep 2007 12:44:17 GMT

Look at your actual code with space between constants and bracket, maybe there is a bracket or OR/AND operator in the wrong place ?

Regards

Re: SELECT

Former Member — Fri, 07 Sep 2007 13:12:01 GMT

hi raja,

dhwani has given u correct code. i check also on my system it is giving correct result. but when u r keeping date select option blank.

then it could nt find any value equal to empty date. thats the reason. it could nt read any value in ur case. as much i understand ur probs.

(n try to check really space in ur code also).

n come back if u still could nt solve ur prob.

thanks.

seema

Re: SELECT

Former Member — Fri, 07 Sep 2007 14:20:35 GMT

The first response was the correct one:

CHECK NOT zpl[] IS INITIAL.

SELECT mseg~bwart
  FROM mseg
  INNER JOIN mkpf ON
    mkpf~mblnr EQ mseg~mblnr
  INTO TABLE itab
  WHERE mkpf~budat IN zdate
    AND mseg~werks IN zpl.

Rob