Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

select query to join 4 tables

Former Member

‎09-29-2008 2:42 PM

0 Kudos

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.

2 REPLIES 2

former_member585060
Active Contributor

‎09-29-2008 3:08 PM

0 Kudos

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

Instead of ANLAV you use Table ANKL-KTANSW

Former Member
In response to former_member585060

‎09-29-2008 3:11 PM

0 Kudos

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