topic Re: Select Statement Query in Application Development and Automation Discussions

Select Statement Query

Former Member — Mon, 16 Jul 2007 14:08:29 GMT

Hi,

I need to perform the following selection:

a. Based on Position Number -> select associate Pernr from PA0001

b. based on this Pernr find value of STAT2 in PA0000.

Is there an efficient way of carrying out this selection other than using 2 Select Statements?

Note Pernr field is a primary key in both tables.

Former Member — Mon, 16 Jul 2007 14:12:22 GMT

select pa0001~<associate pernr> from pa0001

inner join pa0000 on pa0001_{pernr = pa0000}pernr

into table itab

where pa0001~<position number> = <Selection for position number>.

Regards,

Ravi

Former Member — Mon, 16 Jul 2007 14:13:53 GMT

Hi,

I think you can use a join to do it.

Thanks,

Sandeep.

Former Member — Mon, 16 Jul 2007 14:14:34 GMT

How about using join statement:

Since PERNR is a key field in both tables;

SELECT P0~STAT2

INTO TABLE <itab>

FROM PA0001 AS P1 INNER JOIN PA0000 AS P0

ON P1_{PERNR = P0}PERNR

WHERE <position number condition>

Regards,

A.Singh