Tables in sap

[Former Member]

From which table we can know the information about all the tables used in SD?

Is there any good link to understand the relation between all the tables?

[Former Member]

Hi Jayati,

Check this one:

[Relation Between Tables|http://www.erpgenie.com/abap/tables.htm]

Regards,

Chandra Sekhar

[Former Member]

Hi,

Search in SDN u can get lots.....

thanks,

[Former Member]

Hi,

Try these tables

DD02L--->All tables and its details.

TADIR---> for all the list of Program names

T100----->All text messages

You can go to Se11 and check all tables starting with D for SAP tables

Regards,

Linda

[Former Member]

Hi,

Please use the link below it might help you.

http://abaplovers.blogspot.com/2008/02/table-description-vbakuk-sales-document.html

with regards,

venkatesh.H.N

[Former Member]

Hi,

Check this link

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

Regards

Abhijeet

[Former Member]

Hi,

If you want to see the tables in SAP you can go for se16 and if you want to know the relationship for one particular table with other tables you can also get threw views go for se11 and select view and go for database view enter table name here and select relationships then u can get a pop up showing relationships with the base table..

with regards

diwakar

[Former Member]

hi,

refer to this link

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

[Former Member]

Hi,

Important Tables for SAP SD

Sales and Distribution:

Table Description

Customers KNA1 General Data

KNB1 Customer Master u2013 Co. Code Data (payment method, reconciliation acct)

KNB4 Customer Payment History

KNB5 Customer Master u2013 Dunning info

KNBK Customer Master Bank Data

KNKA Customer Master Credit Mgmt.

KNKK Customer Master Credit Control Area Data (credit limits)

KNVV Sales Area Data (terms, order probability)

KNVI Customer Master Tax Indicator

KNVP Partner Function key

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

Sales Documents VBAKUK VBAK + VBUK

VBUK Header Status and Administrative Data

VBAK Sales Document - Header Data

VBKD Sales Document - Business Data

VBUP Item Status

VBAP Sales Document - Item Data

VBPA Partners

VBFA Document Flow

VBEP Sales Document Schedule Line

VBBE Sales Requirements: Individual Records

SD Delivery DocumeLIPS Delivery Document item data, includes referencing PO

LIKP Delivery Document Header data

Billing Document VBRK Billing Document Header

VBRP Billing Document Item

SD Shipping Unit VEKP Shipping Unit Item (Content)

VEPO Shipping Unit Header

Regards,

Manish

Edited by: MANISH GUPTA on Sep 9, 2008 12:20 PM

Edited by: MANISH GUPTA on Sep 9, 2008 12:21 PM

[Former Member]

use Tcode: SE84

ABAP dictionary --> Database tables --> enter the package (VA for sales) and execute.

[Former Member]

HI Jayathi,

Check this link:-

[SAP Tables Relation|http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF]

Best of luck,

Bhumika