SAP MTPER Table in S/4 HANA - Periods at Database Level









MTPER is a standard SAP Table which is used to store Periods at Database Level 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 MTPER table(ECC)

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type)
Dictionary Type: Structure
Database Table: MTPER


MTPER table structure field list

Below is the full MTPER 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
MBLFMPeriod of MBEW or EBEW or QBEWMBLFMNUMC2(0) MONAT
MBGJAFiscal year of MBEW or EBEW or QBEWMBGJANUMC4(0) GJAHRGJAHR
RMBEWHInd.: MBEWH/EBEWH/QBEWH for prev. period could not be readRMBEWHCHAR1(0) XFELD
MCLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
MCGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMARCHData content X or blankXWERTCHAR1(0) XFELD
MDLFMPeriod of MARDMDLFMNUMC2(0) MONAT
MDGJAFiscal year of MARDMDGJANUMC4(0) GJAHRGJAHR
RMARDHIndicator: MARDH for previous period could not be readRMARDHCHAR1(0) XFELD
CHLFMPeriod of MCHBCHLFMNUMC2(0) MONAT
CHGJAFiscal year of MCHBCHGJANUMC4(0) GJAHRGJAHR
RMCHBHData content X or blankXWERTCHAR1(0) XFELD
KLLFMPeriod of MKOLKLLFMNUMC2(0) MONAT
KLGJAFiscal year of MKOLKLGJANUMC4(0) GJAHRGJAHR
RMKOLHData content X or blankXWERTCHAR1(0) XFELD
KALFMCurrent period (posting period)LFMONNUMC2(0) MONAT
KAGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSKAHData content X or blankXWERTCHAR1(0) XFELD
SALFMCurrent period (posting period)LFMONNUMC2(0) MONAT
SAGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSSAHData content X or blankXWERTCHAR1(0) XFELD
KULFMCurrent period (posting period)LFMONNUMC2(0) MONAT
KUGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSKUHData content X or blankXWERTCHAR1(0) XFELD
LBLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
LBGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSLBHData content X or blankXWERTCHAR1(0) XFELD
PRLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
PRGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSPRHData content X or blankXWERTCHAR1(0) XFELD
SQLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
SQGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSSQHData content X or blankXWERTCHAR1(0) XFELD
CALFMCurrent period (posting period)LFMONNUMC2(0) MONAT
CAGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSCAHData content X or blankXWERTCHAR1(0) XFELD
RMSTBData content X or blankXWERTCHAR1(0) XFELD
RMSTBHData content X or blankXWERTCHAR1(0) XFELD
TBLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
TBGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSTEData content X or blankXWERTCHAR1(0) XFELD
RMSTEHData content X or blankXWERTCHAR1(0) XFELD
TELFMCurrent period (posting period)LFMONNUMC2(0) MONAT
TEGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSTQData content X or blankXWERTCHAR1(0) XFELD
RMSTQHData content X or blankXWERTCHAR1(0) XFELD
TQLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
TQGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
.INCLU--AP0(0)
SDLFMONCurrent period (posting period)LFMONNUMC2(0) MONAT
SSFMONCurrent period (posting period)LFMONNUMC2(0) MONAT
SDLFGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
SSFGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMCSDHData content X or blankXWERTCHAR1(0) XFELD
RMCSSHData content X or blankXWERTCHAR1(0) XFELD
SDLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
SSLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
CDLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
CSLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
FDLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
FSLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
IDLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
ISLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
RDLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
RSLFMCurrent period (posting period)LFMONNUMC2(0) MONAT
SDGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
SSGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
CDGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
CSGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
FDGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
FSGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
IDGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
ISGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RDGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RSGJAFiscal Year of Current PeriodLFGJANUMC4(0) GJAHRGJAHR
RMSCDHData content X or blankXWERTCHAR1(0) XFELD
RMSCSHData content X or blankXWERTCHAR1(0) XFELD
RMSFDHData content X or blankXWERTCHAR1(0) XFELD
RMSFSHData content X or blankXWERTCHAR1(0) XFELD
RMSIDHData content X or blankXWERTCHAR1(0) XFELD
RMSISHData content X or blankXWERTCHAR1(0) XFELD
RMSRDHData content X or blankXWERTCHAR1(0) XFELD
RMSRSHData content X or blankXWERTCHAR1(0) XFELD




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!