Linking four Tables

[Former Member]

HI!

How can I get the data from all these four tables..The table names and fields are as follows :

MARA -Matnr

MARA-Attyp

MALG-Matnr

MALG-Lmod

EINA-Matnr

EINA-Lnfnr

EINA-Anum

EINE-Lnfnr

EINE-Org

The selection criteria is Lnfnr. Anybody can help me? Thank in advance....

Regards,

Nathan

[Former Member]

HI!

How can I get the data from all these four tables..The table names and fields are as follows :

MARA -Matnr

MARA-Attyp

MALG-Matnr

MALG-Lmod

EINA-Matnr

EINA-Lnfnr

EINA-Anum

EINE-Lnfnr

EINE-Org

The selection criteria is Lnfnr. Anybody can help me? Thank in advance....

Regards,

Nathan

[Former Member]

Hi,

SELECT A_{MATNR A}ATTYP B_{LMOD C}LNFNR C~ANUM into corresponding fields of itab

from ( MARA as A join MALG as B on A_{MATNR = B}MATNR ) join EINA as C on ( B_{MATNR = C}MATNR ) where C~LNFNR in S_LNFNR.

LOOP AT ITAB.

SELECT ORG into ITAB-ORG from eine where lnfnr = itab-lnfnr.

Modify itab index sy-tabix.

endloop.

Regards,

Himanshu

[Former Member]

Hi,

Check this sample code

ELECT-OPTIONS:

s_matnr FOR mara-matnr,

s_werks FOR ekpo-werks,

s_lifnr FOR ekko-lifnr OBLIGATORY,

s_ekorg FOR ekko-ekorg OBLIGATORY,

s_ekgrp FOR ekko-ekgrp OBLIGATORY,

s_bedat FOR ekko-bedat OBLIGATORY,

s_ebeeln FOR ekko-ebeln ,

s_ebelp FOR ekpo-ebelp .

*----

---

>START OF SELECTION

START-OF-SELECTION.

SELECT ekko_{ebeln ekpo}ebelp ekpo_{matnr makt}maktx ekpo~werks

ekpo_{menge ekpo}netpr ekko~lifnr

INTO CORRESPONDING FIELDS OF TABLE t_itab

FROM ( ekko INNER JOIN ekpo ON ekko_{ebeln = ekpo}ebeln ) INNER

JOIN makt ON makt_{matnr = ekpo}matnr WHERE

ekpo~matnr IN s_matnr AND

ekpo~werks IN s_werks AND

ekko~lifnr IN s_lifnr AND

ekko~ekorg IN s_ekorg AND

ekko~ekgrp IN s_ekgrp AND

ekko~bedat IN s_bedat AND

ekko~ebeln IN s_ebeeln AND

ekpo~ebelp IN s_ebelp .

"selects the output data from ekko,ekpo and makt tables and stores in

"t_itab

"

Use Inner join for the four tables....

Reward if useful

[Former Member]

Hi

Select

MARA~Matnr

MARA~Attyp

MALG~Lmod

EINA~Lnfnr

EINA~Anum

EINE~Org

into table ITAB

from mara join malb on mara_{matnr = malb}matnr

join eina on mara_{matnr = eina}matnr and mara_{matkl =eina}matkl

join eine on eina_{infnr = eine}infnr

where ....

Reward points if useful

Regards

Anji

[Former Member]

hi

MARA, MALG, EINA - linked by matnr

EINA and EINE - linked by inforecord no.

if helpful, reward

Sathish. R

[Former Member]

Hi,

SELECT p_{Lnfnr p}Org f_{Matnr f}Anum

INTO TABLE itab_eine_eina

FROM EINE AS p INNER JOIN EINA AS f

ON p_{Lnfnr = f}Lnfnr

WHERE <f~Lnfnr Selection Criteria>.

SELECT p_{Matnr p}Attyp f~Lmod

INTO TABLE itab_mara_malg

FROM MARA AS p INNER JOIN MALG AS f

ON p_{Matrn = f}Matnr

FOR ALL ENTRIES IN itab_eine_eina

WHERE f~Matnr = itab_eine_eina-Matnr.

itab_eine_eina, itab_mara_malg should be defined and should have the fields in SELECT stm. in Order.

Regards,

Ranjit Thakur.

<b>Please Mark The Helpful Answer.</b>

[Former Member]

Hi,

Try this:

select
MARA~Matnr
MARA~Attyp
MALG~Matnr
MALG~Lmod
EINA~Matnr
EINA~Lnfnr
EINA~Anum
EINE~Lnfnr
EINE~Org
INTO TABLE ITAB
From mara 
INNER JOIN malg  on MARA~matnr = MALG~matnr
INNER JOIN EINA ON MARA-MATNR = EINA-MATNR
INNER JOIN EINE ON EINE~LNFNR = EINA~LNFNR
WHERE <CONDITIONS>.

Jogdand M B