Relation between SD tables

[anupam_srivastava2]

Hi All

I am developing a sales invoice. I want information for the following fields.

1. Invoice number - which is vbfa-vbeln

2. Sales Order Number - which is vbfa-vbelv

3. Document Date - which is vbfa-erdat

4. Customer Order - which is vbkd-bstkd

5. Our Reference - which is vbkd-ihrez

6 Customer No.- which is vbrk-kunrg

now I am getting the information from three diff tables vbfa vbkd vbrk, how can I create relation between these tables, OR is there are any other tables from where I can get the information.

As I am into ABAP and dont know much about SD tables, can any body help me with getting these information.

cheers

AJ

[Former Member]

Hey find the relationship between the table in erpgenie .com web site there you can find all the mapings between the tables

[Former Member]

Hi AJ,

Please go through the following link. You will find SD table link.

http://www.erpgenie.com/abap/tables_sd.htm

Regd,

Madhu

[Former Member]

Hi,

VBFA is not the table you should be using as its a Document Flow table.

You should be using VBAK - Sales order Header table for getting VBELN and ERDAT.

To access item level data for a sales order you can use VBAP and subsequently link table VBKD.

Look for the common field in both the tables to link.

Hope this helps

Edited by: Priyabrata Samanta on Feb 11, 2008 10:24 PM

[anupam_srivastava2]

Hi Priyabrata

As I am getting the fileds, Sales Order No, Doc date, Purchase Ord No, Ref, Customer No from table VBAK. But From Where I will be getting the Invoice No field, from which table.

I think that Invoice No is in table VBFA, so I have to link table VBAK and VBFA.

Can I do in this way.........

pls guide

AJ

[madhu_vadlamani]

Dear

Try to use VBRK to get document number .

Regards,

Madhu.

[anupam_srivastava2]

This message was moderated.