inner join problem

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi,

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

Regards,

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[former_member632991]

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

[Former Member]

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

[Former Member]

only mblnr field is sufficient for the innerjoin

[Former Member]

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..

[Former Member]

use select query like this

select mkpf_----

---

mseg----

---

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

---

[Former Member]

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

[former_member632991]

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