S263BIW2 - SD - Sales order/delivery note

SD - Sales order/delivery note information is stored in SAP table S263BIW2.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".

Fields for table S263BIW2

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
VBELN	Sales Document	X	VBELN_VA	CHAR	20
POSNR	Sales Document Item	X	POSNR_VA	NUMC	12
ETENR	Schedule Line Number	X	ETENR	NUMC	8	VBEP
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
PERIV	Fiscal Year Variant		PERIV	CHAR	4
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
.INCLUDE				MCVAVCACHA	0
WAERK	SD Document Currency		WAERK	CUKY	10	*
VBTYP	SD Document Category		VBTYPL	CHAR	8
VKORG	Sales Organization		VKORG	CHAR	8
VTWEG	Distribution Channel		VTWEG	CHAR	4
SPARA	Division for order header		SPART_AK	CHAR	4	*
VKBUR	Sales office		VKBUR	CHAR	8	*
KVGR1	Customer Group 1		KVGR1	CHAR	6	*
KVGR2	Customer Group 2		KVGR2	CHAR	6	*
KVGR3	Customer Group 3		KVGR3	CHAR	6	*
KVGR4	Customer Group 4		KVGR4	CHAR	6	*
KVGR5	Customer Group 5		KVGR5	CHAR	6	*
VKGRP	Sales group		VKGRP	CHAR	6	*
KUNNR	Sold-to Party		KUNAG	CHAR	20	KNA1
FAKSK	Billing Block in SD Document		FAKSK	CHAR	4	*
LIFSK	Delivery Block (Document Header)		LIFSK	CHAR	4	*
.INCLU--AP				MCVAVCACAP	0
STWAE	Statistics Currency		STWAE	CUKY	10	*
BUKRS	Company Code		BUKRS	CHAR	8
HWAER	Local Currency		HWAER	CUKY	10	*
.INCLUDE				MCVAVCNCHA	0
MATNR	Material Number		MATNR	CHAR	80
PRODH	Product hierarchy		PRODH_D	CHAR	36	*
MATKL	Material Group		MATKL	CHAR	18
CHARG	Batch Number		CHARG_D	CHAR	20	*
FAKSP	Billing Block for Item		FAKSP_AP	CHAR	4	*
WERKS	Plant		WERKS_D	CHAR	8
LGORT	Storage location		LGORT_D	CHAR	8	*
VSTEL	Shipping Point / Receiving Point		VSTEL	CHAR	8	*
ROUTE	Route		ROUTE	CHAR	12	*
SPART	Division		SPART	CHAR	4
PKUNWE	Ship-to Party		KUNWE	CHAR	20	*
PKUNRE	Bill-to Party		KUNRE	CHAR	20	*
PKUNRG	Payer		KUNRG	CHAR	20	*
PSPDNR	Forwarding Agent		SPDNR	CHAR	20	*
PVRTNR	Sales employee		VRTNR	NUMC	16
MVGR1	Material Group 1		MVGR1	CHAR	6	*
MVGR2	Material Group 2		MVGR2	CHAR	6	*
MVGR3	Material Group 3		MVGR3	CHAR	6	*
MVGR4	Material Group 4		MVGR4	CHAR	6	*
MVGR5	Material Group 5		MVGR5	CHAR	6	*
ABSTA	Rejection Status (Item)		ABSTA_VB	CHAR	2
KDGRP	Customer Group		KDGRP	CHAR	4	*
BZIRK	Sales District		BZIRK	CHAR	12	*
INCO1	Incoterms (Part 1)		INCO1	CHAR	6	*
INCO2	Incoterms (Part 2)		INCO2	CHAR	56
ERDAT	Date on which the record was created		ERDAT	DATS	16
STADAT	Statistics date		STADAT	DATS	16
VRKME	Sales unit		VRKME	UNIT	6	T006
MEINS	Base Unit of Measure		MEINS	UNIT	6	*
GEWEI	Weight Unit		GEWEI	UNIT	6	*
VOLEH	Volume unit		VOLEH	UNIT	6	*
UMVKZ	Numerator (factor) for conversion of sales quantity into SKU		UMVKZ	DEC	3
UMVKN	Denominator (divisor) for conversion of sales Qty into SKU		UMVKN	DEC	3
KURSK	Exchange Rate for Price Determination		KURSK	DEC	5
STCUR	Exchange rate for statistics		STCUR	DEC	5
NETPR	Net Price		NETPR	CURR	6
.INCLU--AP				MCVAVCNCAP	0
SHKZG	Returns Item		SHKZG_VA	CHAR	2
PS_POSID	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
.INCLUDE				MCVAVCNKYF	0
OAUME	Open orders quantity in base unit of measure		MC_OAUME	QUAN	8
OAUWE	Net Value of Open Orders		MC_OAUWE	CURR	10
.INCLU--AP				MCVAVCNKAP	0
ANZAU	Number of Orders		MC_ANZAU	DEC	5
ANZAUPOS	Number of Order Items		MC_ANZAUPO	DEC	5
.INCLUDE				MCVAVCOCHA	0
ETTYP	Schedule line category		ETTYP	CHAR	4	*
LIFSP	Schedule Line Blocked for Delivery		LIFSP_EP	CHAR	4	*
EDATU	Schedule line date		EDATU	DATS	16
LDDAT	Loading Date		LDDAT	DATS	16
TDDAT	Transportation Planning Date		TDDAT_D	DATS	16
WADAT	Goods Issue Date		WADAT	DATS	16
MBDAT	Material Staging/Availability Date		MBDAT	DATS	16
WLDATBE	Desired del. date in confirmed schedule lines		WLDATBE	DATS	16
.INCLUDE				MCVAVCOKYF	0
OLFMNG	Open quantity to be delivered (in sales unit)		OLFMNG	QUAN	7