Skip to Content

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

DEPENDENT TABLE VBAK is not coming while creating view using table VBAP

Hi Experts,

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.

Thanks,
Saquib

replied

Hi Saquib

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.

Regards

Luis Becker

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question