topic Re: Join Statement require in Application Development and Automation Discussions

Join Statement require

former_member764673 — Tue, 06 Feb 2007 20:13:54 GMT

I have three tables..

ZGMARD

EQUI

EQBS

ZGMARD tables has

MATNR

WERKS

LGORT

EQUI table has

EQUNR

MATNR

SERGE

EQBS table has

EQUNR

WERKS

PLANT

Now my requirement is I need a join statement where

dependeding on MATNR,WERKS and LGORT from ZGMARD I should be able to get the SERGE.(depending on tables EQUI and EQBS)

Any help would be appreciated.

Thanks,

Raj

Re: Join Statement require

Former Member — Tue, 06 Feb 2007 20:16:25 GMT

HI,

Check this..

i see u dont need to have EQBS table in join to get SERGE values.. any way i coded with EQBS... if u feel u dont need u can take it out..

assume u defined internal table with those fields.

SELECT ZGMARD_{MATNR ZGMARD}LGORT EQUI_{EQUNR EQUI}SERGE EQBS_{WERKS INTO CORRESPONDING FIELDS OF TABLE ITAB FROM ZGMARD INNER JOIN EQUI ON ZGMARD}MATNR = EQUI_{MATNR INNER JOIN EQBS ON EQUI}EQUNR = EQBS_{EQUNR WHERE ZGMARD}MATNR IN SO_MATNR AND EQBS~WERKS IN SO_WERKS.

SO_MATNR and SO_WERKS are select-options or parameters in selection screen. Provide some more condition in where clause for performace issue.

u can add more conditions according to ur requirement.

Regards

SAB

Re: Join Statement require

Former Member — Tue, 06 Feb 2007 21:09:13 GMT

Hi,

In real time generally we avoid the use of Inner Joins because of Performance Issue. Istead of joins you can go for SELECT FOR ALL ENTRIES.

Ashvender

Re: Join Statement require

former_member764673 — Tue, 06 Feb 2007 21:33:24 GMT

HI,

Its giving me ALIAS name table error..

Is there any thing I can do..?

Any help would be appreciated.

Thanks,

Raj