topic Re: Inner and out loop statement in Application Development and Automation Discussions

Inner and out loop statement

Former Member — Wed, 16 Jul 2008 18:49:23 GMT

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.

Former Member — Wed, 16 Jul 2008 18:52:33 GMT

Hi,

Use Joins:

select l1~lifnr from l1

inner join a1 on l1_{address = a1}address

where a1~-sort_no = p_sortno.

Former Member — Wed, 16 Jul 2008 19:05:44 GMT

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.