S262BIW1 - SD - Billing document

SD - Billing document information is stored in SAP table S262BIW1.
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 S262BIW1

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	Billing Document	X	VBELN_VF	CHAR	20
POSNR	Billing Item	X	POSNR_VF	NUMC	12
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				MCVDACHAR	0
WAERK	SD Document Currency		WAERK	CUKY	10	TCURC
STWAE	Statistics Currency		STWAE	CUKY	10	*
HWAER	Local Currency		HWAER	CUKY	10	*
KURRF	Exchange Rate for Postings to Financial Accounting		KURRF	DEC	5
FKART	Billing Type		FKART	CHAR	8	*
FKTYP	Billing Category		FKTYP	CHAR	2
VBTYP	SD Document Category		VBTYPL	CHAR	8
VKORG	Sales Organization		VKORG	CHAR	8
VTWEG	Distribution Channel		VTWEG	CHAR	4
BUKRS	Company Code		BUKRS	CHAR	8
KUNRG	Payer		KUNRG	CHAR	20	*
KUNAG	Sold-to Party		KUNAG	CHAR	20	KNA1
KDGRP	Customer Group		KDGRP	CHAR	4	*
BZIRK	Sales District		BZIRK	CHAR	12	*
FKDAT	Billing Date		FKDAT	DATS	16
.INCLUDE				MCVDNCHAR	0
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
MEINS	Base Unit of Measure		MEINS	UNIT	6	*
VRKME	Sales unit		VRKME	UNIT	6	*
VOLEH	Volume unit		VOLEH	UNIT	6	*
GEWEI	Weight Unit		GEWEI	UNIT	6	*
ERDAT	Date on which the record was created		ERDAT	DATS	16
AEDAT	Last Changed On		AEDAT	DATS	16
STADAT	Statistics date		STADAT	DATS	16
PRSDT	Date for Pricing and Exchange Rate		PRSDT	DATS	16
FBUDA	Date on which services are rendered		FBUDA	DATS	16
PSTYV	Sales document item category		PSTYV	CHAR	8	*
POSAR	Item Type		POSAR	CHAR	2
PRODH	Product hierarchy		PRODH_D	CHAR	36	*
VSTEL	Shipping Point / Receiving Point		VSTEL	CHAR	8	*
SPART	Division		SPART	CHAR	4
WERKS	Plant		WERKS_D	CHAR	8
KOSTL	Cost Center		KOSTL	CHAR	20	*
BONUS	Volume rebate group		BONUS	CHAR	4	*
PROVG	Commission Group		PROVG	CHAR	4	*
VKGRP	Sales group		VKGRP	CHAR	6	*
VKBUR	Sales office		VKBUR	CHAR	8	*
SPARA	Division for order header		SPART_AK	CHAR	4	*
MATNR	Material Number		MATNR	CHAR	80
MATKL	Material Group		MATKL	CHAR	18
CHARG	Batch Number		CHARG_D	CHAR	20	*
LGORT	Storage location		LGORT_D	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	*
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	*
KOKRS	Controlling Area		KOKRS	CHAR	8	*
PKUNWE	Ship-to Party		KUNWE	CHAR	20	*
PKUNRE	Bill-to Party		KUNRE	CHAR	20	*
PSPDNR	Forwarding Agent		SPDNR	CHAR	20	*
PVRTNR	Sales employee		VRTNR	NUMC	16
AUBEL	Sales Document		VBELN_VA	CHAR	20
AUPOS	Sales Document Item		POSNR_VA	NUMC	12
VGBEL	Document number of the reference document		VGBEL	CHAR	20
VGPOS	Item number of the reference item		VGPOS	NUMC	12
.INCLU--AP				MCVDACAP	0
STCUR	Exchange rate for statistics (Exch.rate at time of creation)		STCUR_AP	DEC	5
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
ERZET	Entry time		ERZET	TIMS	12
PS_POSID	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
.INCLUDE				MCVDNKYF	0
FKIMG	Actual billed quantity		FKIMG	QUAN	7
SMENG	Scale Quantity in base unit of measure		SMENG	QUAN	7
FKLMG	Billing quantity in stock keeping unit		FKLMG	QUAN	7
LMENG	Required quantity for mat.management in stockkeeping units		LMENG	QUAN	7
NTGEW	Net weight		NTGEW_15	QUAN	8
BRGEW	Gross weight		BRGEW_15	QUAN	8
VOLUM	Volume		VOLUM_15	QUAN	8
NETWR	Net Value of Billing item in Document Currency		NETWR_FP	CURR	8
SKFBP	Amount eligible for cash discount in document currency		SKFBP	CURR	7
WAVWR	Cost in Document Currency		WAVWR	CURR	7
KZWI1	Subtotal 1 from Pricing Procedure for Price Element		KZWI1	CURR	7
KZWI2	Subtotal 2 from Pricing Procedure for Price Element		KZWI2	CURR	7
KZWI3	Subtotal 3 from Pricing Procedure for Price Element		KZWI3	CURR	7
KZWI4	Subtotal 4 from Pricing Procedure for Price Element		KZWI4	CURR	7
KZWI5	Subtotal 5 from Pricing Procedure for Price Element		KZWI5	CURR	7
KZWI6	Subtotal 6 from Pricing Procedure for Price Element		KZWI6	CURR	7
BONBA	Rebate Basis 1		BONBA	CURR	7
MWSBP	Tax Amount in Document Currency		MWSBP	CURR	7
.INCLU--AP				MCVDNKAP	0
ANZFK	No.of billing docs		MC_ANZFK	DEC	5
ANZFKPOS	Number of billing items		MC_ANZFKPO	DEC	5