topic sample coding for multiple table join in Application Development and Automation Discussions

sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:20:48 GMT

Hi,

i need a sample coding for multiple table join. can anyone help me out.

regards

Gokul

Re: sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:24:12 GMT

What results r u after?????????????????????????????????????????????

ARE WE MIND READERS.

Re: sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:31:08 GMT

See demo programs:

DEMO_SELECT_INNER_JOIN

and DEMO_SELECT_LEFT_OUTER_JOIN

Re: sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:32:45 GMT

Hi,

check this.

SELECT F_{CARRID F}CONNID F~FLDATE

INTO (CARRID, CONNID, DATE)

FROM SFLIGHT AS F INNER JOIN SPFLI AS P

ON F_{CARRID = P}CARRID AND

F_{CONNID = P}CONNID

WHERE P~CITYFROM = 'FRANKFURT'

AND P~CITYTO = 'NEW YORK'

AND F~FLDATE BETWEEN '20010910' AND '20010920'

AND F_{SEATSOCC < F}SEATSMAX.

WRITE: / DATE, CARRID, CONNID.

ENDSELECT.

check this link

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_InnerJoinStatement.asp

Regards,

Sruthi

Re: sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:33:20 GMT

hi gokul,,

I am getting output for your program ,

check the tables if they have data in them ,

i am getting lots of records with your program

Re: sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:33:37 GMT

Hi,

See the sample code:

select

a~aufnr " Order Number

a~kappl " Application

a~zschl " Overhead Key

b~knumh " Cond.Record Number

c~kbetr " Overhead Rate

into table it_head

from aufk as a join a014 as b

on a_{kappl = b}kappl and

a_{zschl = b}zschl

join konp as c

on b_{knumh = c}knumh

for all entries in it_header

where a~aufnr = it_header-aufnr and

b~kappl = 'KA' and

b~kschl = 'C110' and

b~kokrs = 'GSI1' and

b~aufza = '1' .

Regards,

Anji

Re: sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:33:59 GMT

Hi Gokul,

FIrst of all please be sure if you want to read all the data from the table, as there is no where condition in the select statements.

The use of MODIFY ITAB FROM WA in the last loop statement has no use at all.

Please remove unwanted code from the existing code and try to run the code. If you have huge data in the database then your program will run on and on....

Regards,

George

Re: sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:36:23 GMT

SELECT A_{VBELN A}FKDAT A_{VTWEG A}SPART A_{WAERK A}KURRF A_{KUNAG A}KNUMV

B_{POSNR B}FKIMG B_{NETWR B}MATNR

D_{BEGRU E}LABOR E~MATKL

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM VBRK AS A INNER JOIN VBRP AS B

ON A_{VBELN EQ B}VBELN

INNER JOIN J_1IEXCHDR AS C

ON A_{VBELN EQ C}RDOC

INNER JOIN KNVV AS D

ON D_{KUNNR EQ A}KUNAG AND

D_{VKORG EQ A}VKORG AND

D_{SPART EQ A}SPART AND

D~BEGRU NE SPACE

INNER JOIN MARA AS E

ON E_{MATNR EQ B}MATNR

WHERE A~FKDAT IN S_FKDAT AND

A~FKART EQ 'F2' AND

A~VTWEG IN S_VTWEG AND

A~SPART IN S_SPART AND

A~KUNAG IN S_KUNAG AND

A~FKSTO NE 'X' AND

B~WERKS IN S_WERKS AND

C~TRNTYP = 'DLFC' AND

E~LABOR IN S_LABOR AND

C~SRGRP IN ('01','02','03','31','32','33','41','42','43',
'81','82','83','95','55','45', '48') AND

B~MATNR IN S_MATNR AND

D~BEGRU IN S_BEGRU AND

E~MATKL IN S_MATKL.

but my suggestion not to use more than 2 table in inner join it will affect in performance use for all entries instead of join.

regards

shiba dutta

Re: sample coding for multiple table join

Former Member — Wed, 07 Mar 2007 09:39:48 GMT

good

go through these links

http://www.sapdb.org/7.4/htmhelp/45/f31c38e95511d5995d00508b5d5211/content.htm

thanks

mrutyun^