self join

[Former Member]

hi abapers ,

how can i use self join in abap.

thanks

[Former Member]

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

[Sandeep_Panghal]

HI,

Do we really need something like SELF join in abap.

Rgds,

Sandeep

[sandeeps026]

Yes, we need self join in SAP.

[Former Member]

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