topic Re: finding tables for fields in Application Development and Automation Discussions

finding tables for fields

Former Member — Mon, 18 Dec 2006 06:37:58 GMT

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>

Re: finding tables for fields

Former Member — Mon, 18 Dec 2006 06:39:27 GMT

Hi Praveen,

Check the following link

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

Hope this helps.

Regards,

Kinshuk

Re: finding tables for fields

Former Member — Mon, 18 Dec 2006 06:57:20 GMT

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

Re: finding tables for fields

p291102 — Mon, 18 Dec 2006 10:28:31 GMT

Hi Praveen,

Check the following link

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

Regards,

Star Shankar