sql退货补货跟踪，样表显示的问题

问题描述：想追踪物料的退货补货，想把当天的格式更改箭头指定的表格式，SQL语句如何编写？

源代码编写如下：
alter PROCEDURE [dbo].[htbj_ddgz]
@BFDATE nvarchar(50),
@EFDATE nvarchar(50),
@ddbh nvarchar(50)
AS
BEGIN
declare @ddgh1 nvarchar(max);
declare @where nvarchar(1000) ='';
if(@ddbh<>'')
begin
set @where='and b.FBILLNO ='''+ @ddbh+''''
end
SET @ddgh1=N'SELECT b.FBILLNO as 采购订单编号,b.FDATE as 采购订单日期,d.FNAME as 供应商名称,e.FNUMBER as 物料编码,f.FNAME as 物料名称,f.FSPECIFICATION as 规格型号,a.FQTY as 采购订单数量,
g.FBILLNO as 入库单号 ,FREALQTY as 入库数量,l.FBILLNO as 退料单编号,FRMREALQTY*-1 as 退料数量
FROM t_PUR_POOrderEntry a --订单明细
left join t_PUR_POOrder b on a.FID=b.FID --订单表头
left join t_PUR_POOrderEntry_lk c on a.FENTRYID=c.FENTRYID --订单和入库单关联关系表
left join T_BD_SUPPLIER_L d on b.FSUPPLIERID=d.FSUPPLIERID --供应商
left join T_BD_MATERIAL e on a.FMATERIALID=e.FMATERIALID --物料编码
left join T_BD_MATERIAL_l f on e.FMATERIALID=f.FMATERIALID --物料名称
left join T_STK_INSTOCKENTRY_LK h on a.FENTRYID=h.FSID --入库单关联关系表
left join T_STK_INSTOCKENTRY i on h.FENTRYID=i.FENTRYID and a.FMATERIALID=i.FMATERIALID --入库单明细
left join T_STK_INSTOCK g on i.FID=g.FID --入库单表头
left join T_PUR_MRBENTRY_LK j on i.FENTRYID=j.FSID --退料单关联关系表
left join T_PUR_MRBENTRY k on k.FENTRYID=j.FENTRYID and a.FMATERIALID=i.FMATERIALID --退料单明细表
left join T_PUR_MRB l on k.FID=l.FID --退料单表头
where CONVERT(varchar(11),b.FDATE,120) > = CONVERT(varchar(11),'''+@BFDATE+''',120) and
CONVERT(varchar(11),b.FDATE,120) < = CONVERT(varchar(11),'''+@EFDATE+''',120) '+ @where+'
order by b.FBILLNO'
EXEC sp_executesql @ddgh1
END