S276BIW1 - S276BIW1 * Transfer to BW: Sales and Distribution Data

S276BIW1 * Transfer to BW: Sales and Distribution Data information is stored in SAP table S276BIW1.
It is part of development package MCBW in software component LO-LIS-DC. This development package consists of objects that can be grouped under "Logistics Extractors for SAP BW, Release-Independent".

Fields for table S276BIW1

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6	*
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
BWBELN	BW: Document Number	X	MCBW_BELN	CHAR	20	*
BWBLPOS	BW: Document Item Number	X	MCBW_BLPOS	NUMC	12	*
BWEINT	BW: Document Schedule	X	MCBW_EINT	NUMC	8	VBEP
BWVORG	BW: Transaction Key SAP BW	X	MCBW_VORG	NUMC	6
BWSUPKZ	Auxiliary statistics update indicator	X	MCBW_SUPKZ	CHAR	2
ERZET	Entry time	X	ERZET	TIMS	12
PERIV	Fiscal Year Variant		PERIV	CHAR	4	*
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
VRKME	Sales unit		VRKME	UNIT	6	T006
WAERK	SD Document Currency		WAERK	CUKY	10	TCURC
BASME	Base Unit of Measure		MEINS	UNIT	6	T006
BWMVE	BW: Quantity in Sales Unit		MCBW_MVE	QUAN	8
BWANZ	BW: Number of Transactions		MCBW_ANZ	INT4	4
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
PKUNAG	Sold-to Party		KUNAG	CHAR	20	KNA1
WERKS	Plant		EWERK	CHAR	8	T001W
AKTNR	Promotion		WAKTION	CHAR	20	WAKH
WMINR	Product Catalog Number		MCBW_WMINR	CHAR	20
MATWA	Material Entered		MATWA	CHAR	80	MARA
VOGRU	BW: Reason for Transaction		MCBW_VOGRU	CHAR	8
ABGRU	Reason for Rejection of Sales Documents		ABGRU_VA	CHAR	4	TVAG
VKORG	Sales Organization		VKORG	CHAR	8	TVKO
VTWEG	Distribution Channel		VTWEG	CHAR	4	TVKOV
SPART	Division		SPART	CHAR	4	TVTA
VKBUR	Sales office		VKBUR	CHAR	8	TVKBZ
VKGRP	Sales group		VKGRP	CHAR	6	TVBVK
PKUNWE	Ship-to Party		KUNWE	CHAR	20	KNA1
BWBLTYP	BW: Document Category		MCBW_BLTYP	CHAR	2
BWBLART	BW: Document Type		MCBW_BLART	CHAR	8	TVAK
BWBTYP	BW: Item Category Document		MCBW_BPTYP	CHAR	8	TVPT
KNUMA_AG	Sales Deal		KNUMA_AG	CHAR	20	KONA
BWAPPLNM	Application Component		RSAPPLNM	CHAR	60
MATNR	Material Number		MATNR	CHAR	80	MARA
BWGEOD	BW: Cost Value in Document Currency		MCBW_GEOD	CURR	10
BWGVOD	BW: Retail Value in Document Currency		MCBW_GVOD	CURR	10
BWGVPD	BW: Retail Value with Tax in Document Currency		MCBW_GVPD	CURR	10
BWPNLD	BW: Price Reduction in Document Currency		MCBW_PNLD	CURR	10
BWOAUWD	BW: Net Open Sales Order Value in Document Currency		MCBW_OAUWD	CURR	10
KURSK_DAT	Translation date		WWERT_D	DATS	16
KURSK	Exchange Rate for Price Determination		KURSK	DEC	5
WAERS	Local Currency		HWAER	CUKY	10	TCURC
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
BWOAUMV	BW: Open Order Quantity in Base Unit of Measure		MCBW_OAUMB	QUAN	8
APERDAT	Date on which the record was created		ERDAT	DATS	16
BWMNG	BW: Quantity in Base Unit of Measure		MCBW_MNG	QUAN	8