SAP ABAP Table S276BIW2 (S276BIW2 * BW Transfer: Sales and Distribution Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-LIS-DC (Application Component) Data Collection
     ⤷ MCBW (Package) Logistics Extractors for SAP BW, Release-Independent

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S276BIW2	Table Relationship Diagram
Short Description	S276BIW2 * BW Transfer: Sales and Distribution Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	BWBELN	☑	MCBW_BELN	VBELN	CHAR	10	0	BW: Document Number	VBUK
9	BWBLPOS	☑	MCBW_BLPOS	POSNR	NUMC	6	0	BW: Document Item Number	VBUP
10	BWEINT	☑	MCBW_EINT	ETENR	NUMC	4	0	BW: Document Schedule	VBEP
11	BWVORG	☑	MCBW_VORG	NUM3	NUMC	3	0	BW: Transaction Key SAP BW
12	BWSUPKZ	☑	MCBW_SUPKZ	SUPKZ	CHAR	1	0	Auxiliary statistics update indicator
13	ERZET	☑	ERZET	UZEIT	TIMS	6	0	Entry time
14	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
15	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
16	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
17	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
18	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
19	BWMVE	☐	MCBW_MVE	MENGV15_3	QUAN	15	3	BW: Quantity in Sales Unit
20	BWANZ	☐	MCBW_ANZ	MCZAEHLINT	INT4	10	0	BW: Number of Transactions
21	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
22	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
23	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
24	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
25	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
26	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
27	PKUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
28	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
29	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
30	WMINR	☐	MCBW_WMINR	MCBW_WMINR	CHAR	10	0	Product Catalog Number
31	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
32	VOGRU	☐	MCBW_VOGRU	CHAR4	CHAR	4	0	BW: Reason for Transaction
33	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
34	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
35	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
36	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
37	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
38	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
39	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
40	BWBLTYP	☐	MCBW_BLTYP	BSTYP	CHAR	1	0	BW: Document Category
41	BWBLART	☐	MCBW_BLART	AUART	CHAR	4	0	BW: Document Type	TVAK
42	BWBTYP	☐	MCBW_BPTYP	PSTYV	CHAR	4	0	BW: Item Category Document	TVPT
43	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	KONA
44	BWAPPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
45	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
46	BWGEOD	☐	MCBW_GEOD	WERTV10	CURR	19	2	BW: Cost Value in Document Currency
47	BWGVOD	☐	MCBW_GVOD	WERTV10	CURR	19	2	BW: Retail Value in Document Currency
48	BWGVPD	☐	MCBW_GVPD	WERTV10	CURR	19	2	BW: Retail Value with Tax in Document Currency
49	BWPNLD	☐	MCBW_PNLD	WERTV10	CURR	19	2	BW: Price Reduction in Document Currency
50	BWOAUWD	☐	MCBW_OAUWD	WERTV10	CURR	19	2	BW: Net Open Sales Order Value in Document Currency
51	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
52	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
53	WAERS	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
54	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
55	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
56	BWOAUMV	☐	MCBW_OAUMB	MENGV15_3	QUAN	15	3	BW: Open Order Quantity in Base Unit of Measure
57	APERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
58	BWMNG	☐	MCBW_MNG	MENGV15_3	QUAN	15	3	BW: Quantity in Base Unit of Measure

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S276BIW2	ABGRU	TVAG	ABGRU
2	S276BIW2	AKTNR	WAKH	AKTNR
3	S276BIW2	BASME	T006	MSEHI
4	S276BIW2	BWBELN	VBUK	VBELN
5	S276BIW2	BWBLART	TVAK	AUART
6	S276BIW2	BWBLPOS	VBUP	POSNR
7	S276BIW2	BWBTYP	TVPT	PSTYV
8	S276BIW2	BWEINT	VBEP	ETENR
9	S276BIW2	KNUMA_AG	KONA	KNUMA		C	CN
10	S276BIW2	MANDT	T000	MANDT
11	S276BIW2	MATNR	MARA	MATNR
12	S276BIW2	MATWA	MARA	MATNR
13	S276BIW2	PKUNAG	KNA1	KUNNR
14	S276BIW2	PKUNWE	KNA1	KUNNR
15	S276BIW2	SPART	TVTA	SPART
16	S276BIW2	VKBUR	TVKBZ	VKBUR
17	S276BIW2	VKGRP	TVBVK	VKGRP
18	S276BIW2	VKORG	TVKO	VKORG
19	S276BIW2	VRKME	T006	MSEHI
20	S276BIW2	VTWEG	TVKOV	VTWEG
21	S276BIW2	WAERK	TCURC	WAERS
22	S276BIW2	WAERS	TCURC	WAERS
23	S276BIW2	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in