SAP NWTMDATES Table in S/4 HANA - Data for Date Overview
NWTMDATES is a standard SAP Table which is used to store Data for Date Overview data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the NWTMDATES table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Structure
Database Table: NWTMDATES
NWTMDATES table structure field list
Below is the full NWTMDATES field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MATNR | Material Number | MATNR | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
WERKS | Plant | WERKS_D | CHAR | 4(0) | Assigned to domain | WERKS | WRK | H_T001W_C | WERKS | |
MAKTX | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
MATKL | Material Group | MATKL | CHAR | 9(0) | Assigned to domain | MATKL | MKL | S_WBWG | MATKL | |
TPLNR | Functional Location | TPLNR | CHAR | 30(0) | Assigned to domain | TPLNR | TPLNR | IFL | IFLM | TPLNR |
TMGRP | Group for monitoring dates | CN_TMGRP | NUMC | 6(0) | Assigned to domain | CN_TMGRP | ||||
KTEXT | Description | CN_TXT | CHAR | 40(0) | TEXT40 | |||||
PSPEL | WBS Element | PS_POSNR | NUMC | 8(0) | Assigned to domain | ABPSP | PS_POSNR | |||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24(0) | ABPSN | PS_POSID | PRO | |||
NPLNR | Network number | NW_AUFNR | CHAR | 12(0) | Assigned to domain | ALPHA | AUFNR | ANR | ||
VORNR | Activity number in network and standard network | CN_VORNR | CHAR | 4(0) | NUMCV | VORNR | ||||
POSNR | BOM item number | APOSN | CHAR | 4(0) | NUMCV | SPOSN | ||||
DTYPE | Date type description | CN_DTYPE | CHAR | 4(0) | TEXT4 | |||||
TMTYP | Date type | CN_TMTYP | CHAR | 1(0) | CN_TMTYP | |||||
DATE01 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT01 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE02 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT02 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE03 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT03 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE04 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT04 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE05 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT05 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE06 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT06 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE07 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT07 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE08 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT08 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE09 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT09 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE10 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT10 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE11 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT11 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE12 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT12 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE13 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT13 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE14 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT14 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE15 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT15 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE16 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT16 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE17 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT17 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE18 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT18 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE19 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT19 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE20 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT20 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE21 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT21 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE22 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT22 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE23 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT23 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE24 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT24 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE25 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT25 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE26 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT26 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE27 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT27 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE28 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT28 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE29 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT29 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE30 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT30 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE31 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT31 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE32 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT32 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE33 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT33 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE34 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT34 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE35 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT35 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE36 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT36 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE37 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT37 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE38 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT38 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE39 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT39 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE40 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT40 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE41 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT41 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE42 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT42 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE43 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT43 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE44 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT44 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE45 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT45 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE46 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT46 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE47 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT47 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE48 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT48 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE49 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT49 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA | ||||
DATE50 | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
STAT50 | Status of event in monitoring dates | CN_TMSTA | CHAR | 2(0) | TCNTM04 | CN_TMSTA |
Search for further information about these or an SAP related objects