2008 Jul 16 7:49 PM
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.
2008 Jul 16 7:52 PM
Hi,
Use Joins:
select l1~lifnr from l1
inner join a1 on l1address = a1address
where a1~-sort_no = p_sortno.
2008 Jul 16 7:52 PM
Hi,
Use Joins:
select l1~lifnr from l1
inner join a1 on l1address = a1address
where a1~-sort_no = p_sortno.
2008 Jul 16 8:05 PM
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.