S160 - Perishables
Perishables information is stored in SAP table S160.
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 S160
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 | |
EKGRP | Purchasing Group | X | EKGRP | CHAR | 6 | T024 |
WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
BTRKZ | Plant category | X | VLFKZ | CHAR | 2 | |
LIFNR | Vendor's account number | X | ELIFN | CHAR | 20 | LFA1 |
MATKL | Material Group | X | MATKL | CHAR | 18 | T023 |
SATNR | Cross-Plant Configurable Material | X | SATNR | CHAR | 80 | MARA |
MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | ||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
BASME | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
HWAER | Local Currency | HWAER | CUKY | 10 | TCURC | |
BVLMNG | Order volume quantity Retail | MCW_BVLMNG | QUAN | 8 | ||
BVLGEO | Order volume at cost | MCW_BVLGEO | CURR | 10 | ||
BVLGVO | Order volume at retail | MCW_BVLGVO | CURR | 10 | ||
BVLGVP | Order volume at retail with tax | MCW_BVLGVP | CURR | 10 | ||
WESMNG | Goods receipt (vendor) quantity in BUn | MCW_WESMNG | QUAN | 8 | ||
WESGEO | Goods receipt (vendor) at cost | MCW_WESGEO | CURR | 10 | ||
WESGVO | Goods receipt (vendor) at retail | MCW_WESGVO | CURR | 10 | ||
WESGVP | Goods receipt (vendor) at retail with tax | MCW_WESGVP | CURR | 10 | ||
RTEMNG | Returns to vendor quantity in base unit of measure | MCW_RTEMNG | QUAN | 8 | ||
RTEGEO | Returns to vendor at cost | MCW_RTEGEO | CURR | 10 | ||
RTEGVO | Returns to vendor at retail | MCW_RTEGVO | CURR | 10 | ||
RTEGVP | Returns to vendor at retail with tax | MCW_RTEGVP | CURR | 10 | ||
ULVMNG | Stock transport order quantity | MCW_ULVMNG | QUAN | 8 | ||
ULVGEO | Stock transport order at cost | MCW_ULVGEO | CURR | 10 | ||
ULVGVO | Stock transport order at retail | MCW_ULVGVO | CURR | 10 | ||
ULVGVP | Stock transport order at retail with tax | MCW_ULVGVP | CURR | 10 | ||
UAVMNG | Stock transport order 2 (supplying site view), quantity | MCW_UAVMNG | QUAN | 8 | ||
UAVGEO | Stock transport order 2 (supplying site view) at cost | MCW_UAVGEO | CURR | 10 | ||
UAVGVO | Stock transport order 2 (supplying site view) at retail | MCW_UAVGVO | CURR | 10 | ||
UAVGVP | Stock transport order 2 (supplying site view) at retail w/T | MCW_UAVGVP | CURR | 10 | ||
KMAMNG | Goods issue (distribution center) quantity in BUn | MCW_KMAMNG | QUAN | 8 | ||
KMAGEO | Goods issue (DC) at cost | MCW_KMAGEO | CURR | 10 | ||
KMAGVO | Goods issue (DC) at retail | MCW_KMAGVO | CURR | 10 | ||
KMAGVP | Goods issue (dist. center) at retail with tax | MCW_KMAGVP | CURR | 10 | ||
KMEMNG | Goods receipt (distribution center) quantity in BUn | MCW_KMEMNG | QUAN | 8 | ||
KMEGEO | Goods receipt (DC) at cost | MCW_KMEGEO | CURR | 10 | ||
KMEGVO | Goods receipt (DC) at retail | MCW_KMEGVO | CURR | 10 | ||
KMEGVP | Goods receipt (dist. center) at retail with tax | MCW_KMEGVP | CURR | 10 | ||
ULAMNG | Goods clearing: issues quantity in BUn | MCW_ULAMNG | QUAN | 8 | ||
ULAGEO | Goods clearing: issues at cost | MCW_ULAGEO | CURR | 10 | ||
ULAGVO | Goods clearing: issues at retail | MCW_ULAGVO | CURR | 10 | ||
ULAGVP | Goods clearing: issues at retail with tax | MCW_ULAGVP | CURR | 10 | ||
ULEMNG | Goods clearing: receipts quantity in BUn | MCW_ULEMNG | QUAN | 8 | ||
ULEGEO | Goods clearing: receipts at cost | MCW_ULEGEO | CURR | 10 | ||
ULEGVO | Goods clearing: receipts at retail | MCW_ULEGVO | CURR | 10 | ||
ULEGVP | Goods clearing: receipts at retail with tax | MCW_ULEGVP | CURR | 10 | ||
BKSMMG | Stock adjustment miscellaneous minus (quantity) | MCW_BKSMMG | QUAN | 8 | ||
BKSMEO | Stock adjustment miscellaneous minus (cost) | MCW_BKSMEO | CURR | 10 | ||
BKSMVO | Stock adjustment miscellaneous minus (retail) | MCW_BKSMVO | CURR | 10 | ||
BKSMVP | Stock adjustment miscellaneous minus (retail with tax) | MCW_BKSMVP | CURR | 10 | ||
UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 8 | ||
UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 10 | ||
UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 10 | ||
UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 10 | ||
PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 10 | ||
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 | ||
LIFMNG | Deliveries to customers, quantity | MCW_LIFMNG | QUAN | 8 | ||
ABTNR | Department number | ABTNR | CHAR | 8 | TSAB | |
MERK1 | Characteristic 1 | MCW_MERK1 | CHAR | 140 | ||
MERK2 | Characteristic 2 | MCW_MERK2 | CHAR | 140 | ||
MERK3 | Characteristic 3 | MCW_MERK3 | CHAR | 140 | ||
ATINM1 | Internal characteristic number, characteristic 1 | MCW_ATINM1 | NUMC | 20 | ||
ATINM2 | Internal characteristic number, characteristic 2 | MCW_ATINM2 | NUMC | 20 | ||
ATINM3 | Internal characteristic number, characteristic 3 | MCW_ATINM3 | NUMC | 20 |