1. Home
  2. Resources
  3. SAP Tables
  4. GMIS - Reporting for table GMIT

SAP Table GMIS

Reporting for table GMIT

GMIS (Reporting for table GMIT) 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 GMIS to other SAP tables.

GMIS table fields

Field Data element Checktable Datatype Length Decimals
ID Internal: Node ID SEU_ID NUMC 6 0
VERSN Financial Statement Version VERSN_011 T011 CHAR 4 0
ERGSL Financial Statement Item ERGSL CHAR 10 0
CURTP Currency Type for Sales Segments ALLGCRTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
WAERS Currency Key WAERS CUKY 5 0
KTOPL Chart of Accounts KTOPL T004 CHAR 4 0
SAK_PLUMI Financial Statement Item/Account Number SAK_PLUMI CHAR 11 0
SAKFB_LONG Financial Statement Item/Account No./Functional Area Long SAKFB_LONG CHAR 16 0
KKTPL Group Chart of Accts KKTPL T004 CHAR 4 0
BILKT Group Account Number BILKT SKA1 CHAR 10 0
KTOP2 Chart of Accounts According to Country Legislation KTOP2 T004 CHAR 4 0
ALTKT Alternative account number in company code ALTKT_SKB1 SKA1 CHAR 10 0
RKTPL Chart of Accounts KTOPL T004 CHAR 4 0
ADB_PFROM Period From (Average Daily Balance) ADB_PFROM DATS 8 0
ADB_PTO Period To (Average Daily Balance) ADB_PTO DATS 8 0
RLDNR Ledger RLDNR CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS CHAR 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
RBUKRS Company Code BUKRS CHAR 4 0
RGRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
RSPONSORED_PROG Sponsored Program GM_SPONSORED_PROG CHAR 20 0
RSPONSORED_CLASS Sponsored Class GM_SPONSORED_CLASS CHAR 20 0
RBDGT_VLDTY_NBR Budget Validity Number GM_BDGT_VLDTY_NBR CHAR 3 0
RFUND Fund BP_GEBER CHAR 10 0
RVALUETYPE_9 GM Value Type GM_VALUETYPE CHAR 2 0
RTRANS Business Transaction J_VORGANG CHAR 4 0
RSTATS_IND Statistical Indicator GM_STATS CHAR 1 0
R Real Posting
S Statistical Posting
RTCUR Currency Key RTCUR CUKY 5 0
RUNIT Base Unit of Measure MEINS UNIT 3 0
POPER Posting period POPER NUMC 3 0
MAXPER Period PERIODE NUMC 3 0
PERIO Period/year JAHRPER NUMC 7 0
WERTB Value: Balance Sheet Accounts RR_WERTB CURR 17 2
WERTE Value: P&L Accounts RR_WERTE CURR 17 2
UMSAV Balance Carryforward RR_UMSAV CURR 17 2
UMSOL Total debit postings RR_UMSOL CURR 17 2
UMHAB Total credit postings RR_UMHAB CURR 17 2
UMPER Period balance RR_UMPER CURR 17 2
KUMSL Accumulated balance RR_KUMSL CURR 17 2
MENGP Quantity for period RR_MENGP QUAN 15 3
MENGK Cumulative quantity RR_MENGK QUAN 15 3

GMIS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
GMIS ALTKT SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
GMIS ALTKT GMIS KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
GMIS ALTKT GMIS ALTKT SKA1 G/L Account Master (Chart of Accounts) SAKNR
GMIS BILKT SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
GMIS BILKT GMIS KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
GMIS BILKT GMIS BILKT SKA1 G/L Account Master (Chart of Accounts) SAKNR
GMIS KKTPL SYST MANDT T004 Directory of Charts of Accounts MANDT
GMIS KKTPL GMIS KKTPL T004 Directory of Charts of Accounts KTOPL
GMIS KTOP2 SYST MANDT T004 Directory of Charts of Accounts MANDT
GMIS KTOP2 GMIS KTOP2 T004 Directory of Charts of Accounts KTOPL
GMIS KTOPL GMIS KTOPL T004 Directory of Charts of Accounts KTOPL
GMIS KTOPL SYST MANDT T004 Directory of Charts of Accounts MANDT
GMIS RKTPL SYST MANDT T004 Directory of Charts of Accounts MANDT
GMIS RKTPL GMIS RKTPL T004 Directory of Charts of Accounts KTOPL
GMIS VERSN SYST MANDT T011 Financial Statement Versions MANDT
GMIS VERSN GMIS VERSN T011 Financial Statement Versions VERSN