Manufacturing Order Table in SAP: AUFK, AFKO, AFPO and RESB Join Generator

SELECT k.aufnr,
       k.auart,
       k.werks,
       k.ktext,
       h.gstrp  AS basic_start,
       h.gltrp  AS basic_finish,
       h.gamng  AS total_qty,
       p.matnr,
       p.psmng  AS planned_qty,
       p.wemng  AS delivered_qty,
       p.meins  AS uom
FROM   aufk k
       JOIN afko h
         ON h.mandt = k.mandt
        AND h.aufnr = k.aufnr
       JOIN afpo p
         ON p.mandt = k.mandt
        AND p.aufnr = k.aufnr
WHERE  k.mandt = '100'
  AND  k.werks = '1000'
  AND  k.auart = 'PP01'
  AND  h.gstrp BETWEEN '20260101' AND '20261231'
  AND  k.loekz = ''
ORDER BY k.aufnr;

SELECT k.aufnr,
       r.rspos,
       r.matnr  AS component,
       r.bdmng  AS required_qty,
       r.enmng  AS withdrawn_qty,
       r.meins  AS uom,
       r.lgort  AS storage_loc
FROM   aufk k
       JOIN afko h
         ON h.mandt = k.mandt
        AND h.aufnr = k.aufnr
       JOIN resb r
         ON r.mandt = h.mandt
        AND r.rsnum = h.rsnum
        AND r.aufnr = h.aufnr
WHERE  k.mandt = '100'
  AND  k.werks = '1000'
  AND  k.auart = 'PP01'
  AND  h.gstrp BETWEEN '20260101' AND '20261231'
  AND  r.xloek = ''
ORDER BY k.aufnr, r.rspos;

SELECT h.aufnr,
       v.vornr  AS operation,
       v.arbid  AS work_center_id,
       v.steus  AS control_key,
       v.ltxa1  AS op_text
FROM   afko h
       JOIN afvc v
         ON v.mandt = h.mandt
        AND v.aufpl = h.aufpl
WHERE  h.mandt = '100'
  AND  h.aufnr = :aufnr
ORDER BY v.vornr;