SAP Equipment and Functional Location SQL Query Generator

SELECT e.EQUNR,
       k.EQKTX AS DESCRIPTION,
       e.EQTYP,
       e.EQART,
       l.TPLNR AS FUNCTIONAL_LOCATION,
       l.SWERK AS MAINT_PLANT
FROM EQUI e
INNER JOIN EQUZ z
        ON z.MANDT = e.MANDT
       AND z.EQUNR = e.EQUNR
       AND z.DATBI = '99991231'
INNER JOIN ILOA l
        ON l.MANDT = z.MANDT
       AND l.ILOAN = z.ILOAN
LEFT JOIN EQKT k
        ON k.MANDT = e.MANDT
       AND k.EQUNR = e.EQUNR
       AND k.SPRAS = 'E'
WHERE e.MANDT = '100'
  AND e.EQTYP = 'M'
  AND l.SWERK = '1000'
  AND l.TPLNR LIKE 'PLANT1-LINE2%'
ORDER BY l.TPLNR, e.EQUNR;

SELECT e.EQUNR, k.EQKTX AS DESCRIPTION, l.SWERK
FROM EQUI e
INNER JOIN EQUZ z
        ON z.MANDT = e.MANDT AND z.EQUNR = e.EQUNR AND z.DATBI = '99991231'
INNER JOIN ILOA l
        ON l.MANDT = z.MANDT AND l.ILOAN = z.ILOAN
LEFT JOIN EQKT k
        ON k.MANDT = e.MANDT AND k.EQUNR = e.EQUNR AND k.SPRAS = 'E'
WHERE e.MANDT = '100'
  AND l.SWERK = '1000'
  AND (l.TPLNR IS NULL OR l.TPLNR = '')
ORDER BY e.EQUNR;

SELECT l.TPLNR, COUNT(*) AS EQUIPMENT_COUNT
FROM EQUZ z
INNER JOIN ILOA l
        ON l.MANDT = z.MANDT AND l.ILOAN = z.ILOAN
WHERE z.MANDT = '100'
  AND z.DATBI = '99991231'
  AND l.SWERK = '1000'
  AND l.TPLNR LIKE 'PLANT1-LINE2%'
GROUP BY l.TPLNR
ORDER BY EQUIPMENT_COUNT DESC;