topic Re: Inner join in Application Development and Automation Discussions

Inner join

Former Member — Tue, 13 Mar 2007 15:09:21 GMT

hello experts,

I have to retrieve the data for the fields

SELECT EKPO_{EBELN EKPO}EBELP EKPO_{MENGE EKPO}MEINS EKPO_{MATNR EKPO}IDNLF MAKT~MAKTX

EKET_{MENGE EKET}WEMNG MARD~LGORT into table iekpo from ekpo inner join.....................................FOR ALL ENTRIES IN iekko.

Plz any one help me to complete this select statement...

SIRI

Re: Inner join

Former Member — Tue, 13 Mar 2007 15:13:30 GMT

Hello Sri,


SELECT EKPO~EBELN EKPO~EBELP EKPO~MENGE EKPO~MEINS EKPO~MATNR EKPO~IDNLF MAKT~MAKTX 
EKET~MENGE EKET~WEMNG MARD~LGORT into table iekpo from ekpo inner join EKET on EKPO~EBELN eq EKET~EBELN
                    EKPO~EBELP eq EKET~EBELP
                   FOR ALL ENTRIES IN iekko
                   where EKPO~EBELN eq IEKKO-EBELP.

Regards,

Vasanth

Re: Inner join

Former Member — Tue, 13 Mar 2007 15:15:08 GMT

SELECT EKPO_{EBELN EKPO}EBELP EKPO_{MENGE EKPO}MEINS EKPO_{MATNR EKPO}IDNLF MAKT_{MAKTX EKET}MENGE EKET_{WEMNG MARD}LGORT

INTO TABLE iekpo

From EKPO INNER JOIN EKET

ON EKPO-EBELN = EKET-EBLEN AND EKPO-EBEL = EKET-EBELN

INNER JOIN MARD

ON MARD-MATNR = EKPO-MATNR AND MARD-LGORT = EKPO-LGORT AND MARD-WERKS = EKPO-WERKS

FOR ALL ENTRIES IN iekko

WHERE EKPO-EBELN = iekpo-ebeln.

Re: Inner join

Former Member — Tue, 13 Mar 2007 15:15:26 GMT

hi,

SELECT EKPO_{EBELN EKPO}EBELP EKPO_{MENGE EKPO}MEINS EKPO_{MATNR EKPO}IDNLF

EKET_{MENGE EKET}WEMNG

MAKT~MAKTX

MARD_{LGORT into table iekpo from ekpo inner join. eket on ekpo}ebeln = eket_{ebeln and ekpo}ebelp = eket~ebelp join makt on

ekpo_{matnr = makt}matnr join mard

on ekpo_{matnr = mard}matnr and

ekpo_{werks = mard}werks and

ekpo_{lgort = mard}lgort

FOR ALL ENTRIES IN iekko.

where

give all conditions

finally write makt~spras = sy-langu.

Regards,

Anji

Re: Inner join

Former Member — Tue, 13 Mar 2007 15:17:34 GMT

hi,

do this way..


SELECT EKPO~EBELN 
              EKPO~EBELP 
              EKPO~MENGE 
              EKPO~MEINS
              EKPO~MATNR 
              EKPO~IDNLF
              MAKT~MAKTX
              EKET~MENGE 
              EKET~WEMNG 
              MARD~LGORT 
              into table iekpo from ekpo as ekpo
                inner join makt as makt
                on < Conditions>
                innerjoin eket as eket
                on < Conditons >
                innerjoin mard as mard
                on < Conditions >
               FOR ALL ENTRIES IN iekko
               where <Conditions >.

but it is always better to avoid joins and use for all entries in this way ..

if not iekko[]  is  initial.
  select * from ekpo into table iekpo
for all enries in 
endif.

if not iekpo[] is intial.
select * from makt into table imakt ..
for all enries in 
endif.


if not imakt[] is intial.
select * from eket into table ieket ..
for all enries in 
endif.


if not ieket[] is intial.
select * from mard into table imakt ..
for all enries in 
endif.

Regards,

Santosh

Re: Inner join

Former Member — Tue, 13 Mar 2007 15:47:57 GMT

Ya everything is fine

but after the for all entries can any one tell me the correct where condition because when i put the where condition it is giving error to me

in the selection screen i am having the fields ekpo-matnr, eket-eindt.

thanks alot for your anticipation and valuable time...

SIRI

Re: Inner join

Former Member — Tue, 13 Mar 2007 16:18:02 GMT

Hi anji reddy,

can complete your code with the for all entries becz i am getting the error

Re: Inner join

Former Member — Tue, 13 Mar 2007 17:06:29 GMT

can anyone help me plz...

Re: Inner join

former_member187255 — Tue, 13 Mar 2007 17:18:42 GMT

Try this......

SELECT EKPO_{EBELN EKPO}EBELP EKPO_{MENGE EKPO}MEINS EKPO_{MATNR EKPO}IDNLF

EKET_{MENGE EKET}WEMNG

MAKT~MAKTX

MARD~LGORT into table iekpo from ekpo inner join

eket on ekpo_{ebeln = eket}ebeln and

ekpo_{ebelp = eket}ebelp join makt on

ekpo_{matnr = makt}matnr join mard

on ekpo_{matnr = mard}matnr and

ekpo_{werks = mard}werks and

ekpo_{lgort = mard}lgort

FOR ALL ENTRIES IN iekko

where EKPO~MATNR eq ekpo-matnr

and EKET~eindt eq eket-eindt.

Re: Inner join

Former Member — Tue, 13 Mar 2007 18:46:22 GMT

chandra

I am using selection screen with select options how to give those options in the where clause of this select statement

Re: Inner join

Former Member — Tue, 13 Mar 2007 18:56:16 GMT

hi sri,

if u r using a select options try to give in instead of eq in the where condition.

where EKPO~MATNR IN ekpo-matnr

and EKET~eindt IN eket-eindt.

Regards...

Arun.

Re: Inner join

Former Member — Wed, 14 Mar 2007 05:18:40 GMT

Hi!

whenever we use SELECT-OPTIONS, we have to use IN instead of EQ in WHERE clause.

Regards,

Neha Bansal

Re: Inner join

Former Member — Wed, 14 Mar 2007 05:26:52 GMT

hiii sri..

Try this..

SELECT EKPO~EBELN

EKPO~EBELP

EKPO~MENGE

EKPO~MEINS

EKPO~MATNR

EKPO~IDNLF

MAKT~MAKTX

EKET~MENGE

EKET~WEMNG

MARD~LGORT

into table iekpo from ekpo as ekpo

inner join makt as makt

on < Conditions>

innerjoin eket as eket

on < Conditons >

innerjoin mard as mard

on < Conditions >

FOR ALL ENTRIES IN iekko

where ekko~vbeln eq iekko-vbeln

and ekpo-matnr eq p_para1

and eket-eindt eq p_para2. ( p_Para1, p_para2 are the selection screen field's names )

select ...

....

for all enries in ietab

where <field> eq ietab-<field>

and ....~... eq p_para1

and ....~... eq p_para2.

When u use for all entries... u have to put a condition in where clause on the table which u have used in for all entries .. otherwise it will give u an error...

reward if it helps u..

sai ramesh