fething fields from SD tables

[anupam_srivastava2]

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

[former_member667836]

Hi AJ,

you cannt link this table directly.you have to link like this

VBAK->VBAP->LIPS->VBRP

1.Take VBAK-VBELN and link with VBAP-VBELN

2.Then LInk VBAP-VBELN = LIPS-VGBEL and

VBAP-POSNR = LIPS-VGPOS

3.Then link LIPS-VBELN = VBRP-VGBEL and

LIPS-POSNR = VBRP-VGPOS

Hope you can make out from this.if not lemme know

Cheers

Shibu Kurian

Edited by: shibuettickal on Feb 12, 2008 5:43 PM