JOIN with a subquery

I have to SELECT a field (VBAK.AUDAT) and to get it I have to get another field from another table with a specific join and then join that result with the VBAK table VBELN field.

Like this:

SELECT VBAK.AUDAT 
FROM VBAK 
  WHERE VBAK.VBELN IN (SELECT VBFA.VBELV as VBELN_VA 
   FROM VBFA LEFT JOIN VBRK on VBRK.VBELN = VBFA.VBELN 
and VBFA.VBTYP_N = "C")

Any idea how I can integrate this query in the following query that already has different fields and joins?

SELECT
      ROW_NUMBER() OVER(ORDER BY VBRK.VBELN ASC) as ID,
      VBRK.VBELN,
      VBRK.FKART,
      VBRP.KVGR3,
      KNA1.NAME1,
      TVV3T.BEZEI
    FROM BW_VBRK VBRK
      LEFT JOIN BW_VBRP VBRP on VBRK.VBELN = VBRP.VBELN
      LEFT JOIN BW_KNA1 KNA1 on VBRK.KUNAG = KNA1.KUNNR
      LEFT JOIN BW_TVV3T TVV3T on VBRP.KVGR3 = TVV3T.KVGR3
    WHERE VBRK.FKART IN ("Z600","Z607","Z608","Z644","Z633","Z630","Z665")

Thank you

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum