S212BIW1 - S212BIW1 * CatMan: High Level
S212BIW1 * CatMan: High Level information is stored in SAP table S212BIW1.
It is part of development package CM_MAP in software component LO-RFM-OBS. This development package consists of objects that can be grouped under "Category Management - MAP".
It is part of development package CM_MAP in software component LO-RFM-OBS. This development package consists of objects that can be grouped under "Category Management - MAP".
Fields for table S212BIW1
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 6 | |
| HIER_ID | Hierarchy ID | X | HIER_CNT | CHAR | 2 | |
| CDT1 | Category | X | CM_CDT1 | CHAR | 18 | CMMD_CDT1 |
| CDT2 | Subcategory | X | CM_CDT2 | CHAR | 18 | CMMD_CDT2 |
| CDT3 | Segment | X | CM_CDT3 | CHAR | 18 | CMMD_CDT3 |
| CDT4 | Subsegment | X | CM_CDT4 | CHAR | 18 | CMMD_CDT4 |
| CDT5 | Sub-Subsegment | X | CM_CDT5 | CHAR | 18 | CMMD_CDT5 |
| CDT6 | Product Group | X | CM_CDT6 | CHAR | 18 | CMMD_CDT6 |
| CDT7 | Brand | X | CM_CDT7 | CHAR | 18 | CMMD_CDT7 |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 3 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 6 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 8 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 6 | |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 4 | |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| PSWAE | Database Currency for Planning Data in a Planning Scenario | WISP_PSWAE | CUKY | 5 | TCURC | |
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| BSTGEO | Stock at cost | MCW_BSTGEO | CURR | 10 | ||
| UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 10 | ||
| UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 10 | ||
| UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 10 | ||
| CM_UMMKT_E | Market Turnover (External) | CM_UMMKT_E | CURR | 10 | ||
| CM_AZPRM | Number of Article Promotions | CM_AZPRM | DEC | 5 | ||
| CM_PTRTC_E | Penetration Amongst Target Customers (External) | CM_PTRTC_E | DEC | 4 | ||
| CM_PFQTC_E | Purchasing Frequency of Target Customers (External) | CM_PFQTC_E | DEC | 4 | ||
| CM_UMSVO_E | Sales at Sales Price (External) | CM_UMSVO_E | CURR | 10 | ||
| CM_TAVAL_E | Average Value of the Shopping Basket (External) | CM_TAVAL_E | CURR | 10 | ||
| CM_UMSTC_E | Target-Customer Sales (External) | CM_UMSTC_E | CURR | 10 | ||
| CM_PFQ_E | Purchasing Frequency (External) | CM_PFQ_E | DEC | 4 | ||
| CM_AZART | Number of Articles | CM_AZART | DEC | 6 | ||
| CM_ABDSG_E | Market Coverage for Segment Level (External) | CM_ABDSG_E | DEC | 4 | ||
| CM_ABDSS_E | Market Coverage for Subsegment Level (External) | CM_ABDSS_E | DEC | 4 | ||
| CM_CLOSR_E | Closure Rate (External) | CM_CLOSR_E | DEC | 4 | ||
| CM_STREV_E | Number of Store Visits per Customer | CM_STREV_E | DEC | 4 | ||
| BKIMVO | Stock adjustment inventory difference minus (retail) | MCW_BKIMVO | CURR | 10 | ||
| CM_SHLFSPC | Shelf Space | CM_SHLFSPC | DEC | 5 | ||
| CM_CUSTF_E | Customer Satisfaction (External) | CM_CUSTF_E | DEC | 4 | ||
| CM_AZKON_E | Number of Consumers (External) | CM_AZKON_E | DEC | 6 | ||
| CM_AZKUN_E | Number of Customers (External) | CM_AZKUN_E | DEC | 6 | ||
| CM_MGRWT_E | Market Growth (External) | CM_MGRWT_E | DEC | 4 | ||
| CM_AVGPR_E | Average Price per Article (External) | CM_AVGPR_E | CURR | 4 | ||
| CM_AVGUB_E | Average Number of Articles per Purchase (External) | CM_AVGUB_E | DEC | 4 | ||
| CM_PENTR_E | Penetration (External) | CM_PENTR_E | DEC | 4 | ||
| AUMMNG | Promotion sales quantity in BUn | MCW_AUMMNG | QUAN | 8 | ||
| AUMGVO | Promotion sales at retail | MCW_AUMGVO | CURR | 10 | ||
| AUMGEO | Promotion sales at cost | MCW_AUMGEO | CURR | 10 |