SD的重要的資料表

[@more@]

1、重要表列表
表 說明
組織結構 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.