topic Re: regarding inner join in Application Development and Automation Discussions

regarding inner join

Former Member — Mon, 04 Dec 2006 05:56:53 GMT

hi,

i m using inner join between enab and mseg ,but when ever i execute this select statement it shows dump error,i request u to plz rectifie the error...i m giving the cmplete select statement below.......

looking forward to an early reply.

ravi gupta....

select eban_{loekz eban}frgzu eban_{matnr eban}matkl

eban_{txz01 eban}werks

eban_{bednr eban}banfn eban_{bnfpo eban}badat eban_{menge eban}bedat

eban~ebeln

mseg~mblnr

into corresponding fields of table itab_final

from eban

inner join mseg

eban_{ebeln = mseg}ebeln.

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 06:02:48 GMT

TRY THIS

select eban_{loekz eban}frgzu eban_{matnr eban}matkl

eban_{txz01 eban}werks

eban_{bednr eban}banfn eban_{bnfpo eban}badat eban_{menge eban}bedat

eban~ebeln

mseg~mblnr

into corresponding fields of table itab_final

from eban <b>AS EBAN</b>

inner join mseg <b>AS MSEG</b>

eban_{ebeln = mseg}ebeln.

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 06:03:57 GMT

what is the dump you are getting ??

Re: regarding inner join

raguraman_c — Mon, 04 Dec 2006 06:04:18 GMT

Hi,

Please check your itab, can you provide your declaration of your itab_final. Lemme see.

Feel free to revert back.

--Ragu

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 06:06:02 GMT

the final internal table

data:begin of itab_final occurs 0,

loekz like eban-loekz, "delete indicator

frgzu like eban-frgzu, "release status

matnr like eban-matnr, "material number

matkl like eban-matkl, "material group

txz01 like eban-txz01, "short text

werks like eban-werks, "plant

bednr like eban-bednr, "tracking number

banfn like eban-banfn, "PR number

bnfpo like eban-bnfpo, "item number of PR

badat like eban-badat, "requisition date

menge like eban-menge, "PR quantity

bedat like eban-bedat, "PO date

ebeln like eban-ebeln, "PO number

id type i, "for SINO.

menge1 like ekpo-menge, "PO quantity

maktx like makt-maktx, "material description

menge2 like mseg-menge, " mblnr quantity

mblnr like mseg-mblnr, "material document number

bwart like mseg-bwart, "movement type

lfbnr like mseg-lfbnr, "refrence document number

budat like mkpf-budat, "posting date

end of itab_final.

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 06:07:22 GMT

the error is given below........

When the program was running, it was established that more

memory was needed than the operating system is able to provide savely.

To avoid a system crash, you must prevent this

situation.

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 06:13:57 GMT

The number of fields u have seelcted is different from the no. of fields declared in the internal table. That could be the reason for the dump.

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 06:17:58 GMT

Hi ravi,

I tried running your code. I have not encountered any dump. Only the selection is too long. The code selected Table[12807888x290] lines.

TYPES: BEGIN OF t_final,

loekz LIKE eban-loekz,

frgzu LIKE eban-frgzu,

matnr LIKE eban-matnr,

matkl LIKE eban-matkl,

txz01 LIKE eban-txz01,

werks LIKE eban-werks,

bednr LIKE eban-bednr,

banfn LIKE eban-banfn,

bnfpo LIKE eban-bnfpo,

badat LIKE eban-badat,

menge LIKE eban-menge,

bedat LIKE eban-bedat,

ebeln LIKE eban-ebeln,

mblnr LIKE mseg-mblnr,

END OF t_final.

DATA: itab_final TYPE STANDARD TABLE OF t_final.

SELECT eban_{loekz eban}frgzu eban_{matnr eban}matkl

eban_{txz01 eban}werks

eban_{bednr eban}banfn eban_{bnfpo eban}badat eban_{menge eban}bedat

eban~ebeln

mseg~mblnr

INTO CORRESPONDING FIELDS OF TABLE itab_final

FROM eban

INNER JOIN mseg

eban_{ebeln = mseg}ebeln.

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 06:26:20 GMT

try this one.

data:begin of itab_final occurs 0,

loekz like eban-loekz, "delete indicator

frgzu like eban-frgzu, "release status

matkl like eban-matkl, "material group

txz01 like eban-txz01, "short text

werks like eban-werks, "plant

bednr like eban-bednr, "tracking number

banfn like eban-banfn, "PR number

bnfpo like eban-bnfpo, "item number of PR

badat like eban-badat, "requisition date

menge like eban-menge, "PR quantity

bedat like eban-bedat, "PO date

ebeln like eban-ebeln, "PO number

mblnr like mseg-mblnr, "material document number

end of itab_final.

select eban~loekz

eban~frgzu

eban~matnr

eban~matkl

eban~txz01

eban~werks

eban~bednr

eban~banfn

eban~bnfpo

eban~badat

eban~menge

eban~bedat

eban~ebeln

mseg~mblnr

into corresponding fields of table itab_final

from eban

inner join mseg

eban_{ebeln = mseg}ebeln

WHERE EBAN~EBELN = 'T'.

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 06:45:49 GMT

not working

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 07:05:01 GMT

are you getting same dump error?.

here its working. and it select the data correspoding to po "T"

Re: regarding inner join

Former Member — Mon, 04 Dec 2006 08:38:17 GMT

whats the error? if its time out the alternate is to use ekbe table that mseg, may be that would help.

Rgds,

Anu.