SAP ABAP Table S214 (CatMan: Indizees für ROP)

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	S214	Table Relationship Diagram
Short Description	CatMan: Indizees für ROP

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	HIER_ID	☑	HIER_CNT	HIERCNT	CHAR	2	0	Hierarchy ID
9	CDT1	☑	CM_CDT1	CM_CDT	CHAR	18	0	Category	CMMD_CDT1
10	CDT2	☑	CM_CDT2	CM_CDT	CHAR	18	0	Subcategory	CMMD_CDT2
11	CDT3	☑	CM_CDT3	CM_CDT	CHAR	18	0	Segment	CMMD_CDT3
12	CDT4	☑	CM_CDT4	CM_CDT	CHAR	18	0	Subsegment	CMMD_CDT4
13	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
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	S214	BASME	T006	MSEHI
2	S214	CDT1	CMMD_CDT1	CDT1	KEY
3	S214	CDT2	CMMD_CDT2	CDT2	KEY
4	S214	CDT3	CMMD_CDT3	CDT3	KEY
5	S214	CDT4	CMMD_CDT4	CDT4	KEY
6	S214	CDT5	CMMD_CDT5	CDT5
7	S214	CDT6	CMMD_CDT6	CDT6
8	S214	CDT7	CMMD_CDT7	CDT7
9	S214	MANDT	T000	MANDT	KEY
10	S214	MATNR	MARA	MATNR	KEY
11	S214	PSWAE	TCURC	WAERS		1	CN
12	S214	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050825
SAP Release Created in	1999_1_46C