S087 - Material/add-on
Material/add-on information is stored in SAP table S087.
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 S087
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 | |
| 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 |
| 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 | |
| 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 | ||
| RTEANZ | Returns to vendor, no. of transactions | MCW_RTEANZ | INT4 | 4 | ||
| 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 | ||
| ULEANZ | Goods clearing: receipts, no. of transactions | MCW_ULEANZ | INT4 | 4 | ||
| 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 | ||
| ULAANZ | Goods clearing: issues, no. of transactions | MCW_ULAANZ | INT4 | 4 | ||
| AUEMNG | Material transfer: receipts quantity BUn | MCW_AUEMNG | QUAN | 8 | ||
| AUEGEO | Material transfer: receipts at cost | MCW_AUEGEO | CURR | 10 | ||
| AUEGVO | Material transfer: receipts at retail | MCW_AUEGVO | CURR | 10 | ||
| AUEGVP | Material transfer: receipts at retail with tax | MCW_AUEGVP | CURR | 10 | ||
| AUEANZ | Material transfer: receipts, no. transactions | MCW_AUEANZ | INT4 | 4 | ||
| AUAMNG | Material transfer: issues quantity BUn | MCW_AUAMNG | QUAN | 8 | ||
| AUAGEO | Material transfer: issues at cost | MCW_AUAGEO | CURR | 10 | ||
| AUAGVO | Material transfer: issues at retail | MCW_AUAGVO | CURR | 10 | ||
| AUAGVP | Material transfer: issues at retail with tax | MCW_AUAGVP | CURR | 10 | ||
| AUAANZ | Material transfer: issues, no. of transactions | MCW_AUAANZ | INT4 | 4 | ||
| BKIPMG | Stock adjustment inventory difference plus (quantity) | MCW_BKIPMG | QUAN | 8 | ||
| BKIPEO | Stock adjustment inventory difference plus (cost) | MCW_BKIPEO | CURR | 10 | ||
| BKIPVO | Stock adjustment inventory difference plus (retail) | MCW_BKIPVO | CURR | 10 | ||
| BKIPVP | Stock adjustment inventory difference plus (at retail w/tax) | MCW_BKIPVP | CURR | 10 | ||
| BKIPAZ | Stock adjustment inv. difference plus (no. of transactions) | MCW_BKIPAZ | INT4 | 4 | ||
| BKIMMG | Stock adjustment inventory difference minus (quantity) | MCW_BKIMMG | QUAN | 8 | ||
| BKIMEO | Stock adjustment inventory difference minus (cost) | MCW_BKIMEO | CURR | 10 | ||
| BKIMVO | Stock adjustment inventory difference minus (retail) | MCW_BKIMVO | CURR | 10 | ||
| BKIMVP | Stock adjustment inventory difference minus (retail w/tax) | MCW_BKIMVP | CURR | 10 | ||
| BKIMAZ | Stock adjustment inv. difference minus (no. of transactions) | MCW_BKIMAZ | INT4 | 4 | ||
| BKSPMG | Stock adjustment miscellaneous plus (quantity) | MCW_BKSPMG | QUAN | 8 | ||
| BKSPEO | Stock adjustment miscellaneous plus (cost) | MCW_BKSPEO | CURR | 10 | ||
| BKSPVO | Stock adjustment miscellaneous plus (retail) | MCW_BKSPVO | CURR | 10 | ||
| BKSPVP | Stock adjustment miscellaneous plus (retail with tax) | MCW_BKSPVP | CURR | 10 | ||
| BKSPAZ | Stock adjustment miscellaneous plus (no. of transactions) | MCW_BKSPAZ | INT4 | 4 | ||
| 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 | ||
| BKSMAZ | Stock adjustment miscellaneous minus (no. of transactions) | MCW_BKSMAZ | INT4 | 4 | ||
| UBPEPM | Revaluation at cost, plus, quantity | MCW_UBPEPM | QUAN | 8 | ||
| UBPGEO | Revaluation at cost, plus | MCW_UBPGEO | CURR | 10 | ||
| UBPEAZ | Revaluation at cost plus, no. of transactions | MCW_UBPEAZ | INT4 | 4 | ||
| UBMEPM | Revaluation at cost minus, quantity | MCW_UBMEPM | QUAN | 8 | ||
| UBMGEO | Revaluation at cost, minus | MCW_UBMGEO | CURR | 10 | ||
| UBMEAZ | Revaluation at cost minus, no. of transactions | MCW_UBMEAZ | INT4 | 4 |