SAP Batch Expiry Stock SQL Query Generator

SELECT b.MATNR,
       b.WERKS,
       b.LGORT,
       b.CHARG,
       m.LICHA AS VENDOR_BATCH,
       m.HSDAT AS MANUFACTURE_DATE,
       m.VFDAT AS EXPIRY_DATE,
       b.CLABS AS UNRESTRICTED,
       b.CINSM AS QUALITY_INSP,
       b.CSPEM AS BLOCKED
FROM SAPHANADB.MCHB AS b
INNER JOIN SAPHANADB.MCH1 AS m
        ON m.MANDT = b.MANDT
       AND m.MATNR = b.MATNR
       AND m.CHARG = b.CHARG
WHERE b.MANDT = '100'
  AND b.WERKS = '1000'
  AND m.VFDAT <> '00000000'
  AND m.VFDAT <= TO_VARCHAR(ADD_DAYS(CURRENT_DATE, 90), 'YYYYMMDD')
  AND (b.CLABS + b.CINSM + b.CSPEM) > 0
ORDER BY m.VFDAT, b.MATNR, b.CHARG;

SELECT b.MATNR,
       COUNT(DISTINCT b.CHARG) AS BATCH_COUNT,
       SUM(b.CLABS) AS UNRESTRICTED_QTY
FROM SAPHANADB.MCHB AS b
INNER JOIN SAPHANADB.MCH1 AS m
        ON m.MANDT = b.MANDT
       AND m.MATNR = b.MATNR
       AND m.CHARG = b.CHARG
WHERE b.MANDT = '100'
  AND b.WERKS = '1000'
  AND m.VFDAT <> '00000000'
  AND m.VFDAT <= TO_VARCHAR(ADD_DAYS(CURRENT_DATE, 90), 'YYYYMMDD')
GROUP BY b.MATNR
ORDER BY UNRESTRICTED_QTY DESC;