SAP ABAP Table S272 (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	S272	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	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
18	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
19	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
20	BIWMNG	☐	MCW_BIWMNG	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer base quantity
21	BIWMVE	☐	MCW_BIWMVE	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer quantity sold
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	BIWPNL	☐	MCW_BIWPNL	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer price reduction
26	BIWANZ	☐	MCW_BIWANZ	MCZAEHLINT	INT4	10	0	RIS/Reporting Server - Transfer number of activities
27	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
28	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
29	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
30	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
31	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
32	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
33	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
34	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
35	BRTWR	☐	BRTWR_FP	WERTV8	CURR	15	2	Gross value of the billing item in document currency
36	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
37	OAUME	☐	MC_OAUME	MENGV15_3	QUAN	15	3	Open orders quantity in base unit of measure
38	OAUWE	☐	MC_OAUWE	WERTV10	CURR	19	2	Open net value of orders
39	PKUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
40	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
41	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
42	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
43	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
44	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
45	GRUND	☐	MCW_BIWGRU	CHAR4	CHAR	4	0	Reason for activity
46	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
47	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
48	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
49	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
50	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
51	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
52	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
53	BWBELT	☐	MCW_BWBELT	BSTYP	CHAR	1	0	Type of transfer document
54	BWBELA	☐	MCW_BWBELA	AUART	CHAR	4	0	Transfer document type	TVAK
55	BWPOST	☐	MCW_BWPOST	PSTYV	CHAR	4	0	Item category transfer document	TVPT
56	KNUMA_PI	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion	KONA
57	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	KONA

Foreign Keys

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

History

Last changed by/on	SAP	20050411
SAP Release Created in