| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 10 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | FIELD0001 | Mining planning data element 001. | float | 15 | 16 | | | | |
| 15 | FIELD0010 | Mining planning data element 0010. | float | 15 | 16 | | | | |
| 16 | FIELD0011 | Mining planning data element 0011. | float | 15 | 16 | | | | |
| 17 | FIELD0012 | Mining planning data element 0012. | float | 15 | 16 | | | | |
| 18 | FIELD0013 | Mining planning data element 0013. | float | 15 | 16 | | | | |
| 19 | FIELD0014 | Mining planning data element 0014. | float | 15 | 16 | | | | |
| 20 | FIELD0015 | Mining planning data element 0015. | float | 15 | 16 | | | | |
| 21 | FIELD0016 | Mining planning data element 0016. | float | 15 | 16 | | | | |
| 22 | FIELD0017 | Mining planning data element 0017. | float | 15 | 16 | | | | |
| 23 | FIELD0018 | Mining planning data element 0018. | float | 15 | 16 | | | | |
| 24 | FIELD0019 | Mining planning data element 0019. | float | 15 | 16 | | | | |
| 25 | FIELD0002 | Mining planning data element 002. | float | 15 | 16 | | | | |
| 26 | FIELD0020 | Mining planning data element 0020. | float | 15 | 16 | | | | |
| 27 | FIELD0021 | Mining planning data element 0021 | float | 15 | 16 | | | | |
| 28 | FIELD0022 | Mining planning data element 0022 | float | 15 | 16 | | | | |
| 29 | FIELD0003 | Mining planning data element 0003. | float | 15 | 16 | | | | |
| 30 | FIELD0004 | Mining planning data element 0004. | float | 15 | 16 | | | | |
| 31 | FIELD0005 | Mining planning data element 0005. | float | 15 | 16 | | | | |
| 32 | FIELD0006 | Mining planning data element 0006. | float | 15 | 16 | | | | |
| 33 | FIELD0007 | Mining planning data element 0007. | float | 15 | 16 | | | | |
| 34 | FIELD0008 | Mining planning data element 0008. | float | 15 | 16 | | | | |
| 35 | FIELD0009 | Mining planning data element 0009. | float | 15 | 16 | | | | |
| 36 | FIELD0023 | Mining planning data element 0023 | float | 15 | 16 | | | | |
| 37 | FIELD0024 | Mining planning data element 0024 | float | 15 | 16 | | | | |
| 38 | FIELD0025 | Mining planning data element 0025 | float | 15 | 16 | | | | |
| 39 | FIELD0026 | Mining planning data element 0026 | float | 15 | 16 | | | | |
| 40 | FIELD0027 | Mining planning data element 0027 | float | 15 | 16 | | | | |
| 41 | FIELD0028 | Mining planning data element 0028 | float | 15 | 16 | | | | |
| 42 | FIELD0029 | Mining planning data element 0029 | float | 15 | 16 | | | | |
| 43 | FIELD0030 | Mining planning data element 0030 | float | 15 | 16 | | | | |
| 44 | FIELD0031 | Mining planning data element 0031 | float | 15 | 16 | | | | |
| 45 | FIELD0032 | Mining planning data element 0032 | float | 15 | 16 | | | | |
| 46 | FIELD0033 | Mining planning data element 0033 | float | 15 | 16 | | | | |
| 47 | FIELD0034 | Mining planning data element 0034 | float | 15 | 16 | | | | |
| 48 | FIELD0035 | Mining planning data element 0035 | float | 15 | 16 | | | | |
| 49 | FIELD0036 | Mining planning data element 0036 | float | 15 | 16 | | | | |
| 50 | FIELD0037 | Mining planning data element 0037 | float | 15 | 16 | | | | |
| 51 | FIELD0038 | Mining planning data element 0038 | float | 15 | 16 | | | | |
| 52 | FIELD0039 | Mining planning data element 0039 | float | 15 | 16 | | | | |
| 53 | FIELD0040 | Mining planning data element 0040 | float | 15 | 16 | | | | |
| 54 | FIELD0041 | Mining planning data element 0041 | float | 15 | 16 | | | | |
| 55 | FIELD0042 | Mining planning data element 0042 | float | 15 | 16 | | | | |
| 56 | FIELD0043 | Mining planning data element 0043 | float | 15 | 16 | | | | |
| 57 | FIELD0044 | Mining planning data element 0044 | float | 15 | 16 | | | | |
| 58 | FIELD0045 | Mining planning data element 0045 | float | 15 | 16 | | | | |
| 59 | FIELD0046 | Mining planning data element 0046 | float | 15 | 16 | | | | |
| 60 | FIELD0047 | Mining planning data element 0047 | float | 15 | 16 | | | | |
| 61 | FIELD0048 | Mining planning data element 0048 | float | 15 | 16 | | | | |
| 62 | FIELD0049 | Mining planning data element 0049 | float | 15 | 16 | | | | |
| 63 | FIELD0050 | Mining planning data element 0050 | float | 15 | 16 | | | | |
| 64 | FIELD0051 | Mining planning data element 051 | decimal | 13 | 3 | | | | |
| 65 | FIELD0052 | Mining planning data element 052 | decimal | 13 | 3 | | | | |
| 66 | FIELD0053 | Mining planning data element 053 | decimal | 13 | 3 | | | | |
| 67 | FIELD0054 | Mining planning data element 054 | decimal | 13 | 3 | | | | |
| 68 | FIELD0055 | Mining planning data element 055 | decimal | 13 | 3 | | | | |
| 69 | FIELD0056 | Mining planning data element 056 | decimal | 13 | 3 | | | | |
| 70 | FIELD0057 | Mining planning data element 057 | decimal | 13 | 3 | | | | |
| 71 | FIELD0058 | Mining planning data element 058 | decimal | 13 | 3 | | | | |
| 72 | FIELD0059 | Mining planning data element 059 | decimal | 13 | 3 | | | | |
| 73 | FIELD0060 | Mining planning data element 060 | decimal | 13 | 3 | | | | |
| 74 | FIELD0061 | Mining planning data element 061 | decimal | 13 | 3 | | | | |
| 75 | FIELD0062 | Mining planning data element 062 | decimal | 13 | 3 | | | | |
| 76 | FIELD0063 | Mining planning data element 063 | decimal | 13 | 3 | | | | |
| 77 | FIELD0064 | Mining planning data element 064 | decimal | 13 | 3 | | | | |
| 78 | FIELD0065 | Mining planning data element 065 | decimal | 13 | 3 | | | | |
| 79 | FIELD0066 | Mining planning data element 066 | decimal | 13 | 3 | | | | |
| 80 | FIELD0067 | Mining planning data element 067 | decimal | 13 | 3 | | | | |
| 81 | FIELD0068 | Mining planning data element 068 | decimal | 13 | 3 | | | | |
| 82 | FIELD0069 | Mining planning data element 069 | decimal | 13 | 3 | | | | |
| 83 | FIELD0070 | Mining planning data element 070 | decimal | 13 | 3 | | | | |
| 84 | FIELD0071 | Mining planning data element 071 | decimal | 13 | 3 | | | | |
| 85 | FIELD0072 | Mining planning data element 072 | decimal | 13 | 3 | | | | |
| 86 | FIELD0073 | Mining planning data element 073 | decimal | 13 | 3 | | | | |
| 87 | FIELD0074 | Mining planning data element 074 | decimal | 13 | 3 | | | | |
| 88 | FIELD0075 | Mining planning data element 075 | decimal | 13 | 3 | | | | |
| 89 | FIELD0076 | Mining planning data element 076 | decimal | 13 | 3 | | | | |
| 90 | FIELD0077 | Mining planning data element 077 | decimal | 13 | 3 | | | | |
| 91 | FIELD0078 | Mining planning data element 078 | decimal | 13 | 3 | | | | |
| 92 | FIELD0079 | Mining planning data element 079 | decimal | 13 | 3 | | | | |
| 93 | FIELD0080 | Mining planning data element 080 | decimal | 13 | 3 | | | | |
| 94 | FIELD0081 | Mining planning data element 081 | decimal | 13 | 3 | | | | |
| 95 | FIELD0082 | Mining planning data element 082 | decimal | 13 | 3 | | | | |
| 96 | FIELD0083 | Mining planning data element 083 | decimal | 13 | 3 | | | | |
| 97 | FIELD0085 | Mining planning data element 085 | decimal | 13 | 3 | | | | |
| 98 | FIELD0086 | Mining planning data element 086 | decimal | 13 | 3 | | | | |
| 99 | FIELD0087 | Mining planning data element 087 | decimal | 13 | 3 | | | | |
| 100 | FIELD0088 | Mining planning data element 088 | decimal | 13 | 3 | | | | |
| 101 | FIELD0089 | Mining planning data element 089 | decimal | 13 | 3 | | | | |
| 102 | FIELD0090 | Mining planning data element 090 | decimal | 13 | 3 | | | | |
| 103 | FIELD0091 | Mining planning data element 091 | decimal | 13 | 3 | | | | |
| 104 | FIELD0092 | Mining planning data element 092 | decimal | 13 | 3 | | | | |
| 105 | FIELD0093 | Mining planning data element 093 | decimal | 13 | 3 | | | | |
| 106 | FIELD0094 | Mining planning data element 094 | decimal | 13 | 3 | | | | |
| 107 | FIELD0095 | Mining planning data element 095 | decimal | 13 | 3 | | | | |
| 108 | FIELD0096 | Mining planning data element 096 | decimal | 13 | 3 | | | | |
| 109 | FIELD0097 | Mining planning data element 097 | decimal | 13 | 3 | | | | |
| 110 | FIELD0098 | Mining planning data element 098 | decimal | 13 | 3 | | | | |
| 111 | FIELD0099 | Mining planning data element 099 | decimal | 13 | 3 | | | | |
| 112 | FIELD0100 | Mining planning data element 100 | decimal | 13 | 3 | | | | |
| 113 | KWMENG | Cumulative Order Quantity in Sales Units | decimal | 15 | 3 | | | | |
| 114 | FIELD0084 | Mining planning data element 084 | decimal | 13 | 3 | | | | |
| 115 | MZUBB | Valuated stock receipts quantity | decimal | 15 | 3 | | | | |