Join 4 tables......
Good morning. May I share the problem correlated to inner join for 4 tables? One custom table, KNVV, VBAK and VBAP tables with me. I have the selection criteria for the following:
HKUNNR, KUNNR, VKORG, VTGEW, SPART, VKGRP, WERKS, MATNR and VBTYP.
I need to select VKGRP and KUNNR from KNVV and VBELN, POSNR from VBAP.
My custom table have fields for the following.
VKORG Sales Organization
VTWEG Distribution Channel
HKUNNR Customer number of the higher-level customer hierarchy
HITYP Customer hierarchy type
HILVL Customer Hierarchy Level (Customer or Buying Group)
KTOKD Customer Account Group
It was wondered for me that my query is showing the error. Please suggest me how can I approach to join these 4 tables. Your help will be greatly appreciate. Waiting ofr your valuable suggestions.....