1. SAP Tutorial
  2. SAP PSM

GMIA SAP table for – Actual Line Item Table

Here we would like to draw your attention to GMIA table in SAP. As we know it is being mainly used with the SAP PSM-GM (Grants Management in PSM) component which is coming under PSM module (Public Sector Management). GMIA is a SAP standard transp table used for storing Actual Line Item Table related data in SAP. It comes under the package GMBASIS_E.

SAP GMIA table

Table GMIA technical data

TableGMIA
Data storingActual Line Item Table
ModulePSM
Sub ModulePSM-GM-GTE
SAP PackageGMBASIS_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP GMIA Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in GMIA table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GL_SIRID : Record number of the line item record
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RLDNR : Ledger
    Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RTCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RUNIT : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • POPER : Posting period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • DOCNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • DOCLN : Six-Character Posting Item for Ledger
    Its data type is CHAR (Character String) with field length 6
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RGRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • RSPONSORED_PROG : Sponsored Program
    Its data type is CHAR (Character String) with field length 20
  • RSPONSORED_CLASS : Sponsored Class
    Its data type is CHAR (Character String) with field length 20
  • RBDGT_VLDTY_NBR : Budget Validity Number
    Its data type is CHAR (Character String) with field length 3
  • RFUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • RVALUETYPE_9 : GM Value Type
    Its data type is CHAR (Character String) with field length 2
  • RTRANS : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • RSTATS_IND : Statistical Indicator
    Its data type is CHAR (Character String) with field length 1
  • RGRANTEE_FY_9 : Fiscal Year of Grantee Organization
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • BDGT_STATE : Workflow State of a Record in the Budget Totals Table
    Its data type is CHAR (Character String) with field length 1
  • TSL : Value in Transaction Currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL : Value in local currency
    Its data type is CURR (Currency Field) with field length 17
  • MSL : Quantity
    Its data type is QUAN (Quantity field) with field length 15
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • DOCTY : FI-SL Document Type
    Its data type is CHAR (Character String) with field length 2
  • ACTIV : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WSDAT : Value Date for Currency Translation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REFDOCNR : Reference document number of an accounting document
    Its data type is CHAR (Character String) with field length 10
  • REFRYEAR : Reference fiscal year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFDOCLN : Six-digit number of the reference posting line
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REFDOCCT : Reference document category
    Its data type is CHAR (Character String) with field length 1
  • REFACTIV : FI-SL Business Reference Transaction
    Its data type is CHAR (Character String) with field length 4
  • REFDOC_DETAIL : Object key
    Its data type is CHAR (Character String) with field length 20
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10
  • GL_ACCOUNT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • CO_AREA : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • COSTCENTER : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • ORDERID : Order Number
    Its data type is CHAR (Character String) with field length 12
  • WBS_ELEMENT : Work Breakdown Structure Element (WBS Element)
    Its data type is CHAR (Character String) with field length 24
  • PROFIT_CTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • ASSETMAINO : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ASSETSUBNO : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • MATERIAL : Material Number
    Its data type is CHAR (Character String) with field length 18
  • FM_AREA : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • BUS_AREA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • FUNDS_CTR : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • CMMT_ITEM : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • NETWORK : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • ROUTING_NO : Routing number of operations in the order
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • COUNTER_9 : Internal counter
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • OBJ_ORG_P : Reference organisational units
    Its data type is CHAR (Character String) with field length 10
  • OBJ_TYP_P : Previous document: Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • OBJ_KEY_P : Previous document: Object key (AWREF_REV and AWORG_REV)
    Its data type is CHAR (Character String) with field length 20
  • OBJ_POS_P : Previous document: Reference line item
    Its data type is CHAR (Character String) with field length 10
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • LINETYPE : Item category
    Its data type is CHAR (Character String) with field length 5
  • XSPLITMOD : Item changed by document splitting
    Its data type is CHAR (Character String) with field length 1
  • WSL : Value in Original Transaction Currency (Document Currency)
    Its data type is CURR (Currency Field) with field length 23
  • RWCUR : Currency key of the original transaction currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BILLING_STATUS : Billing Status for Item
    Its data type is CHAR (Character String) with field length 1
  • ERLKZ : Completion Indicator for Line Item
    Its data type is CHAR (Character String) with field length 1
  • LOEKZ : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • BILLING_BLOCK_9 : Billing Block Flag for an Item
    Its data type is CHAR (Character String) with field length 1
  • DOC_ORIGIN_9 : Document’s Technical Origin
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • WBS_SHORT_9 : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8

    • GMIA related tables

    • GMVALUETYPE : Value Type definition
    • GMGRANTNONE : Definition of Grant used as “Non-Relevant”
    • GMCCSETTINGS : Company code settings
    • GMAVCA : Actual line item table
    • GMAVCT : Summary table
    • GMFIUPD : FI Settings for Grants Management Update
    • GMIO : Object table GMIO
    • GMIA : Actual Line Item Table
    • GMAVCC : Object table 2
    • GMCOUPD : CO Settings for Grants Management Update
    • GMVALUETYPE_TEXT : Value Type texts
    • GMIT : Summary table
    • GMAVCO : Object table 1
    • GMAVCP : Plan line items table
    • GMIP : Plan line items table
    • GMIC : Object table GMIC

    GMIA related transaction codes under SAP package GMBASIS_E

    • S_P7U_18000004 : IMG Activity: SIMG_GM_MM_TO_GM
    • S_ALN_01000079 : Master Data Index for Grant
    • S_KI4_38000356 : Program GMCOACTIVATE
    • GMNRG : Set Not Relevant Grant
    • GM_CC_SETTINGS : Maintain Company Code Settings
    • S_PLN_16000269 : Grants Management: Line Item Display
    • GM_UPD_SETTINGS : Maintain Update Settings
    • GM_VALUETYPES : Maintain Value Types

    Related References

    Related Tutorials

    GMAVCA SAP table for – Actual line item table

    GMAVCA table in SAP PSM (Grants Management in PSM) module. This table is used for storing data of Actual line...

    FMRBA SAP table for – Actual line item table

    FMRBA table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Actual line...

    FMBDA SAP table for – Actual line item table

    FMBDA table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Actual line...

    FMAVCA SAP table for – Actual line item table

    FMAVCA table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Actual line...

    FMSPLITA SAP table for – Actual line item table

    FMSPLITA table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Actual line...

    FMUSFGFACTS1A SAP table for – Actual line item table

    FMUSFGFACTS1A table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Actual line...

    FMUSFGFACTS2A SAP table for – Actual line item table

    FMUSFGFACTS2A table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Actual line...

    «
    »