1. Home
  2. Resources
  3. SAP Tables
  4. GMIP - Plan line items table

SAP Table GMIP

Plan line items table

GMIP (Plan line items 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 GMIP to other SAP tables.

GMIP 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
RPMAX Period RPMAX 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
TSLVT Balance carried forward in transaction currency TSLVT9 CURR 17 2
TSL01 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL02 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL03 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL04 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL05 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL06 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL07 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL08 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL09 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL10 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL11 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL12 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL13 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL14 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL15 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL16 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
HSLVT Balance carried forward in local currency HSLVT9 CURR 17 2
HSL01 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL02 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL03 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL04 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL05 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL06 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL07 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL08 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL09 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL10 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL11 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL12 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL13 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL14 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL15 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL16 Total of transactions of the period in local currency HSLXX9 CURR 17 2
MSLVT Balance carried forward of quantity MSLVT QUAN 15 3
MSL01 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL02 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL03 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL04 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL05 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL06 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL07 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL08 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL09 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL10 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL11 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL12 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL13 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL14 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL15 Total of the transactions of period in units of measure MSLXX QUAN 15 3
MSL16 Total of the transactions of period in units of measure MSLXX 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
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

GMIP foreign key relationships

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