topic Re: self join in Application Development and Automation Discussions

self join

Former Member — Wed, 05 Nov 2008 05:51:09 GMT

hi abapers ,

how can i use self join in abap.

thanks

Re: self join

Former Member — Wed, 05 Nov 2008 06:09:29 GMT

Hi,

i think self join is not available in SAP...but you can make the view table from single database table in DDIC..Other wise do it using internal table....from one database table....fill up two internal tables..and making loop...store it another internal table....

Arunima

Re: self join

Sandeep_Panghal — Wed, 05 Nov 2008 06:11:05 GMT

HI,

Do we really need something like SELF join in abap.

Rgds,

Sandeep

Re: self join

Former Member — Wed, 05 Nov 2008 06:16:02 GMT

Hi,

This is just an hypothetical example of self join in abap.

select x~empid as xempid  "Employee ID
         x~empname as xempname "Employee Name
         y~empid as yempid   "Supervisor ID
         y~empname as yempname " Supervisor Name
into corresponding fields of itab
from zemployee as x
  inner join zemployee as y on x~supid = y~empid

Regards,

Vishal

Re: self join

sandeeps026 — Fri, 14 Apr 2023 11:02:20 GMT

Yes, we need self join in SAP.