topic Re: need code! in Application Development and Automation Discussions

need code!

Former Member — Wed, 28 Nov 2007 15:58:02 GMT

Dear All,

I have three table mara (matkl), mseg (kostl, lgort, kostl,dmbtr,waers), mkpf (budat) .

I have declared one ITAB in the program. Now I want that all the data of these three tables should come in itab. What will be the select statment.

Please guide me as i want to display all these data through my itab.

Thanks & Regards,

Re: need code!

JozsefSzikszai — Wed, 28 Nov 2007 16:04:48 GMT

hi Abhay,

SELECT mara~matkl
             mseg~kostl
             mseg~lgort
             mseg~dmbtr
             mkpf~waers
             mkpf~budat
             INTO TABLE itab
             FROM mseg AS mseg
             INNER JOIN mara AS mara
             ON mseg~matnr Eq mara~matnr
             INNER JOIN mkpf AS mkpf
             ON mseg~mblnr EQ mkpf~mblnr
             AND mseg~mjahr EQ mkpf~mjahr
             WHERE ...

hope this helps

Re: need code!

balbino_soaresferreirafil — Wed, 28 Nov 2007 17:15:02 GMT

Hi AbhaySingh you can try to do it...

Tables: mara, mseg, mkpf.

DATA: BEGIN OF itab,

matkl LIKE mara-matkl,

kostl LIKE mseg-kostl,

lgort LIKE mseg-lgort,

dmbtr LIKE mseg-dmbtr,

waers LIKE mseg-waers,

budat LIKE mkpf-budat ,

END OF itab.

SELECT mr~matkl

ms~kostl

ms~lgort

ms~dmbtr

ms~waers

mk~budat

CORRESPONDING FIELDS OF TABLE itab

FROM mseg AS ms

INNER JOIN mara AS mr

ON ms_{matnr = mr}matnr

INNER JOIN mkpf AS mk

ON ms_{mblnr = mk}mblnr

AND ms_{mjahr = mk}mjahr.

Regards

Balbino