Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

inner join in select statement

hi,

i am using select statement like

SELECT ekkoebeln ekkobukrs ekkobstyp ekkobsart ekko~ernam

ekkolifnr ekkozterm ekkozbd1t ekkozbd2t ekko~zbd3t

ekkozbd1p ekkozbd2p ekkoekorg ekkoekgrp ekko~waers

ekkowkurs ekkokufix ekkobedat ekkokdate

  • Begin of Changes, RICEF : 293.

ekkozzhedg ekkozzheda ekkozzpba ekkozzpbubu lfa1~vbund

  • End of Changes, RICEF . 293.

lfa1land1 lfa1name1

ekpa~lifn2

INTO CORRESPONDING FIELDS OF TABLE iekko

FROM ekko

JOIN lfa1 ON lfa1lifnr = ekkolifnr

LEFT JOIN ekpa ON ekpaebeln = ekkoebeln 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?

Tags:
Not what you were looking for? View more on this topic or Ask a question