topic Re: JOIN in Application Development and Automation Discussions

JOIN

Former Member — Thu, 08 Mar 2007 06:48:57 GMT

Hi all,

i need to do join between

mkpf and mseg instead of select,

any help will be appreciated.

dana.

my code is:

SELECT MBLNR BLDAT FROM MKPF

into CORRESPONDING FIELDS OF TABLE ITAB_mkpf

WHERE BLDAT >= date. "itab_ekko-bedat.

SELECT MBLNR MJAHR ZEILE BWART MATNR menge LGORT SHKZG EBELN

KOSTL FROM MSEG

into CORRESPONDING FIELDS OF TABLE ITAB_mseg

for all entries in itab_mkpf

WHERE MBLNR = itab_mkpf-mblnr

and ( ( bwart = '351' or bwart = '352'

and ebeln > ebeln )

or ( bwart = '201' or bwart = '202' ) )

and kostl = p_kostl

and lgort = itab_ekko-UNSEZ.

Re: JOIN

Former Member — Thu, 08 Mar 2007 06:59:13 GMT

my answer is:

SELECT a~MBLNR

a~BLDAT

b~MBLNR

b~MJAHR

b~ZEILE

b~BWART

b~MATNR

b~menge

b~LGORT

b~SHKZG

b~EBELN

b~KOSTL

FROM MKPF as a

inner join mseg as b

on a_{mblnr = b}mblnr

into CORRESPONDING FIELDS OF TABLE ITAB_mkpf_mseg

WHERE a~BLDAT >= date "itab_ekko-bedat.

and ( ( b_{bwart = '351' or b}bwart = '352'

and b_{ebeln > b}ebeln )

or ( b_{bwart = '201' or b}bwart = '202' ) )

and b~kostl = p_kostl

and b~lgort = itab_ekko-UNSEZ.

Please let me know for anymmore queries

Re: JOIN

Former Member — Thu, 08 Mar 2007 07:00:55 GMT

SELECT MK_{MBLNR MK}BLDAT MS_{MJAHR MS}ZEILE MS_{BWART MS}MATNR MS_{menge MS}LGORT MS_{SHKZG MS}EBELN MS_{KOSTL FROM MKPF AS MK INNER JOIN MSEG AS KS WHERE MK}MBLNR = MS~MBLNR

and ( ( MS_{bwart = '351' or MS}bwart = '352' )

or ( MS_{bwart = '201' or MS}bwart = '202' ) )

and MS~kostl = p_kostl

and MS~lgort = itab_ekko-UNSEZ.

BTW, i did not under stand the condition:

and ebeln > ebeln in your second select statement.

~thomas

null

Re: JOIN

Former Member — Thu, 08 Mar 2007 07:06:47 GMT

Hi,

You can try ur code in the following way:

Select A_{MBLNR A}BLDAT B_{MJAHR B}ZEILE B_{BWART B}MATNR B_{menge B}LGORT B_{SHKZG B}EBELN B_{KOSTL FROM MKPF as A inner join MSEG as B on A}MBLNR = B~MBLNR into table itab

where ( ( B_{bwart = '351' or B}bwart = '352' )

and B~EBELN > ebeln )

or ( ( B_{BWART = '201' or B}BWART = '202' )

and B~KOSTL = p_kostl )

and B~LGORT = itab_ekko-UNSEZ.

Reward useful answers...

Re: JOIN

Former Member — Thu, 08 Mar 2007 07:07:49 GMT

hi dana,

select mkpf_{blnr mkpf}bldat mseg_{MJAHR mseg}ZEILE mseg_{BWART mseg}MATNR mseg_{menge mseg}LGORT mseg_{SHKZG mseg}EBELN

mseg~KOSTL into table itab from mkpf inner join mseg

on mkpf_{blnr = mseg}blnr

WHERE BLDAT >= date

MBLNR = itab_mkpf-mblnr

and ( ( bwart = '351' or bwart = '352'

and ebeln > ebeln )

or ( bwart = '201' or bwart = '202' ) )

and kostl = p_kostl

and lgort = itab_ekko-UNSEZ.

regards,

keerthi

Re: JOIN

Former Member — Thu, 08 Mar 2007 07:37:09 GMT

thank you very much,

you help me alot.