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
Showing results for 
Search instead for 
Did you mean: 

Inner and out loop statement

Former Member
0 Kudos
85

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

Former Member
0 Kudos
63

Hi,

Use Joins:

select l1~lifnr from l1

inner join a1 on l1address = a1address

where a1~-sort_no = p_sortno.

2 REPLIES 2

Former Member
0 Kudos
64

Hi,

Use Joins:

select l1~lifnr from l1

inner join a1 on l1address = a1address

where a1~-sort_no = p_sortno.

Former Member
0 Kudos
63

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.