SD Tables

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

TEM Overview

OOEG : 建立訓練活動群組
OOET : 建立訓練活動類型 (含模式意謂是否為周期是循環)
PSV2 : 建立訓練活動日期
PSV1 : 人員報名

OOB1 :
OOBX :

Read More

Payroll results

Payroll results can be extracted using the following methods:
– If there is a need to do processing at individual steps:
1) Read cluster directory using 'CU_READ_RGDIR'
2) Read valid period from cluster directory using 'CU_READ_LAST'
3) Read payroll results using 'PYXX_READ_PAYROLL_RESULT'using SEQNO returned by 'CU_READ_LAST'.
– Otherwise:
1)Using function module 'PYXX_GET_EVALUATION_PERIODS'or
2)Using function module 'HR_GET_PAYROLL_RESULTS'to import current payroll results.


Since you are reading the payroll results of India, you have to change the declaration of 'payroll' as below
DATA:
payroll TYPE payin_result,

the current declaration
DATA:
payroll TYPE pay99_result,

Would only give you the international part of the payroll and you have to inform the FM that you only want to read the international part
through the importing parameter 'READ_ONLY_INTERNATIONAL'.
And 'CLUSTERID' is a optional parameter of the FM, if you don't feed any value to that it itself determines its value.

Read More

SD Transaction Codes

OV52 : Del.Customers Pre-Production Startup 刪除客戶預生產起動
OVH1 : C RV Tab. THIT Hierarchy Type C RV 表 THIT 分層類型
OVH2 : C SD Tab. THIZU AcctGrpAssignment C SD 表 THIZU 帳戶組分配
OVH3 : C RV Tab. THIOZ Org.assignments C RV 表 THIOZ 機構分配
V-12 : Create Customer Hierarchy Nodes 創建客戶層次結點
VAP1 : Create Contact Person 創建連絡人
VAP2 : Change Contact Person 修改連絡人
VAP3 : Display Contact Person 顯示連絡人
VD02 : Change Customer (SD) 修改客戶（SD）
VDDI : Customer: Dir. input currencies EMU 客戶：直接輸入貨幣 EMU
VDH1 : Customer Hierarchy Maintenance (SD) 客戶層次維護(SD)
VDH2 : Display Customer Hierarchy (SD) 顯示客戶層次（SD）
VPE1 : Create sales representative 創建銷售代表
VPE2 : Change sales representative 改變銷售代表
VPE3 : Display sales representative 顯示銷售代表
VPN1 : Number Range for Contact Person 連絡人的編號範圍
VS00 : SD Main Menu for Customer SD 客戶主功能表
XD07 : Change Customer Account Group 修改客戶帳戶組
OBYF : Revenue Account Determination 收入帳戶確定
OBD1 : Change View "Posting Date for Document Patking" Overview
OBD2 : Change View "Customer Account Groups" Overview
OV64 : Account determin. - rec. accounts 科目確定 - rec.科目
OV77 : Account determination -Cash accounts 科目確定 - 現金科目
OV87 : Credit card accounts 信用卡科目
OV97 : Accounts COPA project 科目COPA專案
VKOA : Accnt Determination 科目確定
VB01 : Create Material Listing/Exclusion 創建物料清單/排斥
VB02 : Change Material Listing/Exclusion 修改物料清單/排斥
VB03 : Display Material Listing/Exclusion 顯示物料清單/排斥
VB04 : Reference Material Listing/Exclusion 參考物料列表/排斥
VB11 : Create Material Substitution 創建物料替代
VB12 : Change Material Substitution 修改物料替代
VB13 : Display Material Substitution 顯示物料替代
VB14 : Reference Material Substitution 參考物料替代
VB21 : Create Sales Deal 創建銷售交易
VB22 : Change Sales Deal 修改銷售交易
VB23 : Create Sales Deal 創建銷售交易
VB25 : List of Sales Deals 銷售交易清單
VB31 : Create Promotion 創建促銷
VB32 : Change Promotion 修改促銷
VB33 : Display Promotion 顯示促銷
VB35 : List Promotions 列出促銷清單
VBN1 : Free goods - Create (SD) 免費貨物 - 建立(SD)
VBN2 : Free goods - Change (SD) 免費貨物 - 改變(SD)
VBN3 : Free goods - Display (SD) 免費貨物 - 顯示(SD)
VBO1 : Create Rebate Agreement 創建回扣協議
VBO2 : Change Rebate Agreement 修改回扣協議
VBO3 : Display Rebate Agreement 顯示回扣協定
VBOE : Currency conversion rebate agreemnts 貨幣轉換回扣協定
VCH1 : Create Batch Search Strategy 創建批查找策略
VCH2 : Change Batch Search Strategy 更改批查找策略
VCH3 : Display Batch Search Strategy 顯示批查找策略
VK01 : Conditions: Dialog Box for CondElem. 條件 : 條件要素對話方塊
VK03 : Create Condition Table 創建條件表
VK04 : Change Condition Table 修改條件表
VK05 : Display Condition Table 顯示條件表
VK11 : Create Condition 創建條件
VK12 : Change Condition 修改條件
VK13 : Display Condition 顯示條件
VK14 : Create Condition with Reference 創建具有參照的條件
VK15 : Create Condition 創建條件
VK16 : Change Condition 修改條件
VK17 : Display Condition 顯示條件
VK18 : Create Condition with Reference 創建具有參照的條件
VK19 : Change Condition Without Menu 無菜單修改條件
VK20 : Display Condition Without Menu 無功能表的顯示條件
VK30 : Maintain Variant Conditions 維護變式條件
VKVE : WFMC: WFMC:
VKVF : Conditions: Dialog Box for CondElem. 條件 : 條件要素對話方塊
VKVG : Maintain Condition Elements 維護條件要素
VKXX : Create Test for RKA 創建RKA檢測
VKYY : Change Test for RKA 修改RKA測試
VKZZ : Test for RKS-Surcharge Conditions RKS-附加費條件測試
VN03 : Number Assignment for Doc.Conditions 憑證條件的編號分配
VN04 : Number Assignment for Master Conds. 主條件編號分配
VOB3 : Display Plan/Actual Stat.Values 顯示計畫/實際情形估價
VOK0 : Conditions: Pricing in Customizing 條件： 客戶定價
XK11 : Create Condition 創建條件
XK12 : Change Condition 修改條件
XK13 : Display Condition 顯示條件
XK14 : Create with cond. ref. (cond. list) 建立有條件參考(條件清單)
XK15 : Create Conditions (background job) 創建條件（後臺作業）
OVA6 : Credit Groups for Document Types 單據類型的信貸組
OVA7 : Credit Relevancy of Item Categories 專案分類的信貸相關性
OVA8 : Automatic Credit Checks 自動信貸檢查
OVAD : Delivery Type Assignment 交貨類型發配
OVB5 : Req. for Creating a Purch.Requisit. 創建請購單需求
OVB6 : Requirement for Picking a Delivery 交貨揀配的需求
OVB7 : Requ. for Goods Issue of a Delivery 交貨的發貨請求
OVB8 : Criteria for Creating a Requirement 建立需求的標準
OVB9 : Create Delivery Due Index 創建交貨到期索引
OVBC : Documents Value Classes 憑證值等級
OVBD : Assign Credit Control Area 分配信貸控制範圍
OVFD : Forms of payment guarantee 付款擔保表格
OVFE : Payment guarantee procedure 付款擔保過程
OVFF : Control for payment guarantee proced 付款擔保過程的控制
OVFG : Customer payment guarantee procedure 客戶付款擔保過程
OVFH : Document payment guarantee procedure 憑證付款擔保過程
OVFI : Assign doc. payment guarantee proced 分配憑證付款擔保過程
OVFJ : Determine payment guarantee proced. 確定付款擔保過程
OVFL : Assign credit contrl area/sales area 指定信貸控制範圍/銷售範圍
VKM1 : Blocked SD Documents 凍結的SD文檔
VKM2 : Released SD Documents 已批准的SD憑證
VKM3 : Sales Document 銷售憑證
VKM4 : SD Documents SD 憑證
VKM5 : Delivery 交貨
OV/7 : Test Data for Data Transfer 資料傳輸的測試資料
OVA9 : /nse38/Handling Errors SchedAgrs /nse38/處理錯誤計畫協定
OVAI : /nse38/Determine Sold-to Party /nse38/確定售達方
OVAJ : /nse38/Distribution Function /nse38/分銷功能
OVBT : Modification Report Billing Plan 出具發票計畫報告修改
OVD0 : /nse38/Spec.Features EDL-LS-EDI /nse38/特殊特徵EDL-LS-EDI
OVD1 : /nse38/Special Billing Features /nse38/特殊開票特徵
OVT6 : View V_TVRL 視圖V_TVPL
OVS9 : Change View "Customer groups" Overview
V.10 : Display Top Materials 顯示主要物料
V.11 : Display Top Customers 顯示主要客戶
V.12 : Display Incoming Orders 顯示收進訂單
V.13 : Display Orders on Hand 顯示現有的訂單
V.14 : Display Blocked Orders 顯示凍結訂單
V.15 : Display Backorders 顯示拖欠訂單
V.16 : Selection of TOP and Incoming Orders 主要和新到訂單選擇
V.17 : Select Orders on Hand 選擇現有訂單
V_R1 : List of Backorders 拖欠訂單清單
V_RA : Backorder Processing: Selection List 拖欠訂單處理：選擇清單
V_V1 : Updating Unconfirmed Sales Documents 更新未確認銷售憑證
V_V2 : Updating Sales Documents by Material 按物料更新銷售憑證
V-01 : Create Sales Order 創建銷售訂單
V-02 : Create Quotation 創建報價
V101 : Initial Sales Menu 初始銷售菜單
VA00 : Initial Sales Menu 初始銷售菜單
VA01 : Create Sales Order 創建銷售訂單
VA02 : Change Sales Order 修改銷售訂單
VA03 : Display Sales Order 顯示銷售訂單
VA05 : List of Sales Orders 銷售訂單清單
VA07 : Sales/Purchasing Comparison 銷售/採購 比較
VA08 : Display: Compare Sales - Purchasing 顯示: 比較 銷售 - 採購
VA11 : Create Inquiry 創建詢價
VA12 : Change Inquiry 修改詢價
VA13 : Display Inquiry 顯示詢價
VA15 : List of Inquiries 詢價清單
VA21 : Create Quotation 創建報價
VA22 : Change Quotation 修改報價
VA23 : Display Quotation 顯示報價
VA25 : List of Quotations 報價清單
VA31 : Create Scheduling Agreement 創建計畫協議
VA32 : Change Scheduling Agreement 修改計畫協議
VA33 : Display Scheduling Agreement 顯示計畫協定
VA35 : List of Scheduling Agreements 計畫協定清單
VA41 : Create Contract 創建合同
VA42 : Change Contract 修改合同
VA42W : Workflow for master contract 主合同的工作流
VA43 : Display Contract 顯示合同
VA51 : Create Item Proposal 創建專案建議
VA52 : Change Item Proposal 修改專案建議
VA53 : Display Item Proposal 顯示專案建議
VA89 : Archiving of Settlement Documents 結算憑證的歸檔
VA90 : Billing Request for Actual Costs 實際成本的出據發票請求
VAKC : Items in Sales Order Configuration 銷售訂單配置中的專案
VAKP : Configuration: Maintain T180 配置： 維護T180
VD51 : Maintain Customer-Material Info 維護客戶-物料資訊
VD52 : Maintain Cust-Mat.Info w/Select.Scrn 維護帶選擇螢幕的客戶-物料資訊
VD53 : Display Customer-Material Info 顯示客戶-物料資訊
VD54 : Display Customer-Material Info 顯示客戶-物料資訊
VN01 : Number Assignment for SD Documents SD 憑證的編號分配
OVA0 : C_RV_Tab. VVVS "Status group" C_RV_Tab. VVVS "狀態組"
OVF3 : C_RV_Tab. VAUK "Cost Centers" C_RV_Tab. VAUK "成本中心"
OVK0 : C SD Table STE "Tax Categories" C SD 表 STE "稅種類"
OVL6 : C_RV_Tab. VUVS "Status Group Dely" C_RV_Tab. VUVS "狀態組延遲"
OVLM : C RV Tab. TROLZ "Route determ." C RV 表 TROLZ "路徑確定"
OVLU : c_rv_tab. vro "Transit time" c_rv_tab. vro "轉運時間"
OVR2 : c_rv_Tab. T016 "Sectors" c_rv_Tab. T016 "段"
SDPI : Number Range Maint.: SD_PICKING 編號範圍維護:SD_PICKING
V_SA : Collective Processing Analysis 匯總處理分析
V_UC : Incomplete SD Documents 不完整 SD 憑證
V633 : "Customer Conversion Dec.Shipping" "客戶轉換分散裝運"
VEGR : Material Group: Shipping Materials 物料組:裝運物料
VG01 : Maintain Groups "維護組"
VG02 : Maintain Groups "維護組"
VG03 : Display Groups "顯示組"
VGK1 : Create Group for Delivery "創建交貨組"
VGK2 : Change Group for Delivery "更改交貨組"
VGK3 : Display Group for Delivery 顯示交貨組
VGL1 : Create Group for Delivery "創建交貨組"
VGL2 : Change Group for Delivery "更改交貨組"
VGL3 : "Display Group for Delivery" "顯示交貨組"
VGM1 : "Create Group for Freight List" "創建運費清單組"
VGM2 : "Change Group for Freight List" "更改運費清單組"
VGM3 : "Display Group for Freight List" "顯示運費清單組"
VGW1 : Create Picking Wave 創建領貨波次
VGW2 : Change Picking Waves 改變領貨波次
VGW3 : Display Picking Waves 顯示領貨波次
VHZU : Allowed Shipping Material Types 允許的裝運物料類型
VL00 : Shipping 裝運
VL01 : Create Delivery 創建交貨
VL02 : "Change Delivery" "更改交貨"
VL03 : "Display Delivery" "顯示交貨"
VL04 : Process Delivery Due List 處理交貨到期清單
VL08 : Report Results of Picking Request 揀配請求的報表結果
VL09 : Cancel Goods Issue for Delivery Note 取消關於交貨通知單的發貨
VL10 : Extended Mult. Processing Deliveries 擴展多重粗略交貨
VL11 : "Create Decentralized Delivery" "創建分散交貨"
VL13 : "Create Deliveries in Dec.Shipping" "創建分散裝運交貨"
VL14 : Mail control decentralized shipping 郵件控制分散式發運
VL15 : Deliveries to Be Confirmed 待確認的交貨
VL16 : "Deliveries to be Picked" "待揀配的交貨"
VL17 : Deliveries to be Loaded 交貨被裝載
VL18 : "Dlvs.to be Scheduled for Transport" "待安排運輸的交貨"
VL19 : "Dlvs.Due for Goods Issue Posting" "發貨過帳的交貨到期"
VL20 : "Display Communication Document" "顯示通訊文檔"
VL21 : Post goods issue in background 在後臺記錄發出貨物
VL22 : Display Delivery Change Documents 顯示交貨改變憑證
VL32 : Change Delivery Notification 修改交貨通告
VL33 : Display Shipping Notification 顯示裝運通知單
VL35 : Form Picking Waves Acc. to Time Crit 根據時間標準排列領貨波次
VL41 : Create Rough GR 出口粗略收貨
VL42 : Change Rough GR 改變粗略收貨
VL43 : Display Rough GR 顯示粗略收貨
VL51 : Create Route Schedule 創建工藝路線調度
VL52 : Change Route Schedule 改變工藝路線調度
VL53 : Display Route Schedule 顯示工藝路線調度
VL70 : Output From Picking Lists 輸出揀配清單
VL71 : Output From Deliveries 裝運輸出
VL73 : "Confirmation of Decentr.Deliveries" "分散交貨確認"
VL75 : Shipping Notification Output 裝運通知輸出
VL76 : Output from Rough Goods Receipt 從粗略收貨輸出
VLAL : Archive Deliveries 歸檔交貨
VLIF : Test Shipping Interface 測試裝運介面
VLK1 : Picking with Picking Waves 分組揀貨
VLK2 : Picking with Picking Waves 分組揀貨
VLK3 : Picking with Picking Waves 分組揀貨
VLLA : RWE: Picking/Goods Issue Analysis RWE：領貨/發貨分析
VLLC : RWE: Archive Data RWE：歸檔資料
VLLD : Rough Workload Forecast: Delete Log 粗工作負荷預測：刪除日誌
VLLE : RWE: Goods Receipt/Putaway Analysis RWE：收貨/堆放分析
VLLF : Picking Waves: Archive Data 領貨波次：歸檔資料
VLLG : RWE: Analyze Complete Overview RWE：完全分析概覽
VLLP : Rough Workload Forecast: Display Log 粗工作負荷預測：顯示日誌
VLLQ : RWE: Returns to Vendor Analysis RWE：退貨給供應商分析
VLLR : RWE: Customer/Store Return Analysis RWE：客戶/商店退貨分析
VLLS : Var. Stand. Analyses Setting App 42 變數標準分析設置應用程式42
VLLV : W&S: Control RWE/Picking Waves W&S：控制RWE/領貨波次
VLRL : Reload Delivery 重裝載交貨
VUA4 : Assignm. Deliv. Type Incompl.Proced. 不完全分派交貨類型過程
VUA5 : Disp. Assignm.Del.Type to Incom.Proc 顯示不完全分派交貨類型過程
VUP4 : Assignm. Deliv.Items to Incom.Proc. 不完全分派交貨專案的過程
VUP5 : Display Assignm. Del.Items IncomProc 顯示不完全分派交貨專案過程
VARV : Archiving shipping units 裝運單位歸檔
VL74 : Outputs from shipping units 根據裝運單位輸出
VOR1 : Change View "Org. Unit: Dist. Channel per Sales Org.-Assign Master Data
VP00 : Shipping unit processing 裝運單位處理
VP11 : Create shipping unit (header) 創建裝運單位(抬頭)
VP12 : Change shipping unit (header) 修改裝運單位( 抬頭 )
VPAK : Packing list 包裝清單
VV61 : Create Output: Shipping Unit 創建輸出：裝運單位
VV62 : Change Output: Shipping Unit 更改輸出：裝運單位
VV63 : Display Output: Shipping Element 顯示輸出：裝運要素
VVUN : Importing shipping units 輸入裝運單位
VHAR : Shipping Material Types 裝運物料類型
VLPP : Packing req. of item categories 專案類別的包裝要求
VOL7 : Settings for Packing 打包設置
VPBD : Requirement for Packing in Delivery 交貨中的包裝要求
VT00 : Transport processing 運輸處理
VT01 : Create shipment 創建發運
VT02 : Change transport 更改運輸
VT03 : Display transport 顯示運輸
VT04 : Worklist Shipping 工作清單發運
VT05 : Worklist Shipping: Logs 工作清單發運：日誌
VT07 : Collective run in background 在後臺匯總運行
VT09 : Number Ranges for Log VT04 日誌VT04的編號範圍
VT10 : Select shipments: Start 選擇裝運：開始
VT11 : Select shipments: planning 選擇裝運：計畫
VT12 : Select shipments: Transpt Processing 選擇裝運：運輸處理
VT13 : F4-Help Shipment Number F4- 幫助　裝運編號
VT14 : Select shipments: Utilization 選擇裝運：利用
VT15 : Select shipments: Free capacity 選擇裝運：可用能力
VT16 : Select shipments: Check in 選擇裝運：登記
VT17 : Extended Help (F4) Shipment Number 擴展的幫助（F4） 裝運編號
VT18 : Start F4 Help Shipping 開始 F4 幫助發運
VT70 : Messages for shipments 發運信息
VTAR : Archive shipments 歸檔裝運　
VTBT : Report for Definition of Batch Run 批運行定義的報表
VTRL : Reload shipments 重裝裝運
0VT0 : Maintain Selection Variants 維護選擇變式
0VT1 : Maintain PersInChargOfShip SelectVar 維護裝運負責人 選擇變式
0VT2 : Maintain Tranport.Process. SelectVar 維護運輸處理選擇變數
0VT3 : Maintain Selection Var. Registration 維護選擇變式註冊
0VT4 : Maintain Selection Variant Registr. 維護選擇變式註冊
0VT5 : Maintain utilization select.variants 維護利用選擇變數
0VT6 : Maintain free capacity sel. variants 維護可用能力選擇變式
0VTA : Customizing Shipping Types 用戶化裝運類型
0VTB : Customizing Modes of Transport 運輸的使用者化模式
0VTC : Route definition 途徑定義
0VTD : Def. of Transp. Connection Point 運輸連接點的定義
0VTE : Multiple Maintenance Route Stages 複合維護工藝路線階段
0VTG : Cumulation of Materials in TPS 在運輸計畫系統中物料的累計
0VTK : Customizing Transport Types 定制運輸類型
0VTP : Tr.Planning Pos.ext. Planning System 運輸計畫入帳外部計畫系統
0VTS : Copy TPS Route Restrictions 複製運輸計畫系統路徑限制
0VTT : Create TPS Route Restrictions 複製運輸計畫系統路徑限制
0VTW : Special Processing Indicator 特殊處理標記
OMTX : Define non-SAP system 定義非SAP系統
OVRT : Customizing: Routes 定制：途徑
OVTL : C RV Del. item cats: Transp. relev. C RV 交貨專案類別：與運輸相關
OVTR : C SD Delivery Type: Transport.Relev. C SD 交貨類型：與運輸相關
OVTS : C SD Reason for Shipment Block 裝運凍結的 C SD 原因
OVXT : Transport Scheduling Points 運輸計畫點
V/77 : Output -ConditTable- Create Transprt 輸出－條件表－創建運輸
V/78 : Output -CondTable- Change Transport 輸出－條件表－更改運輸
V/79 : Output -CondTable- Display Transport 輸出－條件表－顯示運輸
V/80 : Access Sequence (Transport) 存取順序（運輸）
V/81 : View V_TNAPR Appl V7 視圖 V_TNAPR 應用 V7
V/82 : Maintain condition type Appl. V7 維護條件類型應用程式 V7
V/84 : Output Determination Transport 輸出確定運輸
VN07 : Maintain number range for shipments 維護裝運的編號範圍
VORT : Archiving Control Shipments 歸檔控制裝運
VV11 : Create Output: Sales 建立輸出：銷售
VV12 : Change Output: Sales 更改輸出：銷售
VV13 : Display Output: Sales 顯示輸出：銷售
VV71 : Create Output: Transportation 創建輸出：運輸
VV72 : Change Output: Transportation 更改輸出：運輸
VV73 : Display Output: Transportation 顯示輸出：運輸
OTF1 : Material-Freight Groups 物料運輸駔
OTF2 : Forwarding Agent - Freight Groups 運輸代理-貨運組
OTF3 : Freight Code Directories 貨運碼目錄
OTF4 : Determine Freight Code Directory 確定貨運代碼目錄
OTF5 : Freight Codes 貨運代碼
OTF6 : Freight Code Determination 貨運代碼確定
OTF7 : Define Freight Code Index 定義運費代碼索引
0VTH : Insert Material Cumulation to TPS 插入物料累計到運輸計畫系統
0VTI : Copy Material Cumulation to TPS 複製物料累計到運輸計畫系統
0VTR : Route limits ext. Transport. Planng 路徑限制外部運輸計畫
VT60 : Transfer Location Master Data to TPS 傳輸地點主記錄資料到運輸計畫系統
VT61 : Ext. transport. planning deliveries 外部運輸計畫交貨
VT68 : Deallocate delivery from TPS 從運輸計畫系統中取消分配交貨
VNPU : Partner Conversion 合夥人轉換
OVF6 : VAUK Dunning Areas VAUK催討範圍
OVG1 : Redetermine subtotal 重新確定小計
OVV8 : VSA VSA
OVV9 : C SD Table VSA C SD 表 VSA
OVVA : C SD Table VSA C SD 表 VSA
VCAR : Archiving 歸檔
VCUN : Reload 重新裝入
VF00 : 9Sales organization & is not defined 9銷售機構 & 未確定
VF01 : Create Billing Document 創建出具發票憑證
VF02 : Change Billing Document 修改出具發票憑證
VF03 : Display Billing Document 顯示出具發票憑證
VF04 : Process Billing Due List 處理出具發票到期清單
VF06 : Batch billing 成批出據發票
VF07 : Display bill. document from archive 顯示來自檔案開票憑證
VF11 : Cancel Billing Document 取消出具發票憑證
VF21 : Create Invoice List 創建發票清單
VF22 : Change invoice list 修改發票清單
VF23 : Display Invoice List 顯示發票清單
VF27 : Display invoice list from archive 顯示來自檔案的發票清單
VFBV : Reorganization of discount-rel. data 折扣相關資料的重組
VFLI : Log tax exemption 登錄免稅
VFP1 : Set Billing Date 設置出票日期
VFSN : Reorganization info structure S060 資訊結構S060的重組
VFX2 : Display Blocked Billing Documents 顯示凍結出具發票憑證
VFX3 : List Blocked Billing Documents 列出凍結的出具發票憑證清單
VGF1 : Create Group of Billing Documents 創建出具發票憑證組
VGF2 : Change group for billing document 修改出具發票憑證組
VGF3 : Display Group of Billing Documents 出具發票憑證顯示組
XEIP : Number range maintenance: EXPIMP 編號範圍維護: EXPIMP



The most frequently used transaction codes are as follows: (SD Main Menu)
1. VS00 - Master data
2. VC00 - Sales Support
3. VA00 - Sales
4. VL00 - Shipping
5. VT00 - Transportation
6. VF00 - Billing
7. VX00 - Trade Processing

Others as follows:
At Configuration:
1. VOV8 - Define Sales documents type (header)
2. OVAZ - Assigning Sales area to sales documents type
3. OVAU - Order reasons
4. VOV4 - Assign Item categoreies(Item cat determination)
5. VOV6 - Scedule line categories
6. OVAL - To assign blocks to relevant sales documents type
7. OVLK - Define delivery types
8. V/06 - Pricing
9. V/08 - Maintain pricing procedure
10.OVKP - Pricing proc determination
11.V/07 - Access sequence
VOPAN - Maintain Partner Determination

Enduser:
1. Customer Master Creation-VD01 and XD01 (for full inclu company code)
VD02 - Change Customer
VD03 - Display Customer
VD04 - Customer Account Changes
VD06 - Flag for Deletion Customer
XD01 - Create Customer
XD02 - Modify Customer
XD03 - Display Customer
2. Create Other material ----MM00
3. VB11- To create material determination condition record
4. CO09- Material availability Overview
5. VL01 - Create outbound delivery with ref sales order
6. VL04 - Collective processing of delivery
7. VA11 - Create Inquiry
VA12 - Change Inquiry
VA13 - Display Inquiry

Sales & Distribution
Sales order / Quote / Sched Agreement / Contract
· VA01 - Create Order
· VA02 - Change Order
· VA03 - Display Order
· VA02 - Sales order change
· VA05 - List of sales orders
· VA32 - Scheduling agreement change
· VA42 - Contract change
· VA21 - Create Quotation
· VA22 - Change Quotation
· VA23 - Display Quotation

Billing
· VF02 - Change billing document
· VF11 - Cancel Billing document
· VF04 - Billing due list
· FBL5N - Display Customer invoices by line
· FBL1N - Display Vendor invoices by line

Delivery
· VL02N - Change delivery document
· VL04 - Delivery due list
· VKM5 - List of deliveries
· VL06G - List of outbound deliveries for goods issue
· VL06P - List of outbound deliveries for picking
· VL09 - Cancel goods issue
· VT02N - Change shipment
· VT70 - Output for shipments

General
· VKM3, VKM4 - List of sales documents
· VKM1 - List of blocked SD documents
· VD52 - Material Determination

Read More

SD Overview

銷售和分銷組織架構
銷售和分銷主數據(Master Data)
銷售支持(Sales Support)、對外貿易
銷售憑證(Sales Document)：計畫協議、銷售合同及銷售訂單
裝運(Shipping)、運輸、開票(Billing)
銷售訊息系統(SIS)



銷售憑證種類
‧框架協議
- 合同(Contracts)
- 計畫協議(Schedule agreement)
‧客戶問題
- 退貨(Customer return)
- 寄售(Consignment)
- 免費訂單(Delivery free of charge)
- 後續免費交貨(Subsquent delivery free of charge)
- 貸項憑單請求(Credit memo request)
- 借項憑單請求(Debit memo request)
................



SD業務處理步驟(PROCESS STEPS)
銷售：詢價 → 報價 → 銷售訂單
裝運：交貨單 → 撿配 → 發貨過帳
開票：出具發票
應收：應收記帳

Read More

[房屋] 裝潢

http://0932930258.web66.com.tw/ch/CH110/110059/U/928707.html

http://amandaistill.pixnet.net/blog/post/24575311-%E8%BC%95%E9%AC%86%E5%81%9A%E5%A5%BD%E6%88%BF%E5%AD%90%E8%A3%9D%E4%BF%AE%E9%A0%90%E7%AE%97%E8%A6%8F%E5%8A%83(%E5%B0%8F%E5%9D%AA%E6%95%B8%EF%BC%8C%E8%80%81%E5%B1%8B%EF%BC%8C

http://cfdesign.pixnet.net/blog/post/22719073-%E8%A3%9D%E4%BF%AE%E5%95%8F%E7%AD%94%E3%80%89%E8%AB%8B%E5%95%8F%E8%88%8A%E5%B1%8B%E7%BF%BB%E4%BF%AE%E4%B8%80%E5%9D%AA%E7%9A%84%E8%A3%9D%E6%BD%A2%E8%B2%BB%E7%94%A8%E5%A4%A7%E6%A6%82

http://www.searchome.net/wikientry.aspx?entry=%E8%80%81%E5%B1%8B#toc_8

ITDarren.pixnet.net  
ITWDarren@gmail.com-sigma237

Read More

SD標準教材編號

SCM600 - Business Processes in Sales Order Management
SCM605 - Sales
SCM610 - Delivery Processes
SCM611 - Transportation
SCM615 - Billing
SCM620 - Pricing in SD
SCM645 - Credit / Risk Management for Receivables
SCM650 - Cross Functional Customizing in SD
SCM670 - Global Availability Check
SCM680 - Cross-Application Business Processes
TSCM60 - Order Fulfillment I (SD Academy)
TSCM62 - Order Fulfillment II (SD Academy)
TSCM64 - Order Fulfillment III (SD Academy)
TASCM1
TASCM6

Read More

缺勤限額不一致

參閱 Note.1674847

Report :

RPTKOK00
RPTBPC10

Read More

TEM

http://saphr.iexpertify.com/2009/01/training-and-event-management-basics.html

http://www.sd-solutions.com/SAP-HR-Train-Event.html

Read More

Create datebase

CREATE DATABASE [DemoDB]
CONTAINMENT = NONE
ON PRIMARY
(
NAME = N'DemoDB',
FILENAME = N'D:\LocalDB\DemoDB.MDF',
SIZE = 3072KB,
FILEGROWTH = 1024KB
)
LOG ON
(
NAME = N'DemoDB_log',
FILENAME = N'D:\LocalDB\DemoDB_Log.LDF',
SIZE = 1024KB,
FILEGROWTH = 10%
)
GO

USE [DemoDB]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY')
ALTER DATABASE [DemoDB] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO

Read More

[房屋] 傢俱資料

http://miixiu.pixnet.net/blog/post/6494052-%E4%BD%8E%E9%A0%90%E7%AE%97%E9%84%89%E6%9D%91%E9%A2%A8~~%E4%BF%97%E5%8F%88%E5%A4%A7%E7%A2%97%E5%8F%88%E5%A5%BD%E6%96%99%E7%9A%84%E5%BB%A0%E5%95%86%E5%A4%A7%E7%88%86%E6%96%99

http://mypaper.pchome.com.tw/mepolina/post/1322139872

傢俱工廠直營：優尚傢俱(桃園縣平鎮市南平路2段506號)
http://tw.user.bid.yahoo.com/tw/user/Y0727140997&u=:Y0727140997&tp=

實木傢俱訂製：戀戀小木屋
http://tw.user.bid.yahoo.com/tw/user/Y4237498769?rr=1395120654

進口實木傢俱：美生活館
http://tw.user.bid.yahoo.com/tw/user/Y0316556376?rr=1395120654

上豪傢俱工廠(台南)
http://www.sunhouse-furniture.com.tw/

大綠地庭園柚木家具(台中市沙鹿區鎮政路46巷100號)
http://www.outdoors-tw.com.tw/tw/about.php

木地板：小偉木地板
http://tw.user.bid.yahoo.com/tw/show/auctions?userID=Y0126410831&u=

家電：小蔡的店
http://tw.user.bid.yahoo.com/tw/user/Y0521571626&u=:Y0521571626&tp=

床墊：海西歐傢俱
02-8531-5887 新北市五股區新五路二段2巷8-6號

貴妃精品廚具
http://www.royalkitchen.com.tw/products.php

舒富樂沙發
http://www.soflexsofa.com.tw/
桃園縣龜山鄉集美街2號 (03)319-1998
星期一~星期五：AM09:00 ~ PM05:00
星期六~星期日：AM10:00 ~ PM06:00
國定假日之參觀時間請洽最新消息之公告

史密特龍沙發有限公司
http://www.hungchien.com.tw/
桃園縣大園鄉後厝村2鄰27-2號 0800-035535
週一 ～ 週六
AM 08：30 ~ 12:00
PM 13：00 ~ 17:30

Read More

BW標準教材

BW200 – Overview
BW205 – Reporting
BW207 – Reporting Management
BW209 – Web Reporting
BW210 – Warehouse Management
BW220 – SAP R/3 Extraction
BW257 – mySAP BI BW Config Split into BW205/207

BW305 – Enterprise Reporting, Query & Analysis (Part I)
BW306 – Enterprise Reporting, Query & Analysis (Part II)
BW310 – Data Warehousing
BW315 – Reporting Management
BW330 – Business Information Warehouse - Modeling
BW340 – Business Information Warehouse - Data Staging
BW350 – BI Data Acquisition
BW360 – SAP BI Performance & Administration
BW365 – SAP BI - User Management & Authorizations
BW370 – BI Integrated Planning
BW380 – SAP Business Intelligence: Analysis Processes and Data Mining

Read More

天下雜誌1000大企業使用ERP系統調查

http://www.erp.shu.edu.tw/1000/index_all.html

Read More

如何出版電子書

http://epicsword.pixnet.net/blog/post/37291572-%E6%B7%BA%E8%AB%87%E5%A6%82%E4%BD%95%E8%87%AA%E8%A1%8C%E5%87%BA%E7%89%88%E9%9B%BB%E5%AD%90%E6%9B%B8

http://www.pubu.com.tw/

Read More

Statements

EXCEPT
從左查詢傳回右查詢所未傳回的任何值

INTERSECT
傳回左右兩側都有的任何值



SELECT name FROM sys.databases;
{master,model,msdb,YKMDB,YK,YKTEST}

SELECT DISTINCT database_name database_name FROM msdb.dbo.backupset;
{VBMDB,Portal,SAP,YKMDB,YK}

== example ==
SELECT name databases FROM sys.databases WHERE name like 'm%' or name like 'Y%'
EXCEPT
SELECT DISTINCT database_name database_name FROM msdb.dbo.backupset;
==>> {master,model,msdb,YKTEST}

SELECT name databases FROM sys.databases WHERE name like 'm%' or name like 'Y%'
INTERSECT
SELECT DISTINCT database_name database_name FROM msdb.dbo.backupset;
==>> {YKMDB,YK}

Read More

網路推薦金

http://tw.partner.buy.yahoo.com/help/join

http://www.books.com.tw/exep/ap/index.php

http://pyling.pixnet.net/blog/post/44950465-%E3%84%9E%CB%8B%E7%9C%81%E5%95%A6-%E8%87%AA%E5%B7%B1%E6%8B%BF-7net-%E5%8D%9A%E5%AE%A2%E4%BE%86-%E6%8E%A8%E8%96%A6%E9%87%91%E7%9C%81%E9%8C%A2%E6%B3%95

 

Read More