S411 SAP (Mining Info structure.) Table details

Dictionary Type: Table
Description: Mining Info structure.




ABAP Code to SELECT data from S411
Related tables to S411
Access table S411




Table field list including key, data, relationships and ABAP select examples

S411 is a standard SAP Table which is used to store Mining Info structure. data and is available within R/3 SAP systems depending on the version and release level.

The S411 table consists of various fields, each holding specific information or linking keys about Mining Info structure. data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP S411 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
MEINSBase Unit of Measure LAGMEUNIT3T006CUNITMEINS
BASMEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
FIELD0001Mining planning data element 001. OIM_FIELD0001FLTP16(16) FLTP
FIELD0010Mining planning data element 0010. OIM_FIELD0010FLTP16(16) FLTP
FIELD0011Mining planning data element 0011. OIM_FIELD0011FLTP16(16) FLTP
FIELD0012Mining planning data element 0012. OIM_FIELD0012FLTP16(16) FLTP
FIELD0013Mining planning data element 0013. OIM_FIELD0013FLTP16(16) FLTP
FIELD0014Mining planning data element 0014. OIM_FIELD0014FLTP16(16) FLTP
FIELD0015Mining planning data element 0015. OIM_FIELD0015FLTP16(16) FLTP
FIELD0016Mining planning data element 0016. OIM_FIELD0016FLTP16(16) FLTP
FIELD0017Mining planning data element 0017. OIM_FIELD0017FLTP16(16) FLTP
FIELD0018Mining planning data element 0018. OIM_FIELD0018FLTP16(16) FLTP
FIELD0019Mining planning data element 0019. OIM_FIELD0019FLTP16(16) FLTP
FIELD0002Mining planning data element 002. OIM_FIELD0002FLTP16(16) FLTP
FIELD0020Mining planning data element 0020. OIM_FIELD0020FLTP16(16) FLTP
FIELD0021Mining planning data element 0021 OIM_FIELD0021FLTP16(16) FLTP
FIELD0022Mining planning data element 0022 OIM_FIELD0022FLTP16(16) FLTP
FIELD0003Mining planning data element 0003. OIM_FIELD0003FLTP16(16) FLTP
FIELD0004Mining planning data element 0004. OIM_FIELD0004FLTP16(16) FLTP
FIELD0005Mining planning data element 0005. OIM_FIELD0005FLTP16(16) FLTP
FIELD0006Mining planning data element 0006. OIM_FIELD0006FLTP16(16) FLTP
FIELD0007Mining planning data element 0007. OIM_FIELD0007FLTP16(16) FLTP
FIELD0008Mining planning data element 0008. OIM_FIELD0008FLTP16(16) FLTP
FIELD0009Mining planning data element 0009. OIM_FIELD0009FLTP16(16) FLTP
FIELD0023Mining planning data element 0023 OIM_FIELD0023FLTP16(16) FLTP
FIELD0024Mining planning data element 0024 OIM_FIELD0024FLTP16(16) FLTP
FIELD0025Mining planning data element 0025 OIM_FIELD0025FLTP16(16) FLTP
FIELD0026Mining planning data element 0026 OIM_FIELD0026FLTP16(16) FLTP
FIELD0027Mining planning data element 0027 OIM_FIELD0027FLTP16(16) FLTP
FIELD0028Mining planning data element 0028 OIM_FIELD0028FLTP16(16) FLTP
FIELD0029Mining planning data element 0029 OIM_FIELD0029FLTP16(16) FLTP
FIELD0030Mining planning data element 0030 OIM_FIELD0030FLTP16(16) FLTP
FIELD0031Mining planning data element 0031 OIM_FIELD0031FLTP16(16) FLTP
FIELD0032Mining planning data element 0032 OIM_FIELD0032FLTP16(16) FLTP
FIELD0033Mining planning data element 0033 OIM_FIELD0033FLTP16(16) FLTP
FIELD0034Mining planning data element 0034 OIM_FIELD0034FLTP16(16) FLTP
FIELD0035Mining planning data element 0035 OIM_FIELD0035FLTP16(16) FLTP
FIELD0036Mining planning data element 0036 OIM_FIELD0036FLTP16(16) FLTP
FIELD0037Mining planning data element 0037 OIM_FIELD0037FLTP16(16) FLTP
FIELD0038Mining planning data element 0038 OIM_FIELD0038FLTP16(16) FLTP
FIELD0039Mining planning data element 0039 OIM_FIELD0039FLTP16(16) FLTP
FIELD0040Mining planning data element 0040 OIM_FIELD0040FLTP16(16) FLTP
FIELD0041Mining planning data element 0041 OIM_FIELD0041FLTP16(16) FLTP
FIELD0042Mining planning data element 0042 OIM_FIELD0042FLTP16(16) FLTP
FIELD0043Mining planning data element 0043 OIM_FIELD0043FLTP16(16) FLTP
FIELD0044Mining planning data element 0044 OIM_FIELD0044FLTP16(16) FLTP
FIELD0045Mining planning data element 0045 OIM_FIELD0045FLTP16(16) FLTP
FIELD0046Mining planning data element 0046 OIM_FIELD0046FLTP16(16) FLTP
FIELD0047Mining planning data element 0047 OIM_FIELD0047FLTP16(16) FLTP
FIELD0048Mining planning data element 0048 OIM_FIELD0048FLTP16(16) FLTP
FIELD0049Mining planning data element 0049 OIM_FIELD0049FLTP16(16) FLTP
FIELD0050Mining planning data element 0050 OIM_FIELD0050FLTP16(16) FLTP
FIELD0051Mining planning data element 051 OIM_FIELD0051QUAN13(3) MENG13
FIELD0052Mining planning data element 052 OIM_FIELD0052QUAN13(3) MENG13
FIELD0053Mining planning data element 053 OIM_FIELD0053QUAN13(3) MENG13
FIELD0054Mining planning data element 054 OIM_FIELD0054QUAN13(3) MENG13
FIELD0055Mining planning data element 055 OIM_FIELD0055QUAN13(3) MENG13
FIELD0056Mining planning data element 056 OIM_FIELD0056QUAN13(3) MENG13
FIELD0057Mining planning data element 057 OIM_FIELD0057QUAN13(3) MENG13
FIELD0058Mining planning data element 058 OIM_FIELD0058QUAN13(3) MENG13
FIELD0059Mining planning data element 059 OIM_FIELD0059QUAN13(3) MENG13
FIELD0060Mining planning data element 060 OIM_FIELD0060QUAN13(3) MENG13
FIELD0061Mining planning data element 061 OIM_FIELD0061QUAN13(3) MENG13
FIELD0062Mining planning data element 062 OIM_FIELD0062QUAN13(3) MENG13
FIELD0063Mining planning data element 063 OIM_FIELD0063QUAN13(3) MENG13
FIELD0064Mining planning data element 064 OIM_FIELD0064QUAN13(3) MENG13
FIELD0065Mining planning data element 065 OIM_FIELD0065QUAN13(3) MENG13
FIELD0066Mining planning data element 066 OIM_FIELD0066QUAN13(3) MENG13
FIELD0067Mining planning data element 067 OIM_FIELD0067QUAN13(3) MENG13
FIELD0068Mining planning data element 068 OIM_FIELD0068QUAN13(3) MENG13
FIELD0069Mining planning data element 069 OIM_FIELD0069QUAN13(3) MENG13
FIELD0070Mining planning data element 070 OIM_FIELD0070QUAN13(3) MENG13
FIELD0071Mining planning data element 071 OIM_FIELD0071QUAN13(3) MENG13
FIELD0072Mining planning data element 072 OIM_FIELD0072QUAN13(3) MENG13
FIELD0073Mining planning data element 073 OIM_FIELD0073QUAN13(3) MENG13
FIELD0074Mining planning data element 074 OIM_FIELD0074QUAN13(3) MENG13
FIELD0075Mining planning data element 075 OIM_FIELD0075QUAN13(3) MENG13
FIELD0076Mining planning data element 076 OIM_FIELD0076QUAN13(3) MENG13
FIELD0077Mining planning data element 077 OIM_FIELD0077QUAN13(3) MENG13
FIELD0078Mining planning data element 078 OIM_FIELD0078QUAN13(3) MENG13
FIELD0079Mining planning data element 079 OIM_FIELD0079QUAN13(3) MENG13
FIELD0080Mining planning data element 080 OIM_FIELD0080QUAN13(3) MENG13
FIELD0081Mining planning data element 081 OIM_FIELD0081QUAN13(3) MENG13
FIELD0082Mining planning data element 082 OIM_FIELD0082QUAN13(3) MENG13
FIELD0083Mining planning data element 083 OIM_FIELD0083QUAN13(3) MENG13
FIELD0085Mining planning data element 085 OIM_FIELD0085QUAN13(3) MENG13
FIELD0086Mining planning data element 086 OIM_FIELD0086QUAN13(3) MENG13
FIELD0087Mining planning data element 087 OIM_FIELD0087QUAN13(3) MENG13
FIELD0088Mining planning data element 088 OIM_FIELD0088QUAN13(3) MENG13
FIELD0089Mining planning data element 089 OIM_FIELD0089QUAN13(3) MENG13
FIELD0090Mining planning data element 090 OIM_FIELD0090QUAN13(3) MENG13
FIELD0091Mining planning data element 091 OIM_FIELD0091QUAN13(3) MENG13
FIELD0092Mining planning data element 092 OIM_FIELD0092QUAN13(3) MENG13
FIELD0093Mining planning data element 093 OIM_FIELD0093QUAN13(3) MENG13
FIELD0094Mining planning data element 094 OIM_FIELD0094QUAN13(3) MENG13
FIELD0095Mining planning data element 095 OIM_FIELD0095QUAN13(3) MENG13
FIELD0096Mining planning data element 096 OIM_FIELD0096QUAN13(3) MENG13
FIELD0097Mining planning data element 097 OIM_FIELD0097QUAN13(3) MENG13
FIELD0098Mining planning data element 098 OIM_FIELD0098QUAN13(3) MENG13
FIELD0099Mining planning data element 099 OIM_FIELD0099QUAN13(3) MENG13
FIELD0100Mining planning data element 100 OIM_FIELD0100QUAN13(3) MENG13
KWMENGCumulative Order Quantity in Sales Units KWMENGQUAN15(3) MENG15
FIELD0084Mining planning data element 084 OIM_FIELD0084QUAN13(3) MENG13
MZUBBValuated stock receipts quantity MZUBBQUAN15(3) MENGV15

Key field Non-key field



How do I retrieve data from SAP table S411 using ABAP code

The following ABAP code Example will allow you to do a basic selection on S411 to SELECT all data from the table
DATA: WA_S411 TYPE S411.

SELECT SINGLE *
FROM S411
INTO CORRESPONDING FIELDS OF WA_S411
WHERE...

How to access SAP table S411

Within an ECC or HANA version of SAP you can also view further information about S411 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!