topic Re: ABAP query!! in Application Development and Automation Discussions

ABAP query!!

rnb86 — Tue, 10 Apr 2007 08:20:10 GMT

Hi friends,

Using <b>ABAP query</b>, we can display the fields of a table without a program. Fine. My question is:

<b>i want to display join of 2 tables using abap query, how can we do it.</b>

Re: ABAP query!!

Former Member — Tue, 10 Apr 2007 08:22:03 GMT

check this

Regards

Prabhu

Re: ABAP query!!

Former Member — Tue, 10 Apr 2007 08:27:19 GMT

chk this thread:

Reg Join chk this:

To form the query with two or three tables, we need to create a join. For this check the Table Join Check Box and click on the Table Join button.

NOTE: The tables to be used in the join should have at least one field in common i.e. it should have the same name, domain or data element.

Mention the tables that you want to include in the join condition in the Joined Tables area and press ENTER.

A checkbox will appear against the table names on the left side, and three radio buttons will appear against the tables on the right side specifying the join type.

Base table name remains grayed out. Select the two tables to be involved in the join by clicking the check boxes against them. Use menu path Edit => Join => Define condition to create the join. A mapping between the tables will be displayed on the right hand side. Click on the button provided (with + and down arrow symbol) to specify the join.

Click YES on the Proposal Requested message that gets displayed.

If the join tables have a foreign key relationship then the common fields in the tables will be marked with 00 to indicate that the join has been created. User can create the join by specifying 00, 01 etc. against the fields that qualify for the join.

Complete the join condition by adding more tables if necessary.

**reward if helpful

regards,

madhu

Re: ABAP query!!

rnb86 — Tue, 10 Apr 2007 09:24:54 GMT

Thank you prabhu and madhumita, your answers were helpful.

Madhumita the text that you wrote was more helpful than all the links that i got as answers. Thank you once again. I have rewarded points to both of you.

Regards,

Raghu.

Re: ABAP query!!

Former Member — Tue, 10 Apr 2007 10:03:23 GMT

Hi gurus,

Plz check the this url.

If u want to get data from two table no need to provide any join statement there.

Because it is automatically fetch data from different table and it will present it in persentation server.

For more information plz check the url.

http://www.saptechnical.com/Tutorials/LSMW/BAPIinLSMW/BL1.htm

Rgds,

P.Naganjana Reddy