GMAVCA

Actual line item table | #transactional | Component: Grantee Management

🔑 Keys (2)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (6)
Other (19)
🔗 Relations (10)

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 currency 3 (T882.CURR2):
KSL	Value in group 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
DRCRK	Debit/Credit Indicator	Show values
DOCCT	Document Category	Show values
WFSTATE_9	Workflow Status of a Record in the AVC Totals Table	Show values
ALLOCTYPE_9	Amount Type (Availability Control)	Show values
REFDOCCT	Reference Document Category	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
RFUND	Fund	BP_GEBER
RSPONSORED_PROG	Sponsored Program	GM_SPONSORED_PROG
RSPONSORED_CLASS	Sponsored Class	GM_SPONSORED_CLASS
RBDGT_VLDTY_NBR	Budget Validity Number	GM_BDGT_VLDTY_NBR
CEFFYEAR_9	Year of Cash Effectivity	GJAHR
GRANTEE_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
USNAM	User Name	XUBNAME
AWORG	Reference Organizational Units	AWORG

Master Data Relations	Join Conditions
Reference procedure	`GMAVCA.AWTYP == TTYP.AWTYP`
FI-SL Document Type	`GMAVCA.RCLNT == T889.MANDT` `GMAVCA.DOCTY == T889.DOCTY`
Logical system	`GMAVCA.LOGSYS == TBDLS.LOGSYS`
Company Code	`GMAVCA.RCLNT == T001.MANDT` `GMAVCA.RBUKRS == T001.BUKRS`
Client	`GMAVCA.RCLNT == T000.MANDT`
Ledger Ledger Client	`GMAVCA.RLDNR == T881.RLDNR` `GMAVCA.RCLNT == T881.MANDT`
Currency Key	`GMAVCA.RCLNT == TCURC.MANDT` `GMAVCA.RTCUR == TCURC.WAERS`
Base Unit of Measure	`GMAVCA.RCLNT == T006.MANDT` `GMAVCA.RUNIT == T006.MSEHI`
Version Ledger Client Version	`GMAVCA.RLDNR == T894.RLDNR` `GMAVCA.RCLNT == T894.MANDT` `GMAVCA.RVERS == T894.RVERS`
Company Code of Partner	`GMAVCA.RCLNT == T001.MANDT` `GMAVCA.SBUKRS == T001.BUKRS`