topic Re: Relation between SD tables in Application Development and Automation Discussions

Relation between SD tables

anupam_srivastava2 — Mon, 11 Feb 2008 16:37:10 GMT

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

Re: Relation between SD tables

Former Member — Mon, 11 Feb 2008 16:41:49 GMT

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

Re: Relation between SD tables

Former Member — Mon, 11 Feb 2008 16:47:02 GMT

Hi AJ,

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

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

Regd,

Madhu

Re: Relation between SD tables

Former Member — Mon, 11 Feb 2008 16:53:25 GMT

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

Re: Relation between SD tables

anupam_srivastava2 — Tue, 12 Feb 2008 09:41:01 GMT

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

Re: Relation between SD tables

anupam_srivastava2 — Wed, 26 Jan 2011 16:50:04 GMT

This message was moderated.

Re: Relation between SD tables

madhu_vadlamani — Thu, 27 Jan 2011 07:28:20 GMT

Dear

Try to use VBRK to get document number .

Regards,

Madhu.