finding tables for fields

[Former Member]

hello ! i am praveen

i need to know the tables and their relationships

for these fields :

<b>1) ship to party

2) bill to party

3)invoice no

4)invoice date

5)ref doc no<b>

[Former Member]

Hi Praveen,

Check the following link

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

Hope this helps.

Regards,

Kinshuk

[Former Member]

four main categories for a customer are

SOLD TO PARTY

SHIP TO PARTY

BILL TO PARTY

PAYER

i sell a product(assume im a vendor) to customer A ,

and now i need to see who is taking the product it may be A or his office in another location say B

so the product where it is to be shipped will be ship to party .

now since he has received the product he has to pay me the bill .

once he receives the product it will be sent with a invoice quoting the product qty and a price .

so i need to produce a bill to him saying that ur product costs so much and u need to pay me this amount . this is billing .

now to settle the bill he can do it or a Payer can do it .

this is just like combinations of the customers .

for ur understanding lets say sold to ,ship to, bill to , payeer are same .

u can find all the entries in table VBPA (bill to party and ship to party )

sales order in VBAk and VBAP , VBPA ..

delivery details In LIKP LIPS

invoice details IN VBRK VBRP (invoice number and invoice date )

reference document no will be a number on which a sales order is created .

(VBAK-VGBEL)

hope this helps ,

regards,

vijay

[p291102]

Hi Praveen,

Check the following link

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

Regards,

Star Shankar