topic Re: Inner Join Problem in Application Development and Automation Discussions

Inner Join Problem

Former Member — Thu, 27 Sep 2007 02:39:42 GMT

Hi,

I am having some problem with my inner join, trying to link two tables MSEG and MKPF.

The problem is that I don't know what to link the Tables with,

please help me.

DATA:

t_Sloc TYPE MSEG-LGORT,

t_MvT TYPE MSEG-BWART,

t_MatD TYPE MKPF-MBLNR,

t_Item TYPE MSEG-ZEILE,

t_Post TYPE MKPF-BUDAT,

t_Q TYPE MSEG-MENGE,

t_Bun TYPE MSEG-MEINS,

TotalQ TYPE i.

START-OF-SELECTION.

SELECT MSEG_{LGORT MSEG}BWART MSEG_{ZEILE MSEG}MENGE MSEG~MEINS

FROM MSEG

INNER JOIN MKPF ON MSEG_{BWART = MKPF}BUDAT

INTO (t_Sloc, t_MvT, t_Item, t_Q, t_Bun)

WHERE MSEG~MATNR = INPUT.

Re: Inner Join Problem

Former Member — Thu, 27 Sep 2007 02:52:41 GMT

Hi John,

See this below:

select s_{mblnr s}mjahr s_{bwart s}matnr s_{werks s}menge

appending corresponding fields of table t_mseg

from mseg as s inner join mkpf as k

on s_{mblnr = k}mblnr and

s_{mjahr = k}mjahr

where s~matnr in s_matnr

and s~werks in s_werks_full

and ( s_{bwart eq lit_101 or s}bwart eq lit_102 )

and k~budat between s_budat-low and s_budat-high

and s~bukrs = p_bukrs.

or u can also use view WB2_V_MKPF_MSEG2 .

Sri

Re: Inner Join Problem

Former Member — Thu, 27 Sep 2007 03:32:29 GMT

good

you can use tha MBLNR as the key field to join both the table,bcz this is the key field which i present in both the table.

thanks

mrutyun^

Re: Inner Join Problem

Former Member — Thu, 27 Sep 2007 03:42:15 GMT

Thank you so much I can now join MSEG and MKPF you made my day/night

But Sri,

what does this do in you answer:

and s~werks in s_werks_full

and ( s_{bwart eq lit_101 or s}bwart eq lit_102 )

and k~budat between s_budat-low and s_budat-high

and s~bukrs = p_bukrs.

Re: Inner Join Problem

Former Member — Thu, 27 Sep 2007 05:47:27 GMT

hi john,

It is better change ur code as following .. it works

TYPES: BEGIN OF ty_itab,

lgort TYPE lgort_d,

bwart TYPE bwart,

mblnr TYPE mblnr,

zeile TYPE mblpo,

budat TYPE budat,

menge TYPE menge_d,

meins TYPE meins,

totalq TYPE i,

END OF ty_itab.

DATA: wa_itab TYPE ty_itab,

it_itab TYPE STANDARD TABLE OF ty_itab.

START-OF-SELECTION.

SELECT mseg_{lgort mseg}bwart mseg_{zeile mseg}menge mseg~meins

FROM mseg

INNER JOIN mkpf ON mseg_{bwart = mkpf}budat

INTO CORRESPONDING FIELDS OF TABLE IT_ITAB.

WHERE mseg~matnr = input.

rewards if useful

regards

sree