SAP Table S121
Material aggregation - POS
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table S121 (Material aggregation - POS) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S121 |
| Short Text | Material aggregation - POS |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S121
| 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 | |
| MATKL | ✔ | Material Group | MATKL | CHAR | 9 | T023 |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| KSCHL | ✔ | Condition type, sales | V_KSCHA | CHAR | 4 | T685 |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | |
| UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | QUAN | 15 | ||
| UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | W_UMSVPM | CURR | 19 | ||
| UMSGVO | Rtl price from sales as per receipts/aggreg.sales | W_UMSVPO | CURR | 19 | ||
| UMSGEO | Sales transactions (till receipts) at cost | W_UMSEP | CURR | 19 | ||
| PRSNLS | Price reduction | W_PRSNL | CURR | 19 | ||
| PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | W_PDIFF | CURR | 19 | ||
| BZIRK | Sales district | W_BEZIRK | CHAR | 6 | T171 |