GMIA

Actual Line Item Table | #transactional | Component: Grantee Management
Column Name Description
RCLNT FK Client
GL_SIRID Record number of the line item record
Column Name Description
💲 Currency Key (RTCUR):
TSL Value in Transaction Currency
💲 Currency key of currency 2 (T882.CURR1):
HSL Value in local currency
💲 Currency key of the original transaction currency (RWCUR):
WSL Value in Original Transaction Currency (Document Currency)
Column Name Description
📏 Base Unit of Measure (RUNIT):
MSL Quantity
Column Name Description
BUDAT Posting Date in the Document
WSDAT Value Date for Currency Translation
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
Column Name Description
RRCTY Record Type Show values
DOCCT Document Category Show values
RSTATS_IND Statistical Indicator Show values
BDGT_STATE Workflow State of a Record in the Budget Totals Table Show values
REFDOCCT Reference Document Category Show values
XSPLITMOD Item Changed by Document Splitting Show values
BILLING_STATUS Billing Status for Item Show values
ERLKZ Completion Indicator for Line Item Show values
LOEKZ Deletion Indicator Show values
BILLING_BLOCK_9 Billing Block Flag for an Item Show values
DOC_ORIGIN_9 Document's Technical Origin Show values
Column Name Description Domain name
RYEAR Fiscal Year GJAHR
POPER Posting period POPER
DOCNR Document Number of an Accounting Document BELNR
DOCLN Six-Character Posting Item for Ledger DOCLN6
RGRANT_NBR Grant GM_GRANT_NBR
RSPONSORED_PROG Sponsored Program GM_SPONSORED_PROG
RSPONSORED_CLASS Sponsored Class GM_SPONSORED_CLASS
RBDGT_VLDTY_NBR Budget Validity Number GM_BDGT_VLDTY_NBR
RFUND Fund BP_GEBER
RVALUETYPE_9 GM Value Type GM_VALUETYPE
RTRANS Business Transaction J_VORGANG
RGRANTEE_FY_9 Fiscal Year for Grantee Organization GJAHR
SGTXT Item Text TEXT50
ACTIV Business Transaction CHAR4
REFDOCNR Reference document number of an accounting document BELNR
REFRYEAR Reference fiscal year GJAHR
REFDOCLN Six-Digit Number of the Reference Posting Line BUZEI6
REFACTIV FI-SL Business Reference Transaction CHAR4
REFDOC_DETAIL Reference Key AWKEY
USNAM User Name XUBNAME
AWORG Reference Organizational Units AWORG
GL_ACCOUNT General Ledger Account SAKNR
CO_AREA Controlling Area CACCD
COSTCENTER Cost Center KOSTL
ORDERID Order Number AUFNR
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID
PROFIT_CTR Profit Center PRCTR
ASSETMAINO Main Asset Number BF_ANLN1
ASSETSUBNO Asset Subnumber BF_ANLN2
MATERIAL Material Number MATNR
FM_AREA Financial Management Area FIKRS
BUS_AREA Business Area GSBER
FUNDS_CTR Funds Center FISTL
CMMT_ITEM Commitment Item FM_FIPEX
FAREA Functional Area FKBER
MEASURE Funded Program FM_MEASURE
NETWORK Network Number for Account Assignment AUFNR
ROUTING_NO Routing number of operations in the order AUFPL
COUNTER_9 Internal counter CIM_COUNT
OBJ_ORG_P Reference Organizational Units AWORG
OBJ_TYP_P Previous document: Reference procedure AWTYP
OBJ_KEY_P Previous document: Object key (AWREF_REV and AWORG_REV) AWKEY
OBJ_POS_P Previous document: Reference line item AWPOS
BELNR Document Number of an Accounting Document BELNR
BUZEI Number of Line Item Within Accounting Document BUZEI
LINETYPE Item Category LINETYPE
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes
WBS_SHORT_9 Work Breakdown Structure Element (WBS Element) PS_POSNR
AWSYS Logical system LOGSYS
Master Data Relations Join Conditions
Reference procedure GMIA.AWTYP == TTYP.AWTYP
FI-SL Document Type
  • GMIA.RCLNT == T889.MANDT
  • GMIA.DOCTY == T889.DOCTY
Logical system GMIA.LOGSYS == TBDLS.LOGSYS
Company Code
  • GMIA.RCLNT == T001.MANDT
  • GMIA.RBUKRS == T001.BUKRS
Client GMIA.RCLNT == T000.MANDT
Ledger
  • Ledger
  • Client
  • GMIA.RLDNR == T881.RLDNR
  • GMIA.RCLNT == T881.MANDT
Currency Key
  • GMIA.RCLNT == TCURC.MANDT
  • GMIA.RTCUR == TCURC.WAERS
Base Unit of Measure
  • GMIA.RCLNT == T006.MANDT
  • GMIA.RUNIT == T006.MSEHI
Version
  • Ledger
  • Client
  • Version
  • GMIA.RLDNR == T894.RLDNR
  • GMIA.RCLNT == T894.MANDT
  • GMIA.RVERS == T894.RVERS