11-20-2008 12:13 AM
Hi Gems,
I need to write a select query in IFLOT table to display fields TPLMA(superior Loc) & TPLNR(Func location_.
This is based on 2 inputs in where clause like:
a) the field TPLNR = somve value
where IWERK EQ 'DGMT'
AND FLTYP EQ 'L'.
b) the field TPLMA = value of TPLNR.
How do i write this.? Do i need to do using table aliasing?
Is the one below correct?
SELECT TPLNR IWERK TPLMA
FROM IFLOT
INTO CORRESPONDING FIELDS OF TABLE IT_TECH
FOR ALL ENTRIES IN IT_BUS[]
WHERE TPLMA = IT_BUS-HAUS
AND IWERK EQ 'DGMT'
AND FLTYP EQ 'L'.
Please suggest.
Thanks
Dan
11-20-2008 5:48 AM
SELECT TPLNR TPLMA IWERK
FROM IFLOT
INTO CORRESPONDING FIELDS OF IT_TECH
FOR ALL ENTRIES IN IT_BUS
WHERE TPLMA = IT_BUS-HAUS
AND FLTYP EQ 'L'
AND IWERK EQ 'DGMT'.
Try like this
Regards,
Shiva Kumar
11-20-2008 2:57 PM
11-21-2008 5:38 AM
Yes.It is correct but change the order in the select and the where condition.
11-21-2008 6:53 PM
Hi Shiva Kumar,
I am sorry ....actually i had wriiten two queries as below. Can you tell me how do i combine this into one query?
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
Dany
11-24-2008 8:11 AM
We can't combine these 2 queries in to 1 query.
If you see the table you will get to know.
As you menctioned your queries are correct.
Let me know if you need any more information.
Regards,
Shiva Kumar
11-28-2008 1:09 AM