SAP ABAP Table S270BIW1 (Do not use!)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S270BIW1	Table Relationship Diagram
Short Description	Do not use!

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	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
3	BWBELN	☑	MCW_BWBELN	VBELN	CHAR	10	0	Document number for Retail transfer structures	VBUK
4	BELPOS	☑	MCW_BELPOS	POSNR	NUMC	6	0	Item number for Retail transfer structures	VBUP
5	BWEINT	☑	MCW_BWEINT	ETENR	NUMC	4	0	Schedule line number for Retail transfer	VBEP
6	BWVORG	☑	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
7	SUPKZ	☑	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
8	ERZET	☑	ERZET	UZEIT	TIMS	6	0	Entry time
9	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
10	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
11	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
12	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
13	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
14	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
15	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
16	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
17	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
18	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
19	BSTWA	☐	BSTWA	WAERS	CUKY	5	0	Purchase order currency	TCURC
20	BIWMNG	☐	MCW_BIWMNG	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer base quantity
21	BIWMBE	☐	MCW_BIWMBE	MENG15_3	QUAN	15	3	RIS/Reporting Server - Transfer purchase order quantity
22	BIWGEO	☐	MCW_BIWGEO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer cost price
23	BIWGVO	☐	MCW_BIWGVO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price
24	BIWGVP	☐	MCW_BIWGVP	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price with tax
25	BIWANZ	☐	MCW_BIWANZ	MCZAEHLINT	INT4	10	0	RIS/Reporting Server - Transfer number of activities
26	BRTWR	☐	MC_BBRTWR	WERT7	CURR	13	2	Gross order value in order currency
27	NETWR	☐	MC_BNETWR	WERT7	CURR	13	2	Net order value in order currency
28	DBWMNG	☐	MCW_DBWMNG	MENGV15_3	QUAN	15	3	Delta purchase order/goods receipt quantity in BUn
29	DBWMBE	☐	MCW_DBWMBE	MENG15_3	QUAN	15	3	Delta purchase order/GR in PO qty
30	DBWGEO	☐	MCW_DBWGEO	WERTV10	CURR	19	2	Delta purchase order/goods receipt at cost
31	DBWGVO	☐	MCW_DBWGVO	WERTV10	CURR	19	2	Delta purchase order/goods receipt at retail
32	DBWGVP	☐	MCW_DBWGVP	WERTV10	CURR	19	2	Delta purchase order/goods receipt at retail with tax
33	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
34	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
35	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
36	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
37	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
38	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
39	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
40	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
41	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
42	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
43	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
44	BEDAT	☐	MCW_BELDAT	DATUM	DATS	8	0	Document date
45	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
46	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
47	BWBELT	☐	MCW_BWBELT	BSTYP	CHAR	1	0	Type of transfer document
48	BWBELA	☐	MCW_BWBELA	AUART	CHAR	4	0	Transfer document type	TVAK
49	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S270BIW1	AKTNR	WAKH	AKTNR
2	S270BIW1	BASME	T006	MSEHI
3	S270BIW1	BELPOS	VBUP	POSNR	KEY
4	S270BIW1	BSTME	T006	MSEHI
5	S270BIW1	BSTWA	TCURC	WAERS
6	S270BIW1	BWBELA	TVAK	AUART
7	S270BIW1	BWBELN	VBUK	VBELN	KEY
8	S270BIW1	BWEINT	VBEP	ETENR	KEY
9	S270BIW1	EKGRP	T024	EKGRP
10	S270BIW1	EKORG	T024E	EKORG
11	S270BIW1	HWAER	TCURC	WAERS
12	S270BIW1	LIFNR	LFA1	LIFNR
13	S270BIW1	MANDT	T000	MANDT	KEY
14	S270BIW1	MATNR	MARA	MATNR
15	S270BIW1	RESWK	T001W	WERKS
16	S270BIW1	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in