Community
Application Development and Automation 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: 
Read only

Inner and out loop statement

Go to solution
Former Member

‎2008 Jul 16 7:49 PM

0 Likes
439

I have two tables .

A1 and L1

A1 has

address

sort_no

L1 has

Address

lifnr.

I want to get lifnr depending on sort_no. in a single select number.

How to get it.

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2008 Jul 16 7:52 PM

0 Likes
417

Hi,

Use Joins:

select l1~lifnr from l1

inner join a1 on l1address = a1address

where a1~-sort_no = p_sortno.

2 REPLIES 2
Read only

Go to solution
Former Member

‎2008 Jul 16 7:52 PM

0 Likes
418

Hi,

Use Joins:

select l1~lifnr from l1

inner join a1 on l1address = a1address

where a1~-sort_no = p_sortno.

Read only

Go to solution
Former Member

‎2008 Jul 16 8:05 PM

0 Likes
417

Are these Internal Tables, Transparent Tables, etc........... ?

If they are internal tables, a Select will not work. Use the SAP Help for the LOOP and READ Statements.