SAP ABAP Table S212BIW2 (S212BIW2 * CatMan: High Level)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ LO-MAP (Application Component) Merchandise and Assortment Planning
⤷ CM_MAP (Package) Category Management - MAP
⤷ LO-MAP (Application Component) Merchandise and Assortment Planning
⤷ CM_MAP (Package) Category Management - MAP
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | S212BIW2 | Table Relationship Diagram |
Short Description | S212BIW2 * CatMan: High Level |
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 | CDT5 | CM_CDT5 | CM_CDT | CHAR | 18 | 0 | Sub-Subsegment | CMMD_CDT5 | |
9 | CDT6 | CM_CDT6 | CM_CDT | CHAR | 18 | 0 | Product Group | CMMD_CDT6 | |
10 | CDT7 | CM_CDT7 | CM_CDT | CHAR | 18 | 0 | Brand | CMMD_CDT7 | |
11 | VRSIO | VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
12 | SPMON | SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
13 | SPTAG | SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
14 | SPWOC | SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
15 | SSOUR | SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
16 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
17 | VWDAT | VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
18 | PSWAE | WISP_PSWAE | WAERS | CUKY | 5 | 0 | Database Currency for Planning Data in a Planning Scenario | TCURC | |
19 | BASME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
20 | BSTGEO | MCW_BSTGEO | WERTV10 | CURR | 19 | 2 | Stock at cost | ||
21 | UMSGVO | MCW_UMSGVO | WERTV10 | CURR | 19 | 2 | Sales at retail | ||
22 | UMSGVP | MCW_UMSGVP | WERTV10 | CURR | 19 | 2 | Sales at retail with tax | ||
23 | UMSGEO | MCW_UMSGEO | WERTV10 | CURR | 19 | 2 | Sales at cost | ||
24 | CM_UMMKT_E | CM_UMMKT_E | WERTV10 | CURR | 19 | 2 | Market Turnover (External) | ||
25 | CM_AZPRM | CM_AZPRM | DEC8 | DEC | 8 | 0 | Number of Article Promotions | ||
26 | CM_PTRTC_E | CM_PTRTC_E | DEC3_3 | DEC | 6 | 3 | Penetration Amongst Target Customers (External) | ||
27 | CM_PFQTC_E | CM_PFQTC_E | DEC3_3 | DEC | 6 | 3 | Purchasing Frequency of Target Customers (External) | ||
28 | CM_UMSVO_E | CM_UMSVO_E | WERTV10 | CURR | 19 | 2 | Sales at Sales Price (External) | ||
29 | CM_TAVAL_E | CM_TAVAL_E | WERTV10 | CURR | 19 | 2 | Average Value of the Shopping Basket (External) | ||
30 | CM_UMSTC_E | CM_UMSTC_E | WERTV10 | CURR | 19 | 2 | Target-Customer Sales (External) | ||
31 | CM_PFQ_E | CM_PFQ_E | DEC3_3 | DEC | 6 | 3 | Purchasing Frequency (External) | ||
32 | CM_AZART | CM_AZART | DEC8_3 | DEC | 11 | 3 | Number of Articles | ||
33 | CM_ABDSG_E | CM_ABDSG_E | DEC3_3 | DEC | 6 | 3 | Market Coverage for Segment Level (External) | ||
34 | CM_ABDSS_E | CM_ABDSS_E | DEC3_3 | DEC | 6 | 3 | Market Coverage for Subsegment Level (External) | ||
35 | CM_CLOSR_E | CM_CLOSR_E | DEC3_3 | DEC | 6 | 3 | Closure Rate (External) | ||
36 | CM_STREV_E | CM_STREV_E | DEC3_3 | DEC | 6 | 3 | Number of Store Visits per Customer | ||
37 | BKIMVO | MCW_BKIMVO | WERTV10 | CURR | 19 | 2 | Stock adjustment inventory difference minus (retail) | ||
38 | CM_SHLFSPC | CM_SHLFSPC | DEC | 8 | 3 | Shelf Space | |||
39 | CM_CUSTF_E | CM_CUSTF_E | DEC3_3 | DEC | 6 | 3 | Customer Satisfaction (External) | ||
40 | CM_AZKON_E | CM_AZKON_E | DEC8_3 | DEC | 11 | 3 | Number of Consumers (External) | ||
41 | CM_AZKUN_E | CM_AZKUN_E | DEC8_3 | DEC | 11 | 3 | Number of Customers (External) | ||
42 | CM_MGRWT_E | CM_MGRWT_E | DECV3_3 | DEC | 6 | 3 | Market Growth (External) | ||
43 | CM_AVGPR_E | CM_AVGPR_E | WERT4 | CURR | 7 | 2 | Average Price per Article (External) | ||
44 | CM_AVGUB_E | CM_AVGUB_E | DEC | 7 | 3 | Average Number of Articles per Purchase (External) | |||
45 | CM_PENTR_E | CM_PENTR_E | DEC3_3 | DEC | 6 | 3 | Penetration (External) | ||
46 | AUMMNG | MCW_AUMMNG | MENGV15_3 | QUAN | 15 | 3 | Promotion sales quantity in BUn | ||
47 | AUMGVO | MCW_AUMGVO | WERTV10 | CURR | 19 | 2 | Promotion sales at retail | ||
48 | AUMGEO | MCW_AUMGEO | WERTV10 | CURR | 19 | 2 | Promotion sales at cost |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | S212BIW2 | BASME | T006 | MSEHI | |||
2 | S212BIW2 | CDT1 | CMMD_CDT1 | CDT1 | KEY | ||
3 | S212BIW2 | CDT2 | CMMD_CDT2 | CDT2 | KEY | ||
4 | S212BIW2 | CDT3 | CMMD_CDT3 | CDT3 | KEY | ||
5 | S212BIW2 | CDT4 | CMMD_CDT4 | CDT4 | KEY | ||
6 | S212BIW2 | CDT5 | CMMD_CDT5 | CDT5 | KEY | ||
7 | S212BIW2 | CDT6 | CMMD_CDT6 | CDT6 | KEY | ||
8 | S212BIW2 | CDT7 | CMMD_CDT7 | CDT7 | KEY | ||
9 | S212BIW2 | MANDT | T000 | MANDT | KEY | ||
10 | S212BIW2 | PSWAE | TCURC | WAERS | 1 | CN |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in | 1999_1_46C |