topic Re: SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Thu, 15 Mar 2007 17:11:30 GMT

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

Re: SELECT STATEMENT

Former Member — Thu, 15 Mar 2007 17:31:15 GMT

1)----

>

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.

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

and dont use into corresponding tables...

define the structure of it_ekko as...

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.

and remove into corresponding fields ... this improves the performs greatly...

Re: SELECT STATEMENT

Former Member — Thu, 15 Mar 2007 18:44:12 GMT

Ramesh

all those p's r select opitions...

Is anything important to be changed..

anyone guide me plz

Re: SELECT STATEMENT

amit_khare — Thu, 15 Mar 2007 18:47:13 GMT

if p_ are select options change all EQ to IN.

Regards,

Amit

Re: SELECT STATEMENT

Former Member — Fri, 16 Mar 2007 05:39:37 GMT

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.

Re: SELECT STATEMENT

Former Member — Fri, 16 Mar 2007 05:46:25 GMT

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,

Re: SELECT STATEMENT

Former Member — Fri, 16 Mar 2007 05:48:53 GMT

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

it may a bit to the performance.

Regards,

Sujatha.