Skip to Content
0
Former Member
Feb 12, 2008 at 03:50 PM

Fetching data from SD tables

261 Views

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