SAP table GMIA (Actual Line Item Table)

SAP table GMIA has 2 primary key fields being RCLNT,GL_SIRID.

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

GMIA foreign key relationships

Table Field Check Table Check Field
0 GMIA AWTYP TTYP Object Types for Accounting AWTYP
1 GMIA DOCTY T889 FI-SL Document Types MANDT
1 GMIA DOCTY T889 FI-SL Document Types DOCTY
0 GMIA LOGSYS TBDLS Logical system LOGSYS
1 GMIA RBUKRS T001 Company Codes BUKRS
0 GMIA RCLNT T000 Clients MANDT
1 GMIA RLDNR T881 Ledger Master MANDT
0 GMIA RTCUR TCURC Currency Codes MANDT
0 GMIA RTCUR TCURC Currency Codes WAERS
1 GMIA RUNIT T006 Units of Measurement MSEHI
0 GMIA RVERS T894 FI-SL and FI-LC Versions MANDT
0 GMIA RVERS T894 FI-SL and FI-LC Versions RLDNR
0 GMIA RVERS T894 FI-SL and FI-LC Versions RVERS