Inner join

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi anji reddy,

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

[Former Member]

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

[Former Member]

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

[Former Member]

can anyone help me plz...

[former_member187255]

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.

[Former Member]

chandra

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

[Former Member]

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

[Former Member]

hi sri,

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

where EKPO~MATNR <b>IN</b> ekpo-matnr

and EKET~eindt <b>IN</b> eket-eindt.

Regards...

Arun.

[Former Member]

Hi!

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

Regards,

Neha Bansal