How to use Inner Join for these 4 table's

554 Views

Hi Guys,

My Requirement is i have to get the data into the final Internal table whose structure is like this (BWKEY type MBEW-BWKEY,

MATNR type MBEW-MATNR,

MAKTX type MAKT-MAKTX,

BWTTY type MBEW-BWTTY,

BWTAR type MBEW-BWTAR,

MEINS type MARA-MEINS,

BKLAS type MBEW-BKLAS,

VPRSV type MBEW-VPRSV,

STPRS type MBEW-STPRS,

PEINH type MBEW-PEINH,

CRCY(3) type c,

LBKUM type MBEW-LBKUM,

SALK3 type MBEW-SALK3,

LAEPR type MBEW-LAEPR,

J_3ADEFSI type MARC-J_3ADEFSI,

J_4kDEFSC type MARC-J_4kDEFSC,

SCLAS type MARA-/AFS/SCLAS,

EKALR type MBEW-EKALR,

HKMAT type MBEW-HKMAT,

HRKFT type MBEW-HRKFT,

KOSGR type MBEW-KOSGR,

PRCTR type MARC-PRCTR,

MMSTA type MARC-MMSTA,

SOBSK type MARC-SOBSK,

PPRDL type MBEW-PPRDL,

LPLPR type MBEW-LPLPR,

PPRDZ type MBEW-PPRDZ,

ZPLPR type MBEW-ZPLPR)

from 4 table's MBEW , MARA MAKT and MARC.

Can anybody provide the logci for this based on the below requirement

"Go to table MBEW with material number, plant and valuation type; fetch the information laid out in output format. There are some fields which need to come from tables MARC, MARA and MAKT. The common criterion is material number across these tables.

MBEW-MATNR = MARC-MATNR

MBEW-MATNR = MARA-MATNR

MBEW-MATNR = MAKT-MATNR

"???

Thanks,

Gopi.