create table #TMP_PPB
(Nopo nvarchar (45),Kontrak nvarchar (45),
Metode nvarchar (45),Mulai datetime,Akhir datetime,
Perusahaan nvarchar (45),
UK nvarchar (5),USD numeric (19,6),IDR numeric (19,6),
Jenis nvarchar (45),Unit numeric(19,6),Satuan nvarchar (45),UnitPrice numeric(19,6),
Percentage nvarchar (15))

insert into #TMP_PPB
(Nopo,Kontrak,
Metode,Mulai,Akhir,
Perusahaan,UK,
USD,IDR,
Jenis,Unit,Satuan,UnitPrice,
Percentage)
exec
('select distinct a.u_pono,a.u_scopeofwork,
b.descr,a.taxdate,d.taxdate,
c.cardname,c.cardfname,
a.doctotal,a.doctotalfc,
e.dscription,e.quantity,
e.unitmsr,e.u_userprice,
f.sww
from opor a
full join ufd1 b on a.u_procmethod=b.fldvalue and b.fieldid=25
full join ocrd c on a.cardcode=c.cardcode
full join opdn d on a.u_pono=d.u_pono
inner join por1 e on a.docentry=e.docentry
inner join (select distinct a.docentry,a.itemcode,b.sww from por1 a
            inner join oitm b on a.itemcode=b.itemcode)f on a.docentry=f.docentry
')