SQLalchemy text() query with multpile JOINS over 6 tables not returning any rows

Question

Keep in mind all these tables exist in my database, and are populated. I tried seeing if it's a join problem but as far as i've seen in SQLalchemy docs, only natural JOIN is available in their text() implementation.

In Mysql workbench I see that the view RECEIPT exists but only the headers are there (I guessed from the select but why would the query go through if there's no data coming),

which left me to my final and most simple solution that is my WHERE clauses are simply filtering all data.

I then tried to remove some of my Where clauses even if i'll have hundreds of thousands of rows, but still no data

db.execute(text(f"""
        create view RECEIPT as 
            SELECT 
                `{DATABASE_CONFIG['database']}`.`EKBE`.`BELNR` AS `BELNR`,
                `{DATABASE_CONFIG['database']}`.`EKBE`.`BUZEI` AS `BUZEI`,
                `{DATABASE_CONFIG['database']}`.`EKPO`.`EBELN` AS `EBELN`,
                `{DATABASE_CONFIG['database']}`.`EKPO`.`EBELP` AS `EBELP`,
                `{DATABASE_CONFIG['database']}`.`EKBE`.`MATNR` AS `MATNR`,
                `{DATABASE_CONFIG['database']}`.`EKBE`.`MENGE` AS `EKBE_MENGE`,
                `{DATABASE_CONFIG['database']}`.`EKBE`.`BLDAT` AS `BLDAT`,
                `{DATABASE_CONFIG['database']}`.`EKET`.`SLFDT` AS `SLFDT`,
                `{DATABASE_CONFIG['database']}`.`T001`.`BUKRS` AS `BUKRS`,
                `{DATABASE_CONFIG['database']}`.`T001`.`BUTXT` AS `BUTXT`,
                `{DATABASE_CONFIG['database']}`.`T001W`.`WERKS` AS `WERKS`,
                `{DATABASE_CONFIG['database']}`.`T001W`.`NAME1` AS `NAME1`,
                `{DATABASE_CONFIG['database']}`.`T001W`.`LAND1` AS `LAND1`,
                `{DATABASE_CONFIG['database']}`.`LFA1`.`NAME1` AS `LFA1_NAME1`,
                `{DATABASE_CONFIG['database']}`.`LFA1`.`LAND1` AS `LFA1_LAND1`,
                `{DATABASE_CONFIG['database']}`.`LFA1`.`LIFNR` AS `LIFNR`,
                `{DATABASE_CONFIG['database']}`.`EKPO`.`MENGE` AS `EKPO_MENGE`,
                (`{DATABASE_CONFIG['database']}`.`EKBE`.`BLDAT` > `{DATABASE_CONFIG['database']}`.`EKET`.`SLFDT`) AS `late` 
            FROM `{DATABASE_CONFIG['database']}`.`LFA1` 
                JOIN `{DATABASE_CONFIG['database']}`.`EKKO` 
                JOIN `{DATABASE_CONFIG['database']}`.`EKPO` 
                JOIN `{DATABASE_CONFIG['database']}`.`T001` 
                JOIN `{DATABASE_CONFIG['database']}`.`T001W` 
                JOIN `{DATABASE_CONFIG['database']}`.`EKBE` 
                JOIN `{DATABASE_CONFIG['database']}`.`EKET` 
            WHERE (
                (`{DATABASE_CONFIG['database']}`.`LFA1`.`LIFNR` = `{DATABASE_CONFIG['database']}`.`EKKO`.`LIFNR`)  AND
                (`{DATABASE_CONFIG['database']}`.`EKKO`.`EBELN` = `{DATABASE_CONFIG['database']}`.`EKPO`.`EBELN`)  AND
                (`{DATABASE_CONFIG['database']}`.`EKPO`.`WERKS` = `{DATABASE_CONFIG['database']}`.`T001W`.`WERKS`)  AND
                (`{DATABASE_CONFIG['database']}`.`EKPO`.`EBELN` = `{DATABASE_CONFIG['database']}`.`EKBE`.`EBELN`)  AND
                (`{DATABASE_CONFIG['database']}`.`EKPO`.`EBELN` = `{DATABASE_CONFIG['database']}`.`EKET`.`EBELN`)  AND
                (`{DATABASE_CONFIG['database']}`.`EKPO`.`BUKRS` = `{DATABASE_CONFIG['database']}`.`T001`.`BUKRS`)
            )
        """))