DEPENDENT TABLE VBAK is not coming while creating view using table VBAP
I am creating database view Joining VBAK & VBAP tables. But when clicking on 'Relationship' button there is no VBAK. Please suggest why VBAK is not showing in Dependent Table section.
Even though VBAK and VBAP are sales order header and itens, there's no direct relationship between then in the ABAP dictionary. The common key is from VBUK, and when you're creating a view, the dictionary detects only direct relationships, not indirect. So, the only way to include an automatic join is including table VBUK.