SD的重要的数据表

一、重要表列表
                     表     说明
组织结构     T001  Company Code
                     TVKO  Sales Organization
                    TSPA  DIvision
                   TVTW  Distribution Channel
                   TVTA  Sales Area
                   TVBUR Sales Office
                   TVGRP Sales Person Group
                   T001W Plant
                   TVST  Shipping Point
                   TVLA  Loading Point
                   T014  Credit Control Area 
 
客户              KNA1   General Data
                  KNB1   Customer Master – Co. Code Data (payment method, reconciliation acct)
                  KNB4   Customer Payment History
                  KNB5   Customer Master – 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
                                  
订单              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
注意：Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A, for Quotation 'B' & for Order it is 'C'.)

订单交货单        LIPS   Delivery Document item data, includes referencing PO
                  LIKP   Delivery Document Header data
注意：(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)

发票              VBRK   Billing Document Header
                  VBRP   Billing Document Item
注意：(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)

SD发运单位        VEKP   Shipping Unit Item (Content)
                  VEPO   Shipping Unit Header

2、业务流程TCODE列表
INQUIRY ( VA11)
|
QUOTATION (VA21)
|
PURCHASE ORDER (ME21)
|
ORDER CONFIRMATION (VA01)
|
PICKING LIST – (VL36)
|
PACKING LIST - (VL02, VL01)
|
SHIPPING – (VT01)
|
INVOICE – (VF21, VF01)
|
AR

3、各个业务对应表列表
sales order - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

Delivery - Transaction VL01N - Tables LIKP, LIPS, VBUK, VBUP.

Goods issue - Transaction VL02N - Tables MKPF, MSEG

Billing document - Transaction VF01 - Tables VBRK, VBRP.

Return order - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

Returns delivery - Transaction VL01N - Tables LIKP, LIPS, VBUK, VBUP.

Goods Receipt - Transaction VL02N - Tables MKPF, MSEG

Credit memo - Transaction VF01 - Tables VBRK, VBRP.

Customer wants some money back.

Credit memo request - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

Credit memo - Transaction VF01 - Tables VBRK, VBRP.

Customer was charged less money ..Meaning we want some money back from customer..

Debit memo request - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

Debit memo - Transaction VF01 - Tables VBRK, VBRP.