select query the same variable different table problem

Hi friends,

By 6 table inner join , take the data . My problem CRDAT and CRUZT always coming from ZQM_T001 . I don't understand why that.

Already thanks for your help.

SELECT DISTINCT ZPP_T004~CRDAT SNAME ZPP_T004~CRUZT ARBPL ZPP_T004~MATNR MAKTX ZTBARKOD BARKOD ZTELCAP1 ZTELCAP2 ZMUKAVEMET ZBURMA ZHIZ LOW HIGH ZPARTI ZSABUN ZDRESAJ ZACIKLAMA

ZPP_T004~AUFNR KANTAR KADET SEPET BRAGR NTAGR TEYIT ZQM_T001~CRDAT ZQM_T001~CRUZT

INTO CORRESPONDING FIELDS OF TABLE gt_tablo UP TO SAYI ROWS FROM ZQM_T001

INNER JOIN ZPP_T004 ON ZQM_T001~ZTBARKOD = ZPP_T004~CHARG

INNER JOIN MAKT ON ZPP_T004~MATNR = MAKT~MATNR

INNER JOIN AUFK ON ZPP_T004~AUFNR = AUFK~AUFNR

INNER JOIN PA0001 ON ZPP_T004~PERNR = PA0001~PERNR

INNER JOIN ZPP_T001 ON ZPP_T001~MKVNO = AUFK~MKVNO

"FOR ALL ENTRIES IN TAB_ZQM_T001 WHERE ZQM_T001~ZTBARKOD = TAB_ZQM_T001-ZTBARKOD

where ZTBARKOD IN TBARKOD AND ZPP_T004~CRDAT IN KKTARIH AND ZPP_T004~CRUZT IN KKSAAT

AND BARKOD IN KBARKOD AND ZPP_T004~AUFNR IN SIPNO AND ZPP_T004~MATNR IN MALZNO AND ZPARTI IN PARTINO

AND SNAME IN URTPERNO AND ZQM_T001~CRDAT IN TRTMTAR AND ZQM_T001~CRUZT IN TRTMSAAT .