S123 - Customer / material group
Customer / material group information is stored in SAP table S123.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S123
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 4 | |
| 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 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 6 | |
| EKORG | Purchasing organization | X | EKORG | CHAR | 4 | T024E |
| VKORG | Sales Organization | X | VKORG | CHAR | 4 | TVKO |
| VTWEG | Distribution Channel | X | VTWEG | CHAR | 2 | TVTW |
| BZIRK | Sales District | X | BZIRK | CHAR | 6 | T171 |
| WERKS | Plant | X | WERKS_D | CHAR | 4 | T001W |
| KUNAG | Sold-to Party | X | KUNAG | CHAR | 10 | KNA1 |
| WGRU2 | Material group hierarchy 2 | X | MCW_WGRU2 | CHAR | 18 | |
| WGRU1 | Material group hierarchy 1 | X | MCW_WGRU1 | CHAR | 18 | |
| MATKL | Material Group | X | 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 | 8 | ||
| KAVGEO | Sales order volume at cost | MCW_KAVGEO | CURR | 10 | ||
| KAVGVO | Sales order volume at retail | MCW_KAVGVO | CURR | 10 | ||
| KAVGVP | Sales order volume at retail with tax | MCW_KAVGVP | CURR | 10 | ||
| KAVANZ | Sales order volume number of transactions | MCW_KAVANZ | INT4 | 4 | ||
| RAVMNG | Return orders quantity | MCW_RAVMNG | QUAN | 8 | ||
| RAVGEO | Return orders at cost | MCW_RAVGEO | CURR | 10 | ||
| RAVGVO | Return orders at retail | MCW_RAVGVO | CURR | 10 | ||
| RAVGVP | Return orders at retail with tax | MCW_RAVGVP | CURR | 10 | ||
| RAVANZ | Return orders, no. of transactions | MCW_RAVANZ | INT4 | 4 | ||
| SAVMNG | Third-party orders quantity | MCW_SAVMNG | QUAN | 8 | ||
| SAVGEO | Third-party orders at cost | MCW_SAVGEO | CURR | 10 | ||
| SAVGVO | Third party orders at retail | MCW_SAVGVO | CURR | 10 | ||
| SAVGVP | Third-party orders at retail with tax | MCW_SAVGVP | CURR | 10 | ||
| SAVANZ | Third-party order, no. of transactions | MCW_SAVANZ | INT4 | 4 | ||
| LIFMNG | Deliveries to customers, quantity | MCW_LIFMNG | QUAN | 8 | ||
| LIFANZ | Deliveries to customers, no. of transactions | MCW_LIFANZ | INT4 | 4 | ||
| RLFMNG | Return deliveries from customer, quantity | MCW_RLFMNG | QUAN | 8 | ||
| RLFANZ | Return deliveries from customer, no. of transactions | MCW_RLFANZ | INT4 | 4 | ||
| OAVMNG | On-order quantity IS-R | MCW_OAVMNG | QUAN | 8 | ||
| OAVWRT | On-order value IS-R | MCW_OAVWRT | CURR | 10 | ||
| UMAMNG | Sales (absolute) quantity in BUn | MCW_UMAMNG | QUAN | 8 | ||
| UMAGEO | Sales (absolute) at cost | MCW_UMAGEO | CURR | 10 | ||
| UMAGVO | Sales (absolute) at retail | MCW_UMAGVO | CURR | 10 | ||
| UMAGVP | Sales (absolute) at retail with tax | MCW_UMAGVP | CURR | 10 | ||
| PRSNLA | Sales deviation (absolute) during sales | MCW_PRSNLA | CURR | 10 | ||
| AUMMNG | Promotion sales quantity in BUn | MCW_AUMMNG | QUAN | 8 | ||
| AUMGEO | Promotion sales at cost | MCW_AUMGEO | CURR | 10 | ||
| AUMGVO | Promotion sales at retail | MCW_AUMGVO | CURR | 10 | ||
| AUMGVP | Promotion sales at retail with tax | MCW_AUMGVP | CURR | 10 | ||
| GUTMNG | Credit memo quantity in BUn | MCW_GUTMNG | QUAN | 8 | ||
| GUTGEO | Credit memo at cost | MCW_GUTGEO | CURR | 10 | ||
| GUTGVO | Credit memo at retail | MCW_GUTGVO | CURR | 10 | ||
| GUTGVP | Credit memo at retail with tax | MCW_GUTGVP | CURR | 10 | ||
| GUTNLS | Credit memo deviation at sale | MCW_GUTNLS | CURR | 10 | ||
| UMSMNG | Third-party sales quantity in BUn | MCW_SUMMNG | QUAN | 8 | ||
| UMSGEO | Third-party sales at cost | MCW_SUMGEO | CURR | 10 | ||
| UMSGVO | Third-party sales at retail | MCW_SUMGVO | CURR | 10 | ||
| UMSGVP | Third-party sales at retail with tax | MCW_SUMGVP | CURR | 10 | ||
| PRSNLS | Third-party sales deviation | MCW_SPRSNL | CURR | 10 | ||
| KAVMAM | Sales order volume margin with tax | MCW_KAVMAM | DEC | 4 | ||
| KAVMAO | Sales order volume margin | MCW_KAVMAO | DEC | 4 | ||
| SAVMAM | Third-party order margin w/tax | MCW_SAVMAM | DEC | 4 | ||
| SAVMAO | Third-party order margin | MCW_SAVMAO | DEC | 4 | ||
| UMSMAO | Sales margin | MCW_UMSMAO | DEC | 4 | ||
| UMSMAM | Sales margin with tax | MCW_UMSMAM | DEC | 4 | ||
| AUMMAO | Promotion sales margin | MCW_AUMMAO | DEC | 4 | ||
| AUMMAM | Promotion sales margin with tax | MCW_AUMMAM | DEC | 4 | ||
| KUNRG | Payer | KUNRG | CHAR | 10 | KNA1 | |
| KDGRP | Customer Group | KDGRP | CHAR | 2 | T151 |