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