topic Re: inner join problem in Application Development and Automation Discussions

inner join problem

Former Member — Tue, 10 Apr 2007 05:55:00 GMT

hi everyone

1) I have to make a INNERJOIN on "MKPF AND MSEG" table to select the fields from both tables into one "INTERNAL TABLE" but there is no relationship exist between these two tables

plz help how i can do it

Thanks

with regards

surity for points

Re: inner join problem

Former Member — Tue, 10 Apr 2007 05:57:22 GMT

hi gaurav,

if there is no relation then it is not possible to use inner joins.There should be some relation in between the two tables.

Regards...

Arun.

Re: inner join problem

Former Member — Tue, 10 Apr 2007 05:58:48 GMT

Hi,

material Document no and year are the link between these tables. MBLNR and MJAHR.

Regards,

Re: inner join problem

Former Member — Tue, 10 Apr 2007 05:59:29 GMT

Hi,

Select a_{mblnr a}mjahr b_{zeile b}bwart b_{ebeln b}ebelp b~erfmg

into table ITAB

from mkpf as a join MSEG as b on

a_{mblnr = b}mblnr and

a_{mjahr = b}mjahr

where a~mjahr = p_year

b~ebeln in S_ebeln..

reward points if useful

regards,

Anji

Re: inner join problem

Former Member — Tue, 10 Apr 2007 06:00:51 GMT

Hi,

In both tables MBLNR was common field.U can use this field in inner join to get relationship between these two tables.

pls give reward if it helpful

Thanks

vana

Re: inner join problem

Former Member — Tue, 10 Apr 2007 06:00:51 GMT

Hi,

MKPF is the header table for material documents, whereas MSEG is the item table for material documents. You can very well join these two tables.

Please check the key fields in the MKPF table, MBLNR and MJAHR.

These two fields are also the key fields in MSEG table apart from the third field ZEILE(Item number).

Therefore, you can make a join based on the key fields of the MKPF table.

Thank you.

reward all useful answers.

Re: inner join problem

former_member632991 — Tue, 10 Apr 2007 06:02:00 GMT

Hi,

there is relation between these 2 tables

select based on the material doc no i.e. MBLNR

select a_{a1 b}b1 from mseg as a inner join mkpf as b

on a_{mblnr = b}mblnr.

Regards,

Sonika

Re: inner join problem

Former Member — Tue, 10 Apr 2007 06:02:20 GMT

Hi gaurav,

There are field like MBLNR, MJAHR which are common in both the tables.

Even if some of the field names are not same, if there data element or domain is same u can put inner join condition.

Thanks

Sandeep

Award point if benefited

Re: inner join problem

Former Member — Tue, 10 Apr 2007 06:05:31 GMT

only mblnr field is sufficient for the innerjoin

Re: inner join problem

Former Member — Tue, 10 Apr 2007 06:10:49 GMT

gaurav,

Query:

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

conditions....

PLs. reward if useful..

Re: inner join problem

Former Member — Tue, 10 Apr 2007 06:11:15 GMT

use select query like this

select mkpf_----

mseg----

into table itab from mkpf inner join mseg on mkpf_{mblnr = mseg}mblnr where -

Re: inner join problem

Former Member — Tue, 10 Apr 2007 06:47:02 GMT

thanks to everybody for your help but i got struck in another problem related to "where condition"

1) i have to select mblnr , mjahr and budat from MKPF into itab (internal table) for user input in the selection screen

+++(Inner join)

select zeile,bwart,matnr,werks,lgort,charg,sobkz,erfmg,erfme,kzbew,kzvbr,kzzug,shkzg from MSEG into itab(internal table) for user input in the selection screen

2) now i got confused in "For user input in the selection screen " because at selection screen i have only following fields

matnr , werks , lgort,charg,lifnr,kunnr,bwart,sobkz,usnam,vgart.

and i am using a query like this

select a-mblnr

a-mjahr

a-budat

b-zeile

b-bwart

b-matnr

b-werks

b-lgort

b-charg

b-sobkz

b-erfmg

b-erfme

b-kzbew

b-kzvbr

b-kzzug

b-shkzg into table t_mat_data from mkpf

as a join mseg as b on a-mblnr = b-mblnr

and a-mjahr = b-mjahr

where .....................

so wat should i written in Where condition plz reply

thanks

points will be awarded

Re: inner join problem

former_member632991 — Tue, 10 Apr 2007 06:52:32 GMT

Hi,

In the where condition

write

where a~matnr in s_matnr(if it is selection screen option)

and in the same way other fileds from select options

Go through the SAP help on select query fot better understanding

Regards,

Sonika