表名和解释:
OBBQ为库存表
OBIN库位表
OBTN批次表
OWHS 仓库表
OITM物料主数据
此sql语句为HANA sql
SELECT T0."ItemCode", T4."ItemName" AS "物料名称",T4."U_Z20_SPEC",T4."U_CHXH",T2."DistNumber" "批次号"
,sum(T0."OnHandQty") AS "库存", T4."InvntryUom" AS "库存单位", T0."WhsCode", T3."WhsName" AS "仓库名称"
,T1."BinCode" AS "库位",T1."AbsEntry" "库位编号"
FROM OBBQ T0
INNER JOIN OBIN T1 ON T0."BinAbs"=T1."AbsEntry"
INNER JOIN OBTN T2 ON T0."SnBMDAbs"=T2."AbsEntry"
INNER JOIN OWHS T3 ON T3."WhsCode"=T0."WhsCode"
INNER JOIN OITM T4 ON T4."ItemCode"=T0."ItemCode"
group by T0."ItemCode", T4."ItemName"
,T4."InvntryUom", T0."WhsCode", T3."WhsName"
,T1."BinCode",T4."U_Z20_SPEC",T4."U_CHXH",T2."DistNumber",T1."AbsEntry"
HAVING IFNULL(sum(T0."OnHandQty"),0) > 0