Cannot join tables because Data in Columns : resb.sermat and resb.banfn fully blank

1 week ago 6

Hi everyone, In Tcode -IW39, I americium trying to articulation the beneath tables to get information from the component. but I got an contented with file resb.sermat and resb.banfn is afloat blank.
So what should I request to bash to articulation these tables?
Best Regards

(from exsch_sap.ext_afih afih

left join exsch_sap.ext_aufk aufk on afih.mandt = aufk.mandt and afih.aufnr = aufk.aufnr

left join exsch_sap.ext_afko afko on aufk.mandt = afko.mandt and aufk.aufnr = afko.aufnr

left join exsch_sap.ext_iloa iloa on afih.mandt = iloa.mandt and afih.iloan = iloa.iloan)

left join exsch_sap.ext_resb resb on viaufks.mandt = resb.mandt and viaufks.swerk = resb.werks and viaufks.rsnum = resb.rsnum and viaufks.swerk = resb.werks

left join exsch_sap.ext_eban eban on viaufks.mandt = eban.mandt and eban.matnr = resb.matnr and eban.arsps = resb.rspos

left join exsch_sap.ext_eket eket on viaufks.mandt = eket.mandt and eban.bnfpo = eket.bnfpo and eban.banfn = eket.banfn)

Read Entire Article