Help for getting information from 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

[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]

Hi,

Please go through the following link

SD tables - http://www.erpgenie.com/abap/tables_sd.htm

Regd,

Madhu

[Former Member]

vbfa is sales document flow table.

if we pass sub sequent doc type as M then it it will give sales order and invoice details and sales order date.

for the selected sales order we can get details from VBKD.

sales order(vbeln) and items number(posnr) are the link between these two tables. from VBFA we are getting invoice number for the we can fetch customer no from vbrk.

otherwise

get the billing doument header and item details from VBRK and VBRP. in the VBRP table we will have Sales order number for the sales order get the details from VBKD.