SAP Table S123
Customer / material group
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table S123 (Customer / material group) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S123 |
| Short Text | Customer / material group |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S123
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| EKORG | ✔ | Purchasing Organization | EKORG | CHAR | 4 | T024E |
| VKORG | ✔ | Sales Organization | VKORG | CHAR | 4 | TVKO |
| VTWEG | ✔ | Distribution Channel | VTWEG | CHAR | 2 | TVTW |
| BZIRK | ✔ | Sales district | BZIRK | CHAR | 6 | T171 |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| KUNAG | ✔ | Sold-to party | KUNAG | CHAR | 10 | KNA1 |
| WGRU2 | ✔ | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 18 | |
| WGRU1 | ✔ | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 18 | |
| MATKL | ✔ | Material Group | MATKL | CHAR | 9 | T023 |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | |
| KAVMNG | Sales order volume quantity | MCW_KAVMNG | QUAN | 15 | ||
| KAVGEO | Sales order volume at cost | MCW_KAVGEO | CURR | 19 | ||
| KAVGVO | Sales order volume at retail | MCW_KAVGVO | CURR | 19 | ||
| KAVGVP | Sales order volume at retail with tax | MCW_KAVGVP | CURR | 19 | ||
| KAVANZ | Sales order volume number of transactions | MCW_KAVANZ | INT4 | 10 | ||
| RAVMNG | Return orders quantity | MCW_RAVMNG | QUAN | 15 | ||
| RAVGEO | Return orders at cost | MCW_RAVGEO | CURR | 19 | ||
| RAVGVO | Return orders at retail | MCW_RAVGVO | CURR | 19 | ||
| RAVGVP | Return orders at retail with tax | MCW_RAVGVP | CURR | 19 | ||
| RAVANZ | Return orders, no. of transactions | MCW_RAVANZ | INT4 | 10 | ||
| SAVMNG | Third-party orders quantity | MCW_SAVMNG | QUAN | 15 | ||
| SAVGEO | Third-party orders at cost | MCW_SAVGEO | CURR | 19 | ||
| SAVGVO | Third party orders at retail | MCW_SAVGVO | CURR | 19 | ||
| SAVGVP | Third-party orders at retail with tax | MCW_SAVGVP | CURR | 19 | ||
| SAVANZ | Third-party order, no. of transactions | MCW_SAVANZ | INT4 | 10 | ||
| LIFMNG | Deliveries to customers, quantity | MCW_LIFMNG | QUAN | 15 | ||
| LIFANZ | Deliveries to customers, no. of transactions | MCW_LIFANZ | INT4 | 10 | ||
| RLFMNG | Return deliveries from customer, quantity | MCW_RLFMNG | QUAN | 15 | ||
| RLFANZ | Return deliveries from customer, no. of transactions | MCW_RLFANZ | INT4 | 10 | ||
| OAVMNG | On-order quantity IS-R | MCW_OAVMNG | QUAN | 15 | ||
| OAVWRT | On-order value IS-R | MCW_OAVWRT | CURR | 19 | ||
| UMAMNG | Sales (absolute) quantity in BUn | MCW_UMAMNG | QUAN | 15 | ||
| UMAGEO | Sales (absolute) at cost | MCW_UMAGEO | CURR | 19 | ||
| UMAGVO | Sales (absolute) at retail | MCW_UMAGVO | CURR | 19 | ||
| UMAGVP | Sales (absolute) at retail with tax | MCW_UMAGVP | CURR | 19 | ||
| PRSNLA | Sales deviation (absolute) during sales | MCW_PRSNLA | CURR | 19 | ||
| AUMMNG | Promotion sales quantity in BUn | MCW_AUMMNG | QUAN | 15 | ||
| AUMGEO | Promotion sales at cost | MCW_AUMGEO | CURR | 19 | ||
| AUMGVO | Promotion sales at retail | MCW_AUMGVO | CURR | 19 | ||
| AUMGVP | Promotion sales at retail with tax | MCW_AUMGVP | CURR | 19 | ||
| GUTMNG | Credit memo quantity in BUn | MCW_GUTMNG | QUAN | 15 | ||
| GUTGEO | Credit memo at cost | MCW_GUTGEO | CURR | 19 | ||
| GUTGVO | Credit memo at retail | MCW_GUTGVO | CURR | 19 | ||
| GUTGVP | Credit memo at retail with tax | MCW_GUTGVP | CURR | 19 | ||
| GUTNLS | Credit memo deviation at sale | MCW_GUTNLS | CURR | 19 | ||
| UMSMNG | Third-party sales quantity in BUn | MCW_SUMMNG | QUAN | 15 | ||
| UMSGEO | Third-party sales at cost | MCW_SUMGEO | CURR | 19 | ||
| UMSGVO | Third-party sales at retail | MCW_SUMGVO | CURR | 19 | ||
| UMSGVP | Third-party sales at retail with tax | MCW_SUMGVP | CURR | 19 | ||
| PRSNLS | Third-party sales deviation | MCW_SPRSNL | CURR | 19 | ||
| KAVMAM | Sales order volume margin with tax | MCW_KAVMAM | DEC | 6 | ||
| KAVMAO | Sales order volume margin | MCW_KAVMAO | DEC | 6 | ||
| SAVMAM | Third-party order margin w/tax | MCW_SAVMAM | DEC | 6 | ||
| SAVMAO | Third-party order margin | MCW_SAVMAO | DEC | 6 | ||
| UMSMAO | Sales margin | MCW_UMSMAO | DEC | 6 | ||
| UMSMAM | Sales margin with tax | MCW_UMSMAM | DEC | 6 | ||
| AUMMAO | Promotion sales margin | MCW_AUMMAO | DEC | 6 | ||
| AUMMAM | Promotion sales margin with tax | MCW_AUMMAM | DEC | 6 | ||
| KUNRG | Payer | KUNRG | CHAR | 10 | KNA1 | |
| KDGRP | Customer group | KDGRP | CHAR | 2 | T151 |