topic Re: classical report in Application Development and Automation Discussions

classical report

Former Member — Tue, 01 May 2007 06:33:40 GMT

Hi guru's,

here iam trying to write some code for the following requirement,but at select statement i want to use innerjoin how can i? and wat will happen if i'll use this corresponding .is there any chance to write a select statement as nested select if possible how pls help me . full points.urgent

if usefull full points.to all

thanx regards

lokanadhan

Req: by using classical report

vendor from -

to -

output:-

vno p.o itemno material

tables : lfa1,ekko,ekpo,mara.

parameters : vendor like lfa1-lifnr.

data : begin of itab occurs 0,

lifnr like lfa1-lifnr,

ebeln like ekko-ebeln,

ebelp like ekpo-ebelp,

matnr like mara-matnr,

end of itab.

select lfa1_{lifnr ekko}ebeln ekpo_{ebelp mara}matnr

into corresponding fields of table itab

from lfa1 join ekko on lfa1_{lifnr = ekko}lifnr

join ekpo on ekko_{ebeln = ekpo}ebeln

join matnr on ekpo_{matnr = mara}matnr.

loop at itab.

write : / itab-lifnr ,itab-ebeln,itab-ebelp,itab-matnr.

endloop.

Re: classical report

Former Member — Tue, 01 May 2007 06:37:51 GMT

HI..,

No need to use the CORRESPONDING FIELDS OF here..

Nested SELECTS and INTO CORRESPONDING FIELDS degrades the performance..

just check this..

tables : lfa1,ekko,ekpo,mara.

parameters : vendor like lfa1-lifnr.

data : begin of itab occurs 0,

lifnr like lfa1-lifnr,

ebeln like ekko-ebeln,

ebelp like ekpo-ebelp,

matnr like mara-matnr,

end of itab.

select lfa1_{lifnr ekko}ebeln ekpo_{ebelp mara}matnr

into table itab

from lfa1

inner join ekko on lfa1_{lifnr = ekko}lifnr

inner join ekpo on ekko_{ebeln = ekpo}ebeln

inner join mara on ekpo_{matnr = mara}matnr

where lfa1~lifnr eq vendor.

loop at itab.

write : / itab-lifnr ,itab-ebeln,itab-ebelp,itab-matnr.

endloop.

regards,

sai ramesh

Re: classical report

Former Member — Tue, 01 May 2007 06:38:56 GMT

Hi,

use the inner join statemnet only.its better to use join statement compared to nested selection statements.this is the efficient way in performance wise.

select lfa1_{lifnr ekko}ebeln ekpo_{ebelp mara}matnr

into corresponding fields of table itab

from lfa1 inner join ekko on lfa1_{lifnr = ekko}lifnr

inner join ekpo on ekko_{ebeln = ekpo}ebeln

inner join mara on ekpo_{matnr = mara}matnr.

rgds,

bharat.

Re: classical report

Former Member — Tue, 01 May 2007 06:40:48 GMT

HI..

Just paste this code...<b>which is modified..</b>

select-options:

vendor for lfa1-lifnr.

data : begin of itab occurs 0,

lifnr like lfa1-lifnr,

ebeln like ekko-ebeln,

ebelp like ekpo-ebelp,

matnr like mara-matnr,

end of itab.

select lfa1_{lifnr ekko}ebeln ekpo_{ebelp mara}matnr

into corresponding fields of table itab

from lfa1 join ekko

on lfa1_{lifnr = ekko}lifnr

join ekpo

on ekko_{ebeln = ekpo}ebeln

join mara

on ekpo_{matnr = mara}matnr.

loop at itab.

write : / itab-lifnr ,itab-ebeln,itab-ebelp,itab-matnr.

endloop.

Re: classical report

Former Member — Tue, 01 May 2007 06:41:18 GMT

Hi ..

join mara <i>(mistake matnr</i>) on ekpo_{matnr = mara}matnr.

Re: classical report

Former Member — Tue, 01 May 2007 06:42:29 GMT

hi ramesh,

for the same code i need an nested select statement.how can i write tht...,is there any chance to go with for all entries.if possible how?

thanx

yogi

Re: classical report

Former Member — Tue, 01 May 2007 06:45:01 GMT

hi ramesh,

is there any difference b/w inner join and join.

thanx

yogi