銷售訂單 (Sales Order): 資料表及更新記錄

銷售訂單

建立記錄: (Create)

select VBELN
  from VBAK
 where ERDAT GE I_DATUM_FM
   AND ERDAT LE I_DATUM_TO

更新/刪除記錄: (Change/Delete)

select distinct OBJECTID
  from CDHDR
 where OBJECTCLAS = 'VERKBELEG'
   and UDATE = I_DATUM

相關資料表:

資料表-欄位	描述	備註
VBAK (銷售文件：表頭資料)
VBAK-VBELN	Sales Order No.
VBAK-VKORG	Sales Org	可配對公司編碼 TVKO-BUKRS (CompCd)
VBAK-VKGRP	Sales Group

VBAP (銷售文件：項目資料)
VBAP-VBELN	Sales Order No.
VBAP-POSNR	SO Item No.
VBAP-MATKL	Material Group
VBAP-MATNR	Material Code
VBAP-WAERK	Currency
VBAP-WERKS	Plant
VBAP-ERDAT	Create Date
VBAP-ERNAM	Create By
VBAP-ABGRU	Reason of Reject	Not empty means deleted

VBEP (銷售文件﹕時程明細的資料)
VBEP-VBELN	Sales Order No.
VBEP-POSNR	SO Item No.
VBEP-ETENR	SO Schedule Ln No.
VBEP-J_3ASIZE	Grid Value
VBEP-J_4KRCAT	Material Category
VBEP-LMENG	Base Qty
VBEP-MEINS	Base Unit
VBEP-J_3ANETP	Net Price
VBEP-WMENG	Order Qty
VBEP-VRKME	Order UoM
VBEP-J_3ANETW	Amount
VBEP-EDATU	Schedule Deliver Date

VBKD (銷售文件﹕業務資料)
VBKD-VBELN	Sales Order No.
VBKD-POSNR	SO Item No.
VBKD-BSTKD	Customer PO
VBKD-ZTERM	Payment Term	Take Header Level if no item level record found
VBKD-INCO1	Interco Term 1	Take Header Level if no item level record found
VBKD-INCO2	Interco Term 2	Take Header Level if no item level record found

VBPA (銷售文件：合作夥伴)
VBPA-VBELN	Sales Order No.
VBPA-POSNR	SO Item No.
VBPA-PARVW	Partner Function
VBPA-KUNNR	Sold to Party	[PARVW = AG] (顯示為 SP) Take Header Level if no item level record found
VBPA-KUNNR	Ship to Party	[PARVW = WE] (顯示為 SH) Take Header Level if no item level record found

CDHDR (變更文件表頭)
CDHDR-UDATE	Last Updated Date
CDHDR-USERNAME	Last Updated By