| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 8 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 9 | BTRKZ | Plant category | char | 1 | 0 | CHAR | (N' ') | No | | VLFKZ | Allow NULL? |
| 10 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | ELIFN | Allow NULL? |
| 11 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 12 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 13 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 14 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 15 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 16 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 17 | RTEMNG | Returns to vendor quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_RTEMNG | |
| 18 | RTEGEO | Returns to vendor at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGEO | |
| 19 | RTEGVO | Returns to vendor at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGVO | |
| 20 | RTEGVP | Returns to vendor at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGVP | |
| 21 | RTEANZ | Returns to vendor, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_RTEANZ | Allow NULL? |
| 22 | ULEMNG | Goods clearing: receipts quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ULEMNG | |
| 23 | ULEGEO | Goods clearing: receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGEO | |
| 24 | ULEGVO | Goods clearing: receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGVO | |
| 25 | ULEGVP | Goods clearing: receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGVP | |
| 26 | ULEANZ | Goods clearing: receipts, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ULEANZ | Allow NULL? |
| 27 | ULAMNG | Goods clearing: issues quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ULAMNG | |
| 28 | ULAGEO | Goods clearing: issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGEO | |
| 29 | ULAGVO | Goods clearing: issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGVO | |
| 30 | ULAGVP | Goods clearing: issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGVP | |
| 31 | ULAANZ | Goods clearing: issues, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ULAANZ | Allow NULL? |
| 32 | AUEMNG | Material transfer: receipts quantity BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_AUEMNG | |
| 33 | AUEGEO | Material transfer: receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUEGEO | |
| 34 | AUEGVO | Material transfer: receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUEGVO | |
| 35 | AUEGVP | Material transfer: receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUEGVP | |
| 36 | AUEANZ | Material transfer: receipts, no. transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_AUEANZ | Allow NULL? |
| 37 | AUAMNG | Material transfer: issues quantity BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_AUAMNG | |
| 38 | AUAGEO | Material transfer: issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUAGEO | |
| 39 | AUAGVO | Material transfer: issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUAGVO | |
| 40 | AUAGVP | Material transfer: issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUAGVP | |
| 41 | AUAANZ | Material transfer: issues, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_AUAANZ | Allow NULL? |
| 42 | BKIPMG | Stock adjustment inventory difference plus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKIPMG | |
| 43 | BKIPEO | Stock adjustment inventory difference plus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIPEO | |
| 44 | BKIPVO | Stock adjustment inventory difference plus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIPVO | |
| 45 | BKIPVP | Stock adjustment inventory difference plus (at retail w/tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIPVP | |
| 46 | BKIPAZ | Stock adjustment inv. difference plus (no. of transactions) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BKIPAZ | Allow NULL? |
| 47 | BKIMMG | Stock adjustment inventory difference minus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKIMMG | |
| 48 | BKIMEO | Stock adjustment inventory difference minus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMEO | |
| 49 | BKIMVO | Stock adjustment inventory difference minus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMVO | |
| 50 | BKIMVP | Stock adjustment inventory difference minus (retail w/tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMVP | |
| 51 | BKIMAZ | Stock adjustment inv. difference minus (no. of transactions) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BKIMAZ | Allow NULL? |
| 52 | BKSPMG | Stock adjustment miscellaneous plus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKSPMG | |
| 53 | BKSPEO | Stock adjustment miscellaneous plus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSPEO | |
| 54 | BKSPVO | Stock adjustment miscellaneous plus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSPVO | |
| 55 | BKSPVP | Stock adjustment miscellaneous plus (retail with tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSPVP | |
| 56 | BKSPAZ | Stock adjustment miscellaneous plus (no. of transactions) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BKSPAZ | Allow NULL? |
| 57 | BKSMMG | Stock adjustment miscellaneous minus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKSMMG | |
| 58 | BKSMEO | Stock adjustment miscellaneous minus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSMEO | |
| 59 | BKSMVO | Stock adjustment miscellaneous minus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSMVO | |
| 60 | BKSMVP | Stock adjustment miscellaneous minus (retail with tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSMVP | |
| 61 | BKSMAZ | Stock adjustment miscellaneous minus (no. of transactions) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BKSMAZ | Allow NULL? |
| 62 | UBPEPM | Revaluation at cost, plus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBPEPM | |
| 63 | UBPGEO | Revaluation at cost, plus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGEO | |
| 64 | UBPEAZ | Revaluation at cost plus, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_UBPEAZ | Allow NULL? |
| 65 | UBMEPM | Revaluation at cost minus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBMEPM | |
| 66 | UBMGEO | Revaluation at cost, minus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGEO | |
| 67 | UBMEAZ | Revaluation at cost minus, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_UBMEAZ | Allow NULL? |