Hi Gems,
I had wriiten two queries as below. Can somene tell me how do i combine the below 2 quesries into one using table aliasing or any other way?
get the func location
IF NOT IT_BUS[] IS INITIAL.
SELECT TPLNR IWERK
FROM IFLOT
INTO CORRESPONDING FIELDS OF TABLE IT_TECH
FOR ALL ENTRIES IN IT_BUS[]
WHERE TPLNR = IT_BUS-HAUS
AND FLTYP EQ 'C'.
IF IT_TECH[] IS NOT INITIAL.
obtain the Superior Func location(TPLMA) again from IFLOT
SELECT TPLNR TPLMA IWERK
FROM IFLOT
INTO CORRESPONDING FIELDS OF TABLE IT_TECH2
FOR ALL ENTRIES IN IT_TECH[]
WHERE TPLMA = IT_TECH-TPLNR
AND IWERK = P_WERKS
AND FLTYP = 'L'.
Please suggest.
thanks
Dan
Bluesky
