1. Home
  2. Resources
  3. SAP Tables
  4. GMIA - Actual Line Item Table

SAP Table GMIA

Actual Line Item Table

GMIA (Actual Line Item Table) 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 GMIA to other SAP tables.

GMIA table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
GL_SIRID Record number of the line item record GU_RECID CHAR 18 0
RLDNR Ledger RLDNR T881 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 T894 CHAR 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
RTCUR Currency Key RTCUR TCURC CUKY 5 0
RUNIT Base Unit of Measure MEINS T006 UNIT 3 0
POPER Posting period POPER NUMC 3 0
DOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Accounting Document Number BELNR_D CHAR 10 0
DOCLN Six-Character Posting Item for Ledger DOCLN6 CHAR 6 0
RBUKRS Company Code BUKRS T001 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
RGRANTEE_FY_9 Fiscal Year of Grantee Organization GM_GRANTEE_FY NUMC 4 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
BDGT_STATE Workflow State of a Record in the Budget Totals Table GM_BDGT_STATE CHAR 1 0
P Posted
R Reserved
E Earmarked
TSL Value in Transaction Currency VTCUR9 CURR 17 2
HSL Value in local currency VLCUR9 CURR 17 2
MSL Quantity QUAN1 QUAN 15 3
SGTXT Item Text SGTXT CHAR 50 0
DOCTY FI-SL Document Type DOCTY T889 CHAR 2 0
ACTIV Business Transaction GLVOR CHAR 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
WSDAT Value Date for Currency Translation WSDAT DATS 8 0
REFDOCNR Reference document number of an accounting document REFBELNR CHAR 10 0
REFRYEAR Reference fiscal year REFGJAHR NUMC 4 0
REFDOCLN Six-digit number of the reference posting line REFBUZEI6 NUMC 6 0
REFDOCCT Reference document category REFDOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV FI-SL Business Reference Transaction REFGLVOR CHAR 4 0
REFDOC_DETAIL Reference Key AWKEY CHAR 20 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
USNAM User name USNAM CHAR 12 0
AWTYP Reference Transaction AWTYP TTYP CHAR 5 0
AWORG Reference Organizational Units AWORG CHAR 10 0
GL_ACCOUNT General Ledger Account HKONT CHAR 10 0
CO_AREA Controlling Area KOKRS CHAR 4 0
COSTCENTER Cost Center KOSTL CHAR 10 0
ORDERID Order Number AUFNR CHAR 12 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
PROFIT_CTR Profit Center PRCTR CHAR 10 0
ASSETMAINO Main Asset Number BF_ANLN1 CHAR 12 0
ASSETSUBNO Asset Subnumber BF_ANLN2 CHAR 4 0
MATERIAL Material Number MATNR CHAR 18 0
FM_AREA Financial Management Area FIKRS CHAR 4 0
BUS_AREA Business Area GSBER CHAR 4 0
FUNDS_CTR Funds Center FISTL CHAR 16 0
CMMT_ITEM Commitment Item FM_FIPEX CHAR 24 0
FAREA Functional Area FM_FAREA CHAR 16 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
NETWORK Network Number for Account Assignment NPLNR CHAR 12 0
ROUTING_NO Routing number of operations in the order CO_AUFPL NUMC 10 0
COUNTER_9 Internal counter CIM_COUNT NUMC 8 0
OBJ_ORG_P Reference Organizational Units AWORG CHAR 10 0
OBJ_TYP_P Previous document: Reference procedure AWTYP_PRE CHAR 5 0
OBJ_KEY_P Previous document: Object key (AWREF_REV and AWORG_REV) AWKEY_PRE CHAR 20 0
OBJ_POS_P Previous document: Reference line item AWPOS_PRE CHAR 10 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
LINETYPE Item category LINETYPE CHAR 5 0
XSPLITMOD Item changed by document splitting XSPLITMOD CHAR 1 0
X Yes
NULL No
WSL Value in Original Transaction Currency (Document Currency) VWCUR12 CURR 23 2
RWCUR Currency key of the original transaction currency RWCUR CUKY 5 0
BILLING_STATUS Billing Status for Item GM_BILLING_STATUS CHAR 1 0
B Billed
P Partially Billed
O Over-billed
NULL Unbilled
ERLKZ Completion Indicator for Line Item GM_ERLKZ CHAR 1 0
NULL Not Selected
X Selected
LOEKZ Deletion Indicator GM_LOEKZ CHAR 1 0
NULL Not Selected
X Selected
BILLING_BLOCK_9 Billing Block Flag for an Item GM_BILLING_BLOCK CHAR 1 0
NULL Unblocked
X Blocked
DOC_ORIGIN_9 Document's Technical Origin GM_TECHORG CHAR 1 0
R Revaluation
NULL Standard Interfaces
WBS_SHORT_9 Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0

GMIA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
GMIA AWTYP GMIA AWTYP TTYP Object Types for Accounting AWTYP
GMIA DOCTY GMIA RCLNT T889 FI-SL Document Types MANDT
GMIA DOCTY GMIA DOCTY T889 FI-SL Document Types DOCTY
GMIA LOGSYS GMIA LOGSYS TBDLS Logical system LOGSYS
GMIA RBUKRS GMIA RBUKRS T001 Company Codes BUKRS
GMIA RBUKRS GMIA RCLNT T001 Company Codes MANDT
GMIA RCLNT GMIA RCLNT T000 Clients MANDT
GMIA RLDNR GMIA RCLNT T881 Ledger Master MANDT
GMIA RLDNR GMIA RLDNR T881 Ledger Master RLDNR
GMIA RTCUR GMIA RCLNT TCURC Currency Codes MANDT
GMIA RTCUR GMIA RTCUR TCURC Currency Codes WAERS
GMIA RUNIT GMIA RUNIT T006 Units of Measurement MSEHI
GMIA RUNIT GMIA RCLNT T006 Units of Measurement MANDT
GMIA RVERS GMIA RCLNT T894 FI-SL and FI-LC Versions MANDT
GMIA RVERS GMIA RLDNR T894 FI-SL and FI-LC Versions RLDNR
GMIA RVERS GMIA RVERS T894 FI-SL and FI-LC Versions RVERS
GMIA ZZREGION SYST MANDT ZREG User Defined Regions MANDT
GMIA ZZREGION GMIA ZZREGION ZREG User Defined Regions ZZREGION
GMIA ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
GMIA ZZSPREG GMIA ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
GMIA ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
GMIA ZZSTATE * T005S Taxes: Region (Province) Key LAND1
GMIA ZZSTATE GMIA ZZSTATE T005S Taxes: Region (Province) Key BLAND
GMIA ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
GMIA ZZUSERFLD1 GMIA ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1