SAP ABAP Table S275BIW1 (S275BIW1 * Transfer to BW: Purchasing 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	S275BIW1	Table Relationship Diagram
Short Description	S275BIW1 * Transfer to BW: Purchasing 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	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
17	BSTWA	☐	BSTWA	WAERS	CUKY	5	0	Purchase order currency	TCURC
18	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
19	BWMBE	☐	MCBW_MBE	MENGV15_3	QUAN	15	3	BW: Quantity in Order Unit
20	BWANZ	☐	MCBW_ANZ	MCZAEHLINT	INT4	10	0	BW: Number of Transactions
21	BRTWR	☐	MC_BBRTWR	WERT7	CURR	13	2	Gross order value in order currency
22	BWDMBE	☐	MCBW_DMBE	MENG15_3	QUAN	15	3	BW: Delta Purchase Order/GR in Order Unit
23	DBWGEO	☐	MCW_DBWGEO	WERTV10	CURR	19	2	Delta purchase order/goods receipt at cost
24	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
25	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
26	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
27	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
28	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
29	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
30	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
31	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
32	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
33	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
34	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
35	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
36	BWBLTYP	☐	MCBW_BLTYP	BSTYP	CHAR	1	0	BW: Document Category
37	BWBLART	☐	MCBW_BLART	AUART	CHAR	4	0	BW: Document Type	TVAK
38	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
39	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
40	BWAPPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
41	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
42	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering
43	BWGEOO	☐	MCBW_GEOO	WERTV10	CURR	19	2	BW: Cost Value in Order Currency
44	BUDAT	☐	MC_BUDAT	DATUM	DATS	8	0	Posting date of goods received or invoice receipt for order
45	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
46	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
47	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
48	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
49	BWMATKL	☐	MCBW_MATKL	MATKL	CHAR	9	0	BW: Material Group from Document	T023
50	BWGEO	☐	MCBW_GEO	WERTV10	CURR	19	2	BW: Cost Value in Local Currency
51	BWGVO	☐	MCBW_GVO	WERTV10	CURR	19	2	BW: Retail Value in Local Currency
52	BWGVP	☐	MCBW_GVP	WERTV10	CURR	19	2	BW: Retail Value with Tax in Local Currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S275BIW1	AKTNR	WAKH	AKTNR
2	S275BIW1	BSTME	T006	MSEHI
3	S275BIW1	BSTWA	TCURC	WAERS
4	S275BIW1	BWBELN	VBUK	VBELN
5	S275BIW1	BWBLART	TVAK	AUART
6	S275BIW1	BWBLPOS	VBUP	POSNR
7	S275BIW1	BWEINT	VBEP	ETENR
8	S275BIW1	BWMATKL	T023	MATKL
9	S275BIW1	EKGRP	T024	EKGRP
10	S275BIW1	EKORG	T024E	EKORG
11	S275BIW1	HWAER	TCURC	WAERS
12	S275BIW1	LIFNR	LFA1	LIFNR
13	S275BIW1	MANDT	T000	MANDT
14	S275BIW1	MATNR	MARA	MATNR
15	S275BIW1	MEINS	T006	MSEHI
16	S275BIW1	PSTYP	T163	PSTYP
17	S275BIW1	RESWK	T001W	WERKS
18	S275BIW1	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in