SAP Tables

[Former Member]

Hi,

Can anybody tell me what all are the main delivery info tables in SAP And I would like to know if there is any way I can find out what all r the main tables in sap for a particular catagory like delivery, shipping, invoice etc.

kelly

[Former Member]

Hi,

Can anybody tell me what all are the main delivery info tables in SAP And I would like to know if there is any way I can find out what all r the main tables in sap for a particular catagory like delivery, shipping, invoice etc.

kelly

[RichHeilman]

Delivery tables:

LIKP

LIPS

Shipment tables:

VTTK

VTTP

VTTS

Regards,

Rich Heilman

[juan_suros]

Tables EIKP, EIPO, and VBFA are also important.

The best way to find relevant tables is to use the document viewing transactions (eg. VF03N for Delivery notes) and use F1 and then the "Technical information" button on individual fields to see where the data is coming from.

[Former Member]

Another option is to enter transaction se16, drop the table name down, then select "SAP Apllications" you can then browse the various applications to see which tables are associated with them.

There are also a couple of visios out there with table information on them. One of them i created, and will send it to you if you want. When i was learning SAP, i put together ERDs for each of the various areas as i was learning it.

[Former Member]

Hi,

That would be great if you could send me that David. you can send that in my id [email protected].

And Thanx Everybody ..I also want to know what all r the important invoice tables.

Kelly

[Former Member]

Hi Kelly,

For invoices, you need to differentiate between SD invoices, vendor invoices and FI invoices.

SD invoice tables are VBRK and VBRP. Vendor and FI invoices are nothing but accounting documents and can be obtained from BKPF and BSEG.

It will be sometimes easy to go to SE80, enter the program name of the corresponding transaction(say SAPMV45A for VA01). Then you will see the entire break-down list of the objects used within this program. One such branch is the list of dictionary objects used in the program. In all probability you will get majority of the tables here. But if they call some function module within here, then the main program of the function module needs to be investigated for table accesses.

Regards,

Srinivas