SELECT STATEMENT

[Former Member]

HI

CAN ANY ONE GUIDE ME HOW TO MAKE THESE TWO SELECT STATEMENTS WORK EFFECTIVELY

SELECT EKKO_{EBELN EKKO}AEDAT EKKO_{EKGRP EKKO}EKORG EKKO_{LIFNR EKPO}MATNR EKET~EINDT INTO corresponding fields of TABLE it_ekko

FROM ekko INNER JOIN EKPO ON EKKO_{EBELN = EKPO}EBELN

INNER JOIN EKET ON EKKO_{EBELN = EKET}EBELN

where EKKO~lifnr in p_lifnr

and EKKO~ebeln in p_ebeln

and EKKO~ekgrp in p_ekgrp

and EKKO~aedat in p_aedat

and EKKO~ernam in p_ernam

AND EKPO~EBELN IN P_MATNR

AND EKET~EINDT IN P_EINDT.

SELECT EKKO_{EBELN EKKO}AEDAT EKKO_{EKGRP EKKO}EKORG EKKO~LIFNR

EKPO_{EBELP EKPO}MENGE EKPO_{MEINS EKPO}MATNR MARD_{LGORT EKPO}IDNLF EKPO~TXZ01

MARD_{LGPBE T001L}LGOBE EKES_{MENGE eket}wemng into

corresponding fields of table it_ekko from

ekpo INNER JOIN EKKO ON EKPO_{EBELN = EKKO}EBELN

inner join eket on

ekpo_{ebeln = eket}ebeln and

ekpo_{ebelp = eket}ebelp

INNER JOIN T001L ON EKPO_{WERKS = T001L}WERKS inner join mard on

ekpo_{matnr = mard}matnr and ekpo_{werks = mard}werks

INNER JOIN EKES ON EKPO_{EBELN = EKES}EBELN

FOR ALL ENTRIES IN it_ekko where ekpo~ebelN = it_ekko-ebelN.

SIRI

[Former Member]

<b>1)----

---

></b>

SELECT EKKO_{EBELN EKKO}AEDAT EKKO_{EKGRP EKKO}EKORG EKKO_{LIFNR EKPO}MATNR EKET~EINDT INTO corresponding fields of TABLE it_ekko

FROM ekko INNER JOIN EKPO ON EKKO_{EBELN = EKPO}EBELN

INNER JOIN EKET ON EKKO_{EBELN = EKET}EBELN

where EKKO~lifnr eq p_lifnr

and EKKO~ebeln eq p_ebeln

and EKKO~ekgrp eq p_ekgrp

and EKKO~aedat eq p_aedat

and EKKO~ernam eq p_ernam

AND EKPO_{matnr eq P_MATNR <----}

---

( EKKOMATNR )

AND EKET~EINDT eq P_EINDT.

<b> ( i hope all the p_ 's are parameters thats y u need to use 'EQ' , if those are select options then 'IN' is correct )...</b>

<b>and dont use into corresponding tables...

define the structure of it_ekko as...</b>

data :

begin of it_ekko occurs 0,

ebeln type EKKO-EBELN,

aedat type EKKO-AEDAT,

ekgrp type EKKO-EKGRP,

ekorg type EKKO-EKORG,

lifnr type EKKO-LIFNR,

matnr type EKPO-MATNR,

eindt type EKET-EINDT,

end fo it_ekko.

<b>and remove into corresponding fields ... this improves the performs greatly... </b>

[Former Member]

Ramesh

all those p's r select opitions...

Is anything important to be changed..

anyone guide me plz

[amit_khare]

if p_ are select options change all EQ to IN.

Regards,

Amit

[Former Member]

hi

SELECT ekko_{ebeln ekko}aedat

ekko_{ekgrp ekko}ekorg

ekko_{lifnr ekpo}matnr

eket~eindt

INTO CORRESPONDING FIELDS OF TABLE it_ekko

FROM ( ( ekko

INNER JOIN ekpo

ON ekko_{ebeln = ekpo}ebeln )

INNER JOIN eket ON ekko_{ebeln = eket}ebeln )

WHERE ekko~lifnr IN p_lifnr

AND ekko~ebeln IN p_ebeln

AND ekko~ekgrp IN p_ekgrp

AND ekko~aedat IN p_aedat

AND ekko~ernam IN p_ernam

AND ekpo~ebeln IN p_matnr

AND eket~eindt IN p_eindt.

[Former Member]

hi,

SELECT P_{EBELN P}AEDAT P_{EKGRP P}EKORG P_{LIFNR P}MATNR Q~EINDT INTO corresponding fields of TABLE it_ekko

FROM ekko as p INNER JOIN EKET as Q ON Q_{EBELN = P}EBELN

where p~lifnr in p_lifnr

and p~ebeln in p_ebeln

and p~ekgrp in p_ekgrp

and p~aedat in p_aedat

and p~ernam in p_ernam

AND p~EBELN IN P_MATNR

AND q~EINDT IN P_EINDT.

try this,

kc

[Former Member]

remove 'into corresponding' and maintain the order of fields same as in internal table.

it may a bit to the performance.

Regards,

Sujatha.