topic Select Statement problem in Application Development and Automation Discussions

Select Statement problem

Former Member — Fri, 20 Nov 2009 09:55:45 GMT

Dear gurus

I have written a select statement which is stated below . when i execute my report without entering the data in LGORT field. it fetches the data from table MSEG and displays the result only for the data of the first line in table it does not get the data of the other LGORT having same MBLNR.

SELECT * 
 INTO CORRESPONDING FIELDS OF TABLE itab2
  FROM mseg
  INNER JOIN mkpf ON mseg~mblnr = mkpf~mblnr
  INNER JOIN makt ON mseg~matnr = makt~matnr
  INNER JOIN mara ON mseg~matnr = mara~matnr
  WHERE mseg~matnr IN matnr AND werks IN bwkey[]
  AND budat IN budat[] AND matkl IN matkl[] AND mtart IN mtart[]
  AND bwtar IN  bwtar[] AND lgort IN lgort[]. "<------- Problem here"

please help

regards

Saad Nisar

Re: Select Statement problem

kesavadas_thekkillath — Fri, 20 Nov 2009 10:13:25 GMT

How did you fll the range tables

Use view WB2_V_MKPF_MSEG2 instead on join with mkpf and mseg

Re: Select Statement problem

deepak_dhamat — Fri, 20 Nov 2009 10:39:07 GMT

HI,

SELECT *

INTO CORRESPONDING FIELDS OF TABLE itab2

FROM mseg

INNER JOIN mkpf ON mseg_{mblnr = mkpf}mblnr

INNER JOIN makt ON mseg_{matnr = makt}matnr

INNER JOIN mara ON mseg_{matnr = mara}matnr

WHERE mseg~matnr IN matnr AND werks IN bwkey[]

AND budat IN budat[] AND matkl IN matkl[] AND mtart IN mtart[]

AND bwtar IN bwtar[] AND lgort IN lgort[]. "<-------

select-options : so_MATNR for MARA-MATNR,

so_WERKS for MARA-WERKS,

so_BUDAT for MSEG-BUDAT,

so_MATKL for MSEG-MATKL,

SO_BWTAR FOR MSEG-BWTAR,

SO_LGORT FOR MSEG-LGORT.

SELECT *

INTO CORRESPONDING FIELDS OF TABLE itab2

FROM mseg

INNER JOIN mkpf ON mseg_{mblnr = mkpf}mblnr

INNER JOIN makt ON mseg_{matnr = makt}matnr

INNER JOIN mara ON mseg_{matnr = mara}matnr

WHERE mseg~matnr IN SO_matnr

AND werks IN SO_WERKS

AND budat IN SO_budat

AND matkl IN SO_matkl

AND mtart IN SO_mtart

AND bwtar IN SO_bwtar

AND lgort IN SO_lgort .

Try this but listen

Your query will be slow as you are using mseg and mkpf

and multiple join

Regards

Deepak .