Hi
Below is the code
SELECT T1."DocNum",T1."DocEntry",
(Select "Location" from OLCT where "Code" = (Select Max(A0."LocCode") from PCH1 A0
inner join OPCH A1 On A0."DocEntry" = A1."DocEntry"
where A0."DocEntry" = T1."DocEntry" and A1."BPLId" = T2."BPLId"
)) As "Location"
FROM OJDT T0 inner join JDT1 T2 on T0."TransId" = T2."TransId"
inner join VPM2 T1 On T1."DocNum" = T2."CreatedBy"
group by T2."BPLId"
Thanks