topic Re: inner join in select statement in Application Development and Automation Discussions

inner join in select statement

Former Member — Tue, 14 Oct 2008 05:43:41 GMT

hi,

i am using select statement like

SELECT ekko_{ebeln ekko}bukrs ekko_{bstyp ekko}bsart ekko~ernam

ekko_{lifnr ekko}zterm ekko_{zbd1t ekko}zbd2t ekko~zbd3t

ekko_{zbd1p ekko}zbd2p ekko_{ekorg ekko}ekgrp ekko~waers

ekko_{wkurs ekko}kufix ekko_{bedat ekko}kdate

Begin of Changes, RICEF : 293.

ekko_{zzhedg ekko}zzheda ekko_{zzpba ekko}zzpbubu lfa1~vbund

End of Changes, RICEF . 293.

lfa1_{land1 lfa1}name1

ekpa~lifn2

INTO CORRESPONDING FIELDS OF TABLE iekko

FROM ekko

JOIN lfa1 ON lfa1_{lifnr = ekko}lifnr

LEFT JOIN ekpa ON ekpa_{ebeln = ekko}ebeln AND

ekpa~ebelp = '00000' AND

ekpa~parvw = 'RS'

FOR ALL entries IN icooi

WHERE ekko~ebeln = icooi-refbn

AND ekko~zzhedg IN s_zzhedg

AND ekko~zzheda IN s_zzheda.

where in ekko table ,the fields zzhedg and zzheda are appended..but in the debugging mode i am unable to see this 2 field....in the output also....so how should i write my select query?

Re: inner join in select statement

Former Member — Tue, 14 Oct 2008 05:46:25 GMT

Hi,

Is your select statement returning sy-subrc 0. In debugging mode may be your fields may not be visible in the screen since your internal table has many fields, you have to press >> forward button to check the fields.

Thanks & Regards,

Navneeth K.

Re: inner join in select statement

GauthamV — Tue, 14 Oct 2008 05:47:41 GMT

hi,

did you define these fields in internal table iekko.

also did you define these fields in field catelog.

check these two first.

Re: inner join in select statement

Former Member — Tue, 14 Oct 2008 05:50:15 GMT

ya...i have defined in internal table iekko.

Re: inner join in select statement

Former Member — Tue, 14 Oct 2008 05:51:11 GMT

If your table activation is fine enough.

i think you have defined the iekko type ekko and the appended fields are always append at last it must be there in debugmode also, the problem is your screen resolution in debug mode just set the column number from debug and take them atlast you may be able to see these fields in iekko.