P_GMAVCT_Old

Read entries from old table GMAVCT | view: PGMAVCT_OLD | TRAN | Extraction: Not supported | Component: Grantee Management
Tables used: GMAVCT
Column Name Description
rldnr FK Ledger
rrcty Record Type Show values
rvers FK Version
ryear Fiscal Year
robjnr Object number for objects (account assignment elements)
cobjnr Object number for transaction attributes
sobjnr Object number for partner objects (accnt assignmnt elements)
rtcur FK Currency Key
runit FK Base Unit of Measure
drcrk Debit/Credit Indicator Show values
rpmax Period
rbukrs FK Company Code
rgrant_nbr Grant
rfund Fund
rsponsored_prog Sponsored Program
rsponsored_class Sponsored Class
rbdgt_vldty_nbr Budget Validity Number
ceffyear_9 Year of Cash Effectivity
wfstate_9 Workflow Status of a Record in the AVC Totals Table Show values
alloctype_9 Amount Type (Availability Control) Show values
logsys FK Logical system
grantee_fy_9 Fiscal Year for Grantee Organization
sbukrs FK Company Code of Partner
Column Name Description
💲 Currency Key (rtcur):
tslvt Balance carried forward in transaction currency
tsl01 Total of transactions of the period in transaction currency
tsl02 Total of transactions of the period in transaction currency
tsl03 Total of transactions of the period in transaction currency
tsl04 Total of transactions of the period in transaction currency
tsl05 Total of transactions of the period in transaction currency
tsl06 Total of transactions of the period in transaction currency
tsl07 Total of transactions of the period in transaction currency
tsl08 Total of transactions of the period in transaction currency
tsl09 Total of transactions of the period in transaction currency
tsl10 Total of transactions of the period in transaction currency
tsl11 Total of transactions of the period in transaction currency
tsl12 Total of transactions of the period in transaction currency
tsl13 Total of transactions of the period in transaction currency
tsl14 Total of transactions of the period in transaction currency
tsl15 Total of transactions of the period in transaction currency
tsl16 Total of transactions of the period in transaction currency
hslvt Balance carried forward in local currency
hsl01 Total of transactions of the period in local currency
hsl02 Total of transactions of the period in local currency
hsl03 Total of transactions of the period in local currency
hsl04 Total of transactions of the period in local currency
hsl05 Total of transactions of the period in local currency
hsl06 Total of transactions of the period in local currency
hsl07 Total of transactions of the period in local currency
hsl08 Total of transactions of the period in local currency
hsl09 Total of transactions of the period in local currency
hsl10 Total of transactions of the period in local currency
hsl11 Total of transactions of the period in local currency
hsl12 Total of transactions of the period in local currency
hsl13 Total of transactions of the period in local currency
hsl14 Total of transactions of the period in local currency
hsl15 Total of transactions of the period in local currency
hsl16 Total of transactions of the period in local currency
kslvt Balance carried forward in group currency
ksl01 Total of transactions of the period in group currency
ksl02 Total of transactions of the period in group currency
ksl03 Total of transactions of the period in group currency
ksl04 Total of transactions of the period in group currency
ksl05 Total of transactions of the period in group currency
ksl06 Total of transactions of the period in group currency
ksl07 Total of transactions of the period in group currency
ksl08 Total of transactions of the period in group currency
ksl09 Total of transactions of the period in group currency
ksl10 Total of transactions of the period in group currency
ksl11 Total of transactions of the period in group currency
ksl12 Total of transactions of the period in group currency
ksl13 Total of transactions of the period in group currency
ksl14 Total of transactions of the period in group currency
ksl15 Total of transactions of the period in group currency
ksl16 Total of transactions of the period in group currency
Column Name Description
📏 Base Unit of Measure (runit):
mslvt Balance carried forward of quantity
msl01 Total of the transactions of period in units of measure
msl02 Total of the transactions of period in units of measure
msl03 Total of the transactions of period in units of measure
msl04 Total of the transactions of period in units of measure
msl05 Total of the transactions of period in units of measure
msl06 Total of the transactions of period in units of measure
msl07 Total of the transactions of period in units of measure
msl08 Total of the transactions of period in units of measure
msl09 Total of the transactions of period in units of measure
msl10 Total of the transactions of period in units of measure
msl11 Total of the transactions of period in units of measure
msl12 Total of the transactions of period in units of measure
msl13 Total of the transactions of period in units of measure
msl14 Total of the transactions of period in units of measure
msl15 Total of the transactions of period in units of measure
msl16 Total of the transactions of period in units of measure
Column Name Description
Column Name Description
rrcty Record Type Show values
drcrk Debit/Credit Indicator Show values
wfstate_9 Workflow Status of a Record in the AVC Totals Table Show values
alloctype_9 Amount Type (Availability Control) Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Distribution key for currency amounts
  • Distribution key for currency amounts
  • Client
  • P_GMAVCT_OLD.CSPRED == T821S.SPRED
  • P_GMAVCT_OLD.MANDT == T821S.MANDT
Logical system P_GMAVCT_OLD.LOGSYS == TBDLS.LOGSYS
Distribution key for quantities
  • Distribution key for quantities
  • Client
  • P_GMAVCT_OLD.QSPRED == T821S.SPRED
  • P_GMAVCT_OLD.MANDT == T821S.MANDT
Company Code
  • Client
  • Company Code
  • P_GMAVCT_OLD.MANDT == T001.MANDT
  • P_GMAVCT_OLD.RBUKRS == T001.BUKRS
Ledger
  • Ledger
  • Client
  • P_GMAVCT_OLD.RLDNR == T881.RLDNR
  • P_GMAVCT_OLD.MANDT == T881.MANDT
Currency Key
  • Currency Key
  • Client
  • P_GMAVCT_OLD.RTCUR == TCURC.WAERS
  • P_GMAVCT_OLD.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_GMAVCT_OLD.RUNIT == T006.MSEHI
  • P_GMAVCT_OLD.MANDT == T006.MANDT
Version
  • Ledger
  • Client
  • Version
  • P_GMAVCT_OLD.RLDNR == T894.RLDNR
  • P_GMAVCT_OLD.MANDT == T894.MANDT
  • P_GMAVCT_OLD.RVERS == T894.RVERS
Company Code of Partner
  • Company Code of Partner
  • Client
  • P_GMAVCT_OLD.SBUKRS == T001.BUKRS
  • P_GMAVCT_OLD.MANDT == T001.MANDT