Understanding Sap Tables and their Relations ships

[Former Member]

Customer Details
Table	Descritpiion
KNA1	Customer master
KNVV	Customer sales data
KNVH	Customer hierarchy
KNVP	Customer partners
KNVK	Contact persons
ADRC	Addresses (Business Address Services)
ADR6	E-Mail Addresses (Business Address Services)
AUSP	Characteristic Values
CAWN	Characteristic values
CAWNT	Value Texts

Customer Details
Table	Descritpiion
KNA1	Customer master
KNVV	Customer sales data
KNVH	Customer hierarchy
KNVP	Customer partners
KNVK	Contact persons
ADRC	Addresses (Business Address Services)
ADR6	E-Mail Addresses (Business Address Services)
AUSP	Characteristic Values
CAWN	Characteristic values
CAWNT	Value Texts
Delivery Data
Table	Descritpiion
LIKP	SD Document: Delivery Header Data
LIPS	SD document: Delivery: Item data
VTTK	Shipment Header
VTTP	Shipment Item
VBPA	Sales Document: Partner
VBFA	Sales Document Flow
ZVTRLK	Shipment summary data
ZUOM_CASE	Define CASE unit of measures
LTAK	WM transfer order header
LTAP	Transfer order item
Inventory Management
Table	Descritpiion
MCHBH	Batch Stocks: History
MCHB	Batch Stocks
MSSA	Total Customer Orders on Hand
MSKA	Sales Order Stock
Invoice Details
Table	Descritpiion
VBRK	Billing Document: Header Data
VBRP	Billing Document: Item Data
VBPA	Sales Document: Partner
VBFA	Sales Document Flow
PA0027	HR Master Record: Infotype 0027 (Cost Distribution)
VBAK	Sales Document: Header Data
VBAP	Sales Document: Item Data
VBUK	Sales Document: Header Status and Administrative Data
VBUP	Sales Document: Item Status
Other Information
Table	Descritption
PA0001	HR Master Record: Infotype 0001 (Org. Assignment)
PA0002	HR Master Record: Infotype 0002 (Personal Data)
TVTWT	Organizational Unit: Distribution Channels: Texts
T151T	Customers: Customer groups: Texts
T171T	Customers: Sales districts: Texts
TVSTT	Organizational Unit: Shipping Points: Texts
T179T	Materials: Product hierarchies: Texts
TVZBT	Customers: Terms of Payment Texts
TVGRT	Organizational Unit: Sales Groups: Texts
T023T	Material Group Descriptions
TVAUT	Sales Documents: Order Reasons: Texts
T001L	Storage Locations
Payment History
Table	Descritpiion
BSID	Accounting: Secondary Index for Customers
BSAD	Accounting: Secondary Index for Customers (Cleared Items)
KNB4	Customer Payment History
Product Details
Table	Descritpiion
MARA	General Material Data
MAKT	Material Descriptions
MARC	Plant Data for Material
MBEW	Material Valuation
MARD	Storage Location Data for Material
MARM	Units of Measure for Material
MVKE	Sales Data for Material
A920	Sales org./Customer/Material/Sales unit
A923	Sales org./Ship-to/Material/Sales unit
A911	Sales org./Distr. Chl/Customer/Material/Sales unit
A914	Sales org./Material/Sales unit
KONH	Conditions (Header)
KONP	Conditions (Item)
Zone/Transportaation Details
Table	Descritpiion
ZROUTE_TZONES	Transportation zone for route ID
ZVROUTE	Maintenance route schedule
ZVTZONE	Maintenance transport zone
ZVROUTE_TZONES	Maintenance view route schedule with t.zone
ZZONE_TIME	Travel time between zones

[Former Member]

Please help me out how to classify the master data and transaction data from above tables.

please let me know any kind of information.

Regards,

vishnu

[giri_ayyagari]

Hi Vishnu

look at this thread would help.. 

-Giri

[Former Member]

Thanks for your answer.

     Here i couldn't find complete information of all SAP Tables which i mentioned in main thread.

-vishnu