Monday 29 August 2011

Some SAP SD important tables


There are some tables which are important in sales and distribution .The relevant data are located in these tables. The tables given below:

MASTER DATA:

MATERIAL MASTER:

MARA            Material Master
MARD            Material Storage Location
MARC            Material per Plant/Stock
MSKA            Sales Order Stock

CUSTOMER MASTER:


KNA1             Customer Master
KNB1             Company Code
KNVV            Customer Sales Area
KNVP            Customer Partner
KNVH            Customer Hierarchy
KNVK           Contact Person


VENDOR MASTER DATA

LFA1              Vendor Master
LFB1               Vendor per Company code
LFM1              Purchasing Organization Data
LFM2              Purchasing Data

CUSTOMER MATERIAL INFO RECORD:

KNMT                        Customer Material Info Record



SALES DOCUMENT DATA:

HEADER

VBAK            Sales Document: Header Data
VBKD            Sales Document: Business Data
VBPA             Partner
VBFA             Sales Document Flow
NAST             Output            
VBUV             Incompletion Log
VBUK             Header Status

ITEM

VBUP             Item Status
VBAP             Sales Document: Item Data
VBKD            Sales Document: Business Data
VBUV            Incompletion log
VBFA             Document Flow
VBPA             Partner
KONV           Conditions
NAST             Output

SCHEDULE LINE

VBEP              Sales Document: Schedule line


DELIVERY:

HEADER

LIKP               Delivery Header Data

ITEM

LIPS                Delivery Item Data

BILLING:

HEADER

VBRK             Billing Header Data

ITEM

VBRP             Billing Item Data  



N:B: This is  important in interview purpose.