SAP ABAP Table S214BIW2 (S214BIW2 * CatMan: Indexes for Space Management Program)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MAP (Application Component) Merchandise and Assortment Planning
     ⤷ CM_MAP (Package) Category Management - MAP

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S214BIW2	Table Relationship Diagram
Short Description	S214BIW2 * CatMan: Indexes for Space Management Program

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	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
3	HIER_ID	☑	HIER_CNT	HIERCNT	CHAR	2	0	Hierarchy ID
4	CDT1	☑	CM_CDT1	CM_CDT	CHAR	18	0	Category	CMMD_CDT1
5	CDT2	☑	CM_CDT2	CM_CDT	CHAR	18	0	Subcategory	CMMD_CDT2
6	CDT3	☑	CM_CDT3	CM_CDT	CHAR	18	0	Segment	CMMD_CDT3
7	CDT4	☑	CM_CDT4	CM_CDT	CHAR	18	0	Subsegment	CMMD_CDT4
8	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
11	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
12	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
13	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
14	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
15	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
16	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
17	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
18	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
19	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
20	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
21	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
22	CM_LISTED	☐	CM_LISTED	LISTED	NUMC	1	0	Listing Indicator
23	REL_UMSMNG	☐	RELEF_UMSMNG	DEC6_2	DEC	8	2	Weight Sales Quantity
24	REL_UMSGVO	☐	RELEF_UMSGVO	DEC6_2	DEC	8	2	Weight Sales Sales Price
25	REL_UMSGEO	☐	RELEF_UMSGEO	DEC6_2	DEC	8	2	Weight Sales Purchase Price
26	REL_MARGE	☐	RELEF_MARGE	DEC6_2	DEC	8	2	Weight Margin
27	INDEX1	☐	INDEX1	DEC6_2	DEC	8	2	Index 1 from Plan Data for Space Management
28	INDEX2	☐	INDEX2	DEC6_2	DEC	8	2	Index 2 from Plan Data for Space Management
29	INDEX3	☐	INDEX3	DEC6_2	DEC	8	2	Index 3 from Plan Data for Space Management
30	STRATEGY	☐	CATSTRATEGY	CDT_STRATEGY	CHAR	20	0	Node Strategy
31	CDT5	☐	CM_CDT5	CM_CDT	CHAR	18	0	Sub-Subsegment	CMMD_CDT5
32	CDT6	☐	CM_CDT6	CM_CDT	CHAR	18	0	Product Group	CMMD_CDT6
33	CDT7	☐	CM_CDT7	CM_CDT	CHAR	18	0	Brand	CMMD_CDT7
34	CM_AZART	☐	CM_AZART	DEC8_3	DEC	11	3	Number of Articles

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S214BIW2	BASME	T006	MSEHI
2	S214BIW2	CDT1	CMMD_CDT1	CDT1	KEY
3	S214BIW2	CDT2	CMMD_CDT2	CDT2	KEY
4	S214BIW2	CDT3	CMMD_CDT3	CDT3	KEY
5	S214BIW2	CDT4	CMMD_CDT4	CDT4	KEY
6	S214BIW2	CDT5	CMMD_CDT5	CDT5
7	S214BIW2	CDT6	CMMD_CDT6	CDT6
8	S214BIW2	CDT7	CMMD_CDT7	CDT7
9	S214BIW2	MANDT	T000	MANDT	KEY
10	S214BIW2	MATNR	MARA	MATNR	KEY
11	S214BIW2	PSWAE	TCURC	WAERS		1	CN
12	S214BIW2	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050705
SAP Release Created in	600