Menu

SAP Table S123

Customer / material group

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