Search operation based on the screen input fields of different table?

[Former Member]

I have to perform a search operation.In the selection screen i will have two input fields.These two input fields belong to two different tables.Based on the input fields value my result list to be generated after reading the two tables.

How may i do this?If i have to use join then how may i use it?

Points would be awarded graciously.

[former_member181962]

Hereis a sample program for usage of INNER JOIN:

demo_select_inner_join

Regards,

Ravi

[Former Member]

Mr.Ravi thank you for your answers..but can u explain me how that code works i have no much idea about this code.I did not understand how the wa was declared.

I kindly request for help.

[Former Member]

Hi Harish,

Refer this to know how to use join statement

http://www.sap-img.com/abap/inner-joins.htm

Regards,

Santosh

[Former Member]

Mr.Santhosh thank you for your answers..but can u explain me how that code works i have no much idea about this code.I did not understand how the wa was declared.

I kindly request for help.

[Former Member]

Mr Ravi and Mr.Santhosh thank you for your answers..but can u explain me how that code works i have no much idea about this code.I did not understand how the wa was declared.

I kindly request for help.