topic Inner join in Application Development and Automation Discussions

Inner join

Former Member — Fri, 09 Jan 2009 10:32:00 GMT

hi all,

i m writing the code for inner join but its going for dump and error is. 'Error in module RSQL of the database interface.' please help me.

code: DATA : BEGIN OF itab OCCURS 0 ,

pernr LIKE pa0015-pernr , "Personel no.

subty LIKE pa0015-subty, "SUBTYPE OF INFOTYPE

endda LIKE pa0015-endda , "LTA Taken Date

betrg LIKE pa0015-betrg, "LTA Amount

ZUORD like pa0015-zuord, "Assignment number

LGA01 LIKE PA0589-LGA01,

BET01 LIKE PA0589-LGA01,

ename LIKE pa0001-ename , "Employee name

begda LIKE pa0001-begda , "Joining date

pending TYPE p DECIMALS 2, "Pending LTA amount

end of itab.

SELECT M1_{pernr M1}subty M1_{endda M1}betrg M1_{zuord M2}LGA01 M2~BET01 INTO CORRESPONDING FIELDS OF TABLE itab

FROM PA0015 AS M1 INNER JOIN PA0589 AS M2

ON M1_{PERNR = M2}PERNR

AND M1_{SUBTY = M2}SUBTY

WHERE M1_{pernr IN pernr AND M1}subty = '4004'.

Regards Nitin.

Re: Inner join

Former Member — Fri, 09 Jan 2009 10:35:08 GMT

there is some problem with this line,

WHERE M1_{pernr IN pernr AND M1}subty = '4004'.

here what is pernr ,is it a select-option?

if not, then this is the root of your problem.

thanks

geeta

Re: Inner join

SuhaSaha — Fri, 09 Jan 2009 10:37:54 GMT

Hello Saurabh,

Change the declaration

BET01 LIKE PA0589-LGA01,

BET01 LIKE PA0589-BET01,

It will work )

BR,

Suhas

Edited by: Suhas Saha on Jan 9, 2009 11:38 AM

Re: Inner join

Former Member — Fri, 09 Jan 2009 10:38:27 GMT

hi geeta,

thanx for reply, PERNR is of selection screen.

thats : select-options : pernr for pa00015-pernr.

regards nitin.

Re: Inner join

Pawan_Kesari — Fri, 09 Jan 2009 10:39:46 GMT


code: DATA : BEGIN OF itab OCCURS 0 ,
pernr LIKE pa0015-pernr , "Personel no.
subty LIKE pa0015-subty, "SUBTYPE OF INFOTYPE
endda LIKE pa0015-endda , "LTA Taken Date
betrg LIKE pa0015-betrg, "LTA Amount
ZUORD like pa0015-zuord, "Assignment number
LGA01 LIKE PA0589-LGA01,
*BET01 LIKE PA0589-LGA01,*
ename LIKE pa0001-ename , "Employee name
begda LIKE pa0001-begda , "Joining date

fix this


*BET01 LIKE PA0589-BET01,*

hopefully this should solve the problem

Re: Inner join

Former Member — Fri, 09 Jan 2009 10:42:37 GMT

hi,

the error is related to basis.

the size of the table has a problem.

Re: Inner join

Former Member — Fri, 09 Jan 2009 10:55:16 GMT

hi you only use

" into table itab"

in stead of INTO CORRESPONDING FIELDS OF TABLE itab.

if you still face problem please let me know..

Edited by: swati gupta on Jan 9, 2009 11:57 AM