https://community.sap.com/t5/application-development-and-automation-discussions/select-query-to-join-4-tables/m-p/4497311#M1064162 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 29 Sep 2008 13:42:15 GMT Former Member 2008-09-29T13:42:15Z https://community.sap.com/t5/application-development-and-automation-discussions/select-query-to-join-4-tables/m-p/4497311#M1064162 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 29 Sep 2008 13:42:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-query-to-join-4-tables/m-p/4497311#M1064162 Former Member 2008-09-29T13:42:15Z https://community.sap.com/t5/application-development-and-automation-discussions/select-query-to-join-4-tables/m-p/4497312#M1064163 <HTML><HEAD></HEAD><BODY><P>RBADA and ANLAV are structures, so there will be no data in them </P><P>Instead of ANLAV you use Table ANKL-KTANSW</P></BODY></HTML> Mon, 29 Sep 2008 14:08:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-query-to-join-4-tables/m-p/4497312#M1064163 former_member585060 2008-09-29T14:08:24Z https://community.sap.com/t5/application-development-and-automation-discussions/select-query-to-join-4-tables/m-p/4497313#M1064164 <HTML><HEAD></HEAD><BODY><P>Ok thanks...can you please tell how to write the select query</P></BODY></HTML> Mon, 29 Sep 2008 14:11:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-query-to-join-4-tables/m-p/4497313#M1064164 Former Member 2008-09-29T14:11:53Z