Hi All
I want the following fileds in my view.
1.Slaes doc- VBAK-VBELN
2.Created On-VBAK-ERDAT
3.Purch.Order No-VBAK-BSTNK
4.Ref1- VBAK-IHREZ
5.Sold to party- VBAK-KUNNR
6.Billing doc- VBRP-VBELN
7.Material- VBRP-MATNR
8.Originating doc- VBRP-VBELV
9.NetValue VBRP-NETWR
Is it possible to create relation between vbak and vbrp, if not how can I fetch these filed from other tables, relate them and create a view. Actualy I want to create a Sales Invoice, where I want to use Sales doc and Billing doc togather. The fileds which I required, I found in these tables, but I am not clear how I can relate these tables and create a view.
Please guide
cheers
AJ