1. Home
  2. Resources
  3. SAP Tables
  4. MTPER - Periods at Database Level

SAP Table MTPER

Periods at Database Level

MTPER (Periods at Database Level) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MTPER to other SAP tables.

MTPER table fields

Field Data element Checktable Datatype Length Decimals
MBLFM Period of MBEW or EBEW or QBEW MBLFM NUMC 2 0
MBGJA Fiscal year of MBEW or EBEW or QBEW MBGJA NUMC 4 0
RMBEWH Ind.: MBEWH/EBEWH/QBEWH for prev. period could not be read RMBEWH CHAR 1 0
X Yes
NULL No
MCLFM Current period (posting period) LFMON NUMC 2 0
MCGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMARCH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
MDLFM Period of MARD MDLFM NUMC 2 0
MDGJA Fiscal year of MARD MDGJA NUMC 4 0
RMARDH Indicator: MARDH for previous period could not be read RMARDH CHAR 1 0
X Yes
NULL No
CHLFM Period of MCHB CHLFM NUMC 2 0
CHGJA Fiscal year of MCHB CHGJA NUMC 4 0
RMCHBH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
KLLFM Period of MKOL KLLFM NUMC 2 0
KLGJA Fiscal year of MKOL KLGJA NUMC 4 0
RMKOLH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
KALFM Current period (posting period) LFMON NUMC 2 0
KAGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSKAH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
SALFM Current period (posting period) LFMON NUMC 2 0
SAGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSSAH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
KULFM Current period (posting period) LFMON NUMC 2 0
KUGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSKUH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
LBLFM Current period (posting period) LFMON NUMC 2 0
LBGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSLBH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
PRLFM Current period (posting period) LFMON NUMC 2 0
PRGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSPRH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
SQLFM Current period (posting period) LFMON NUMC 2 0
SQGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSSQH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
CALFM Current period (posting period) LFMON NUMC 2 0
CAGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSCAH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSTB Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSTBH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
TBLFM Current period (posting period) LFMON NUMC 2 0
TBGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSTE Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSTEH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
TELFM Current period (posting period) LFMON NUMC 2 0
TEGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSTQ Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSTQH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
TQLFM Current period (posting period) LFMON NUMC 2 0
TQGJA Fiscal Year of Current Period LFGJA NUMC 4 0
SDLFMON Current period (posting period) LFMON NUMC 2 0
SSFMON Current period (posting period) LFMON NUMC 2 0
SDLFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
SSFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMCSDH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMCSSH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
SDLFM Current period (posting period) LFMON NUMC 2 0
SSLFM Current period (posting period) LFMON NUMC 2 0
CDLFM Current period (posting period) LFMON NUMC 2 0
CSLFM Current period (posting period) LFMON NUMC 2 0
FDLFM Current period (posting period) LFMON NUMC 2 0
FSLFM Current period (posting period) LFMON NUMC 2 0
IDLFM Current period (posting period) LFMON NUMC 2 0
ISLFM Current period (posting period) LFMON NUMC 2 0
RDLFM Current period (posting period) LFMON NUMC 2 0
RSLFM Current period (posting period) LFMON NUMC 2 0
SDGJA Fiscal Year of Current Period LFGJA NUMC 4 0
SSGJA Fiscal Year of Current Period LFGJA NUMC 4 0
CDGJA Fiscal Year of Current Period LFGJA NUMC 4 0
CSGJA Fiscal Year of Current Period LFGJA NUMC 4 0
FDGJA Fiscal Year of Current Period LFGJA NUMC 4 0
FSGJA Fiscal Year of Current Period LFGJA NUMC 4 0
IDGJA Fiscal Year of Current Period LFGJA NUMC 4 0
ISGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RDGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RSGJA Fiscal Year of Current Period LFGJA NUMC 4 0
RMSCDH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSCSH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSFDH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSFSH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSIDH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSISH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSRDH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No
RMSRSH Data content X or blank XWERT CHAR 1 0
X Yes
NULL No