Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Join 4 tables......

Hi Guys,

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.

MANDT Client

KUNNR Customer

VKORG Sales Organization

VTWEG Distribution Channel

SPART Division

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.....

Regards,

Ravi…

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question