Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to write code using more than 2 tables

Former Member
0 Kudos

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

1 REPLY 1

former_member756887
Participant
0 Kudos

oh man

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

regards

aniruddh singh