Select data from three tables

[Former Member]

Hi,

Tables :PROJ-JEST-TJ30T Target Field:TXT04

PROJ-PSPNR--> PROJ-OBJNR =JEST-OBJNR + JEST-INACT = «blank»

JEST-STAT = (TJ30T-ISTAT = E* (we have to take only E*)+ TJ30T-SPRAS = EN) -->TJ30T-TXT04

We can have some status to display here, please concatenate and separate them by a coma.

can you give me suggestion to fill that requirement?

Regards

Subbu

[andreas_mann3]

sth like this:

SELECT

P~pspnr...

INTO CORRESPONDING FIELDS OF itab

FROM ( proj AS p INNER JOIN jest AS J

ON P_{OBJNR = J}OBJNR )

join TJ30T as t

on T~ISTAT = J-TSTAT

WHERE T~spras = 'EN'

and T~ISTAT like 'E%'.....

A.