select query to join 4 tables

[Former Member]

Hi i want to fetch lblnr and bukrs from the table bseg and in the where codn it must make use of rbada,anek and anlav table such that the rbada-brdatu is present in variable lv_lastdate and anek-budat in lv_start and lv_end,anlav-ktansw in p_ktansw.I have to make use of these values in where codn.Please help to code this part.

[Former Member]

Hi i want to fetch lblnr and bukrs from the table bseg and in the where codn it must make use of rbada,anek and anlav table such that the rbada-brdatu is present in variable lv_lastdate and anek-budat in lv_start and lv_end,anlav-ktansw in p_ktansw.I have to make use of these values in where codn.Please help to code this part.

[former_member585060]

RBADA and ANLAV are structures, so there will be no data in them

Instead of ANLAV you use Table ANKL-KTANSW

[Former Member]

Ok thanks...can you please tell how to write the select query