http://wiki.sdn.sap.com/wiki/display/ERPLO/Important+tables+in+SD
Customers
KNA1 : General Data
KNB1 : Customer Master–CCode Data (payment method, recon. acct)(公司代碼)
KNB4 : Customer Payment History
KNB5 : Customer Master – Dunning info
KNBK : Customer Master Bank Data
KNKA : Customer Master Credit Mgmt.
KNKK : Customer Master CCA Data (credit limits)(信貸限額、應收總額、特別往來)
KNVV : Sales Area Data (terms, order probability)(銷售視圖)
KNVI : Customer Master Tax Indicator
KNVP : Customer master partner Function (合作夥伴)
KNVD : Output type
KNVS : Customer Master Ship Data
KLPA : Customer/Vendor Link
KNVH : Customer Hierarchies
KNVK : Customer master Contact partner
V_THIT : Customer Hierarchy Types
S066 : Open Order - Credit Management (未清訂單值)
S067 : Open deliveries/billing documents (KM)(未清交貨值)
Accounting
BSEG : Accounting Document Segment (財務憑證行專案)
BSAD : Accounting Secondary Index for Customers (Cleared Items)(應收明細客戶(已清帳))
BSAS : Accounting Secondary Index for G/L Accounts (Cleared Items)(總帳明細總帳(已清帳))
BSIS : Accounting Secondary Index for G/L Accounts (總帳明細總帳(未清帳))
BSAK : Accounting Secondary Index for Vendors (Cleared Items) (應付明細供應商(已清帳))
BSIK : Accounting: Secondary Index for Vendors (應付明細供應商(未清帳))
BSID : Accounting - Secondary Index for Customers (應收明細客戶(未清帳))
KNKK的應收值要和BSID比對，S066 & S067不同時需重組。
Sales Documents
VBAKUK : VBAK + VBUK
VBUK : Header Status and Administrative Data (抬頭狀態)
VBAK : Sales Document – General Header Data
VBKA : Sales Activities
VBKD : Sales Document - Business Header/Item Data (業務資料)
VBPA : Sales Document - Partners Header Data (夥伴)
VBUP : Item Status (行項狀態)
VBAP : Sales Document – General Item Data (行項)
FPLA : sales Document – Items Conditions data
VBFA : Document Flow (單據流)
VBEP : Sales Document Schedule Line (計畫行)
VBBE : Sales Requirements: Individual Records
VEDA : Sales Contract Data
VBELN : Sales and Distribution Document Number
SD Delivery
LIPS : Delivery Document item data, includes refer. PO (行項)
LIKP : Delivery Document Header data (抬頭)
Billing Document
VBRK : Billing Document Header (抬頭)
VBRP : Billing Document Item (行項)
Pricing Document
KONP : Conditions Item
KONV : Condition for Transaction Data
Shipping Unit
VEKP : Shipping Unit Header
VEPO : Shipping Unit Item
Transportation
VTTK : Shipment Header (Shipment抬頭)
VTTP : Shipment Item (Shipment行項)
TVRO : Routes
TVTK : Shipment Types
VTRLK : Delivery in shipment: Header
Sales Documents Copy Control Tables
TVAK : Sales Document Types
T184 : Sales Documents: Item Category Determination
TVCPA : Sales Documents: Copying Control
TVASP : Sales Documents: Blocking Reasons
TVCPL : Deliveries: Copying Control
TVCPF : Billing: Copying Control
TVFSP Billing: Blocking Reasons
Sales Documents Item Categories Copy Control Tables
TVAPT : Sales document item categories: Texts
TVCPA : Sales Documents: Copying Control
TVCPF : Billing: Copying Control
TVCPL : Deliveries: Copying Control
TVEPZ : Sales Document: Schedule Line Category Determination
TVLP : Deliveries: Item Categories
TVPT : Sales documents: Item categories
Delivery Documents Copy Control Tables
T184L : Sales Documents: Item Category Determination
TVCPF : Billing: Copying Control
TVCPL : Deliveries: Copying Control
TVLSP : Delivery Blocks
SD Links to FI tables
KNVP : Customer Master Partner Functions
KNVV : Customer Master Sales Data
KNVD : Customer master record sales request form
KNA1 : General Data in Customer Master
KNB1 : Customer Master (Company Code)
KNB5 : Customer master (dunning data)
SD Links to MM tables
MARC : Plant data for material
MVKE : Sales data for material (銷售視圖)
MBEW : Material Valuation
MARD : Storage Location data for Material
T179 : Materials: product hierarchy
MLAN : Tax classification for material
MAKT : material description (物料描述)
MARA : General material data (基本資料)
MARM : Units of measure of material (物料計價單位)
MTART : Material Types
MKPF : Header - Material Document (抬頭)
MSEG : Document Segment - Material (行項)
SAP SD Structures
VBDKA : Document Header View for Inquiry, Quotation, Order
VBDPA : Document Item View for Inquiries, Quotation, Order
KOMK : Communication Header for pricing
KOMP : Communication Item for pricing
STXH : STXD SAPscript text file header (抬頭)
STXL : STXD SAPscript text file lines (行項)
ADRC : Addresses (Business Address Services)(最新的單據中的位址資訊)
Read More
Customers
KNA1 : General Data
KNB1 : Customer Master–CCode Data (payment method, recon. acct)(公司代碼)
KNB4 : Customer Payment History
KNB5 : Customer Master – Dunning info
KNBK : Customer Master Bank Data
KNKA : Customer Master Credit Mgmt.
KNKK : Customer Master CCA Data (credit limits)(信貸限額、應收總額、特別往來)
KNVV : Sales Area Data (terms, order probability)(銷售視圖)
KNVI : Customer Master Tax Indicator
KNVP : Customer master partner Function (合作夥伴)
KNVD : Output type
KNVS : Customer Master Ship Data
KLPA : Customer/Vendor Link
KNVH : Customer Hierarchies
KNVK : Customer master Contact partner
V_THIT : Customer Hierarchy Types
S066 : Open Order - Credit Management (未清訂單值)
S067 : Open deliveries/billing documents (KM)(未清交貨值)
Accounting
BSEG : Accounting Document Segment (財務憑證行專案)
BSAD : Accounting Secondary Index for Customers (Cleared Items)(應收明細客戶(已清帳))
BSAS : Accounting Secondary Index for G/L Accounts (Cleared Items)(總帳明細總帳(已清帳))
BSIS : Accounting Secondary Index for G/L Accounts (總帳明細總帳(未清帳))
BSAK : Accounting Secondary Index for Vendors (Cleared Items) (應付明細供應商(已清帳))
BSIK : Accounting: Secondary Index for Vendors (應付明細供應商(未清帳))
BSID : Accounting - Secondary Index for Customers (應收明細客戶(未清帳))
KNKK的應收值要和BSID比對，S066 & S067不同時需重組。
Sales Documents
VBAKUK : VBAK + VBUK
VBUK : Header Status and Administrative Data (抬頭狀態)
VBAK : Sales Document – General Header Data
VBKA : Sales Activities
VBKD : Sales Document - Business Header/Item Data (業務資料)
VBPA : Sales Document - Partners Header Data (夥伴)
VBUP : Item Status (行項狀態)
VBAP : Sales Document – General Item Data (行項)
FPLA : sales Document – Items Conditions data
VBFA : Document Flow (單據流)
VBEP : Sales Document Schedule Line (計畫行)
VBBE : Sales Requirements: Individual Records
VEDA : Sales Contract Data
VBELN : Sales and Distribution Document Number
SD Delivery
LIPS : Delivery Document item data, includes refer. PO (行項)
LIKP : Delivery Document Header data (抬頭)
Billing Document
VBRK : Billing Document Header (抬頭)
VBRP : Billing Document Item (行項)
Pricing Document
KONP : Conditions Item
KONV : Condition for Transaction Data
Shipping Unit
VEKP : Shipping Unit Header
VEPO : Shipping Unit Item
Transportation
VTTK : Shipment Header (Shipment抬頭)
VTTP : Shipment Item (Shipment行項)
TVRO : Routes
TVTK : Shipment Types
VTRLK : Delivery in shipment: Header
Sales Documents Copy Control Tables
TVAK : Sales Document Types
T184 : Sales Documents: Item Category Determination
TVCPA : Sales Documents: Copying Control
TVASP : Sales Documents: Blocking Reasons
TVCPL : Deliveries: Copying Control
TVCPF : Billing: Copying Control
TVFSP Billing: Blocking Reasons
Sales Documents Item Categories Copy Control Tables
TVAPT : Sales document item categories: Texts
TVCPA : Sales Documents: Copying Control
TVCPF : Billing: Copying Control
TVCPL : Deliveries: Copying Control
TVEPZ : Sales Document: Schedule Line Category Determination
TVLP : Deliveries: Item Categories
TVPT : Sales documents: Item categories
Delivery Documents Copy Control Tables
T184L : Sales Documents: Item Category Determination
TVCPF : Billing: Copying Control
TVCPL : Deliveries: Copying Control
TVLSP : Delivery Blocks
SD Links to FI tables
KNVP : Customer Master Partner Functions
KNVV : Customer Master Sales Data
KNVD : Customer master record sales request form
KNA1 : General Data in Customer Master
KNB1 : Customer Master (Company Code)
KNB5 : Customer master (dunning data)
SD Links to MM tables
MARC : Plant data for material
MVKE : Sales data for material (銷售視圖)
MBEW : Material Valuation
MARD : Storage Location data for Material
T179 : Materials: product hierarchy
MLAN : Tax classification for material
MAKT : material description (物料描述)
MARA : General material data (基本資料)
MARM : Units of measure of material (物料計價單位)
MTART : Material Types
MKPF : Header - Material Document (抬頭)
MSEG : Document Segment - Material (行項)
SAP SD Structures
VBDKA : Document Header View for Inquiry, Quotation, Order
VBDPA : Document Item View for Inquiries, Quotation, Order
KOMK : Communication Header for pricing
KOMP : Communication Item for pricing
STXH : STXD SAPscript text file header (抬頭)
STXL : STXD SAPscript text file lines (行項)
ADRC : Addresses (Business Address Services)(最新的單據中的位址資訊)