Hi everyone, In Tcode -IW39, I am trying to join the below tables to get data from the component. but I got an issue with column resb.sermat and resb.banfn is fully blank.
So what should I need to do to join 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)
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.