S121 - Material aggregation - POS
Material aggregation - POS information is stored in SAP table S121.
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 S121
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| MATKL | Material Group | X | MATKL | CHAR | 18 | T023 |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| AKTNR | Promotion | X | WAKTION | CHAR | 20 | WAKH |
| KSCHL | Condition type, sales | X | V_KSCHA | CHAR | 8 | T685 |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| WAERK | SD Document Currency | WAERK | CUKY | 10 | TCURC | |
| UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | QUAN | 8 | ||
| UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | W_UMSVPM | CURR | 10 | ||
| UMSGVO | Rtl price from sales as per receipts/aggreg.sales | W_UMSVPO | CURR | 10 | ||
| UMSGEO | Sales transactions (till receipts) at cost | W_UMSEP | CURR | 10 | ||
| PRSNLS | Price reduction | W_PRSNL | CURR | 10 | ||
| PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | W_PDIFF | CURR | 10 | ||
| BZIRK | Sales district | W_BEZIRK | CHAR | 12 | T171 |