SAP table S411 (Mining Info structure.)
SAP table S411 has 9 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,WERKS,MATNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SSOUR | Statistic(s) origin | CHAR | 4 | 0 | SSOUR | ||
| VRSIO | Version number in the information structure | CHAR | 3 | 0 | * | VRSIO | |
| SPMON | Period to analyze - month | NUMC | 6 | 0 | SPMON | ||
| SPTAG | Period to analyze - current date | DATS | 8 | 0 | SPTAG | ||
| SPWOC | Period to analyze - week | NUMC | 6 | 0 | SPWOC | ||
| SPBUP | Period to analyze - posting period | NUMC | 6 | 0 | SPBUP | ||
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| PERIV | Fiscal Year Variant | CHAR | 2 | 0 | * | PERIV | |
| VWDAT | Pointer to administrative data | NUMC | 10 | 0 | VWDAT | ||
| MEINS | Base Unit of Measure | UNIT | 3 | 0 | T006 | LAGME | |
| BASME | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |
| FIELD0001 | Mining planning data element 001. | FLTP | 16 | 16 | OIM_FIELD0001 | ||
| FIELD0010 | Mining planning data element 0010. | FLTP | 16 | 16 | OIM_FIELD0010 | ||
| FIELD0011 | Mining planning data element 0011. | FLTP | 16 | 16 | OIM_FIELD0011 | ||
| FIELD0012 | Mining planning data element 0012. | FLTP | 16 | 16 | OIM_FIELD0012 | ||
| FIELD0013 | Mining planning data element 0013. | FLTP | 16 | 16 | OIM_FIELD0013 | ||
| FIELD0014 | Mining planning data element 0014. | FLTP | 16 | 16 | OIM_FIELD0014 | ||
| FIELD0015 | Mining planning data element 0015. | FLTP | 16 | 16 | OIM_FIELD0015 | ||
| FIELD0016 | Mining planning data element 0016. | FLTP | 16 | 16 | OIM_FIELD0016 | ||
| FIELD0017 | Mining planning data element 0017. | FLTP | 16 | 16 | OIM_FIELD0017 | ||
| FIELD0018 | Mining planning data element 0018. | FLTP | 16 | 16 | OIM_FIELD0018 | ||
| FIELD0019 | Mining planning data element 0019. | FLTP | 16 | 16 | OIM_FIELD0019 | ||
| FIELD0002 | Mining planning data element 002. | FLTP | 16 | 16 | OIM_FIELD0002 | ||
| FIELD0020 | Mining planning data element 0020. | FLTP | 16 | 16 | OIM_FIELD0020 | ||
| FIELD0021 | Mining planning data element 0021 | FLTP | 16 | 16 | OIM_FIELD0021 | ||
| FIELD0022 | Mining planning data element 0022 | FLTP | 16 | 16 | OIM_FIELD0022 | ||
| FIELD0003 | Mining planning data element 0003. | FLTP | 16 | 16 | OIM_FIELD0003 | ||
| FIELD0004 | Mining planning data element 0004. | FLTP | 16 | 16 | OIM_FIELD0004 | ||
| FIELD0005 | Mining planning data element 0005. | FLTP | 16 | 16 | OIM_FIELD0005 | ||
| FIELD0006 | Mining planning data element 0006. | FLTP | 16 | 16 | OIM_FIELD0006 | ||
| FIELD0007 | Mining planning data element 0007. | FLTP | 16 | 16 | OIM_FIELD0007 | ||
| FIELD0008 | Mining planning data element 0008. | FLTP | 16 | 16 | OIM_FIELD0008 | ||
| FIELD0009 | Mining planning data element 0009. | FLTP | 16 | 16 | OIM_FIELD0009 | ||
| FIELD0023 | Mining planning data element 0023 | FLTP | 16 | 16 | OIM_FIELD0023 | ||
| FIELD0024 | Mining planning data element 0024 | FLTP | 16 | 16 | OIM_FIELD0024 | ||
| FIELD0025 | Mining planning data element 0025 | FLTP | 16 | 16 | OIM_FIELD0025 | ||
| FIELD0026 | Mining planning data element 0026 | FLTP | 16 | 16 | OIM_FIELD0026 | ||
| FIELD0027 | Mining planning data element 0027 | FLTP | 16 | 16 | OIM_FIELD0027 | ||
| FIELD0028 | Mining planning data element 0028 | FLTP | 16 | 16 | OIM_FIELD0028 | ||
| FIELD0029 | Mining planning data element 0029 | FLTP | 16 | 16 | OIM_FIELD0029 | ||
| FIELD0030 | Mining planning data element 0030 | FLTP | 16 | 16 | OIM_FIELD0030 | ||
| FIELD0031 | Mining planning data element 0031 | FLTP | 16 | 16 | OIM_FIELD0031 | ||
| FIELD0032 | Mining planning data element 0032 | FLTP | 16 | 16 | OIM_FIELD0032 | ||
| FIELD0033 | Mining planning data element 0033 | FLTP | 16 | 16 | OIM_FIELD0033 | ||
| FIELD0034 | Mining planning data element 0034 | FLTP | 16 | 16 | OIM_FIELD0034 | ||
| FIELD0035 | Mining planning data element 0035 | FLTP | 16 | 16 | OIM_FIELD0035 | ||
| FIELD0036 | Mining planning data element 0036 | FLTP | 16 | 16 | OIM_FIELD0036 | ||
| FIELD0037 | Mining planning data element 0037 | FLTP | 16 | 16 | OIM_FIELD0037 | ||
| FIELD0038 | Mining planning data element 0038 | FLTP | 16 | 16 | OIM_FIELD0038 | ||
| FIELD0039 | Mining planning data element 0039 | FLTP | 16 | 16 | OIM_FIELD0039 | ||
| FIELD0040 | Mining planning data element 0040 | FLTP | 16 | 16 | OIM_FIELD0040 | ||
| FIELD0041 | Mining planning data element 0041 | FLTP | 16 | 16 | OIM_FIELD0041 | ||
| FIELD0042 | Mining planning data element 0042 | FLTP | 16 | 16 | OIM_FIELD0042 | ||
| FIELD0043 | Mining planning data element 0043 | FLTP | 16 | 16 | OIM_FIELD0043 | ||
| FIELD0044 | Mining planning data element 0044 | FLTP | 16 | 16 | OIM_FIELD0044 | ||
| FIELD0045 | Mining planning data element 0045 | FLTP | 16 | 16 | OIM_FIELD0045 | ||
| FIELD0046 | Mining planning data element 0046 | FLTP | 16 | 16 | OIM_FIELD0046 | ||
| FIELD0047 | Mining planning data element 0047 | FLTP | 16 | 16 | OIM_FIELD0047 | ||
| FIELD0048 | Mining planning data element 0048 | FLTP | 16 | 16 | OIM_FIELD0048 | ||
| FIELD0049 | Mining planning data element 0049 | FLTP | 16 | 16 | OIM_FIELD0049 | ||
| FIELD0050 | Mining planning data element 0050 | FLTP | 16 | 16 | OIM_FIELD0050 | ||
| FIELD0051 | Mining planning data element 051 | QUAN | 13 | 3 | OIM_FIELD0051 | ||
| FIELD0052 | Mining planning data element 052 | QUAN | 13 | 3 | OIM_FIELD0052 | ||
| FIELD0053 | Mining planning data element 053 | QUAN | 13 | 3 | OIM_FIELD0053 | ||
| FIELD0054 | Mining planning data element 054 | QUAN | 13 | 3 | OIM_FIELD0054 | ||
| FIELD0055 | Mining planning data element 055 | QUAN | 13 | 3 | OIM_FIELD0055 | ||
| FIELD0056 | Mining planning data element 056 | QUAN | 13 | 3 | OIM_FIELD0056 | ||
| FIELD0057 | Mining planning data element 057 | QUAN | 13 | 3 | OIM_FIELD0057 | ||
| FIELD0058 | Mining planning data element 058 | QUAN | 13 | 3 | OIM_FIELD0058 | ||
| FIELD0059 | Mining planning data element 059 | QUAN | 13 | 3 | OIM_FIELD0059 | ||
| FIELD0060 | Mining planning data element 060 | QUAN | 13 | 3 | OIM_FIELD0060 | ||
| FIELD0061 | Mining planning data element 061 | QUAN | 13 | 3 | OIM_FIELD0061 | ||
| FIELD0062 | Mining planning data element 062 | QUAN | 13 | 3 | OIM_FIELD0062 | ||
| FIELD0063 | Mining planning data element 063 | QUAN | 13 | 3 | OIM_FIELD0063 | ||
| FIELD0064 | Mining planning data element 064 | QUAN | 13 | 3 | OIM_FIELD0064 | ||
| FIELD0065 | Mining planning data element 065 | QUAN | 13 | 3 | OIM_FIELD0065 | ||
| FIELD0066 | Mining planning data element 066 | QUAN | 13 | 3 | OIM_FIELD0066 | ||
| FIELD0067 | Mining planning data element 067 | QUAN | 13 | 3 | OIM_FIELD0067 | ||
| FIELD0068 | Mining planning data element 068 | QUAN | 13 | 3 | OIM_FIELD0068 | ||
| FIELD0069 | Mining planning data element 069 | QUAN | 13 | 3 | OIM_FIELD0069 | ||
| FIELD0070 | Mining planning data element 070 | QUAN | 13 | 3 | OIM_FIELD0070 | ||
| FIELD0071 | Mining planning data element 071 | QUAN | 13 | 3 | OIM_FIELD0071 | ||
| FIELD0072 | Mining planning data element 072 | QUAN | 13 | 3 | OIM_FIELD0072 | ||
| FIELD0073 | Mining planning data element 073 | QUAN | 13 | 3 | OIM_FIELD0073 | ||
| FIELD0074 | Mining planning data element 074 | QUAN | 13 | 3 | OIM_FIELD0074 | ||
| FIELD0075 | Mining planning data element 075 | QUAN | 13 | 3 | OIM_FIELD0075 | ||
| FIELD0076 | Mining planning data element 076 | QUAN | 13 | 3 | OIM_FIELD0076 | ||
| FIELD0077 | Mining planning data element 077 | QUAN | 13 | 3 | OIM_FIELD0077 | ||
| FIELD0078 | Mining planning data element 078 | QUAN | 13 | 3 | OIM_FIELD0078 | ||
| FIELD0079 | Mining planning data element 079 | QUAN | 13 | 3 | OIM_FIELD0079 | ||
| FIELD0080 | Mining planning data element 080 | QUAN | 13 | 3 | OIM_FIELD0080 | ||
| FIELD0081 | Mining planning data element 081 | QUAN | 13 | 3 | OIM_FIELD0081 | ||
| FIELD0082 | Mining planning data element 082 | QUAN | 13 | 3 | OIM_FIELD0082 | ||
| FIELD0083 | Mining planning data element 083 | QUAN | 13 | 3 | OIM_FIELD0083 | ||
| FIELD0085 | Mining planning data element 085 | QUAN | 13 | 3 | OIM_FIELD0085 | ||
| FIELD0086 | Mining planning data element 086 | QUAN | 13 | 3 | OIM_FIELD0086 | ||
| FIELD0087 | Mining planning data element 087 | QUAN | 13 | 3 | OIM_FIELD0087 | ||
| FIELD0088 | Mining planning data element 088 | QUAN | 13 | 3 | OIM_FIELD0088 | ||
| FIELD0089 | Mining planning data element 089 | QUAN | 13 | 3 | OIM_FIELD0089 | ||
| FIELD0090 | Mining planning data element 090 | QUAN | 13 | 3 | OIM_FIELD0090 | ||
| FIELD0091 | Mining planning data element 091 | QUAN | 13 | 3 | OIM_FIELD0091 | ||
| FIELD0092 | Mining planning data element 092 | QUAN | 13 | 3 | OIM_FIELD0092 | ||
| FIELD0093 | Mining planning data element 093 | QUAN | 13 | 3 | OIM_FIELD0093 | ||
| FIELD0094 | Mining planning data element 094 | QUAN | 13 | 3 | OIM_FIELD0094 | ||
| FIELD0095 | Mining planning data element 095 | QUAN | 13 | 3 | OIM_FIELD0095 | ||
| FIELD0096 | Mining planning data element 096 | QUAN | 13 | 3 | OIM_FIELD0096 | ||
| FIELD0097 | Mining planning data element 097 | QUAN | 13 | 3 | OIM_FIELD0097 | ||
| FIELD0098 | Mining planning data element 098 | QUAN | 13 | 3 | OIM_FIELD0098 | ||
| FIELD0099 | Mining planning data element 099 | QUAN | 13 | 3 | OIM_FIELD0099 | ||
| FIELD0100 | Mining planning data element 100 | QUAN | 13 | 3 | OIM_FIELD0100 | ||
| KWMENG | Cumulative order quantity in sales units | QUAN | 15 | 3 | KWMENG | ||
| FIELD0084 | Mining planning data element 084 | QUAN | 13 | 3 | OIM_FIELD0084 | ||
| MZUBB | Valuated stock receipts quantity | QUAN | 15 | 3 | MZUBB |
S411 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 S411 | BASME | T006 | Units of Measurement | MANDT |
| 1 S411 | MATNR | MARA | General Material Data | MANDT |
| 1 S411 | MATNR | MARA | General Material Data | MATNR |
| 0 S411 | MEINS | T006 | Units of Measurement | MANDT |
| 0 S411 | MEINS | T006 | Units of Measurement | MSEHI |
| 1 S411 | WERKS | T001W | Plants/Branches | WERKS |