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

本文引用的地址為 http://blog.csdn.net/CompassButton/archive/2006/08/15/1067476.aspx

總結

以上是生活随笔為你收集整理的SD的重要的数据表的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。