How to write code using more than 2 tables

[Former Member]

Hi

I am extracting data for PLANT MAINTAINENCE application, it is in master data. Data contains in 8 tables .and display 12 fields in the report and i have to extract data in BW side.

So i am using function module to extract the data from R/3 to

BW side, I am not using appropriate function module.

Here how to link all the tables. Here we are using EQUNR key,based on this ne we are siplaying the data.

Filed names Table names

EQUNR-euipment no. J_3GSTLKOPF

LTEXT-Catalog text /SAPCEM/KATTEXT

ATWRT-Capacity AUSP

ATINN-Inetnal carecter no AUSP

ANSDT-Purchase order date EQUI

ANSWT-Purchase cost EQUI

EQPCATLIFE-life in years J_3GSTLKOPF

CDIFF-Working hours IMRG

NAME1-Name KNA1

J_3GEINEND -Date of relaese J_3GBELP

J_3GPACHT -Leased EQUZ

If display the LTEXT filed we want use two tables. in /SAPCEM/KATTEXT table take KATNR and if u want KATNR take EQUNR in J_3GSTLKOPF table.

If display CDIFF field's here condition is consider only measuring documents(MDOCM). and we want deletion records also. How should i specify this one.

Please tell me the code.

Thanks

[former_member756887]

oh man

for using more than two table you have to do joining of table

regards

aniruddh singh