SAP Table GMREVRESULTALV1

Result list of revaluation

GMREVRESULTALV1 (Result list of revaluation) 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 GMREVRESULTALV1 to other SAP tables.

GMREVRESULTALV1 table fields

Field Data element Checktable Datatype Length Decimals
ICON_STATUS Status GM_ICON_STATUS CHAR 132 0
ST_TEXT Processing Status GM_APPL_STATUS CHAR 36 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
LINE_TYPE Revaluation Result Line Type GM_REV_LINE_TYPE CHAR 20 0
VALUETYPE_TEXT Value Type Text GM_VALUETYPE_TXT CHAR 40 0
REFDOCNR Reference document number of an accounting document REFBELNR CHAR 10 0
REFDOCLN Six-digit number of the reference posting line REFBUZEI6 NUMC 6 0
DOCNR Accounting Document Number BELNR_D CHAR 10 0
DOCLN Six-Character Posting Item for Ledger DOCLN6 CHAR 6 0
REVAL_AMOUNT Revaluated actuals/commitments amount to post GM_REV_ACTUALS_TOPOST CURR 17 2
OLD_AMOUNT Old actuals/commitments amount GM_REV_OLD_ACTUALS CURR 17 2
NEW_AMOUNT New Actual/Commitment Amounts GM_REV_NEW_ACTUALS CURR 17 2
GRANT_CURR Grant currency GM_GRANT_CURRENCY CUKY 5 0
CCODE_YEAR Fiscal Year of Grantee Organization GM_GRANTEE_FY NUMC 4 0
FUND Fund BP_GEBER CHAR 10 0
FUND_TEXT Description FM_BESCHR CHAR 40 0
FM_DOCNR FM Document Number GM_REV_FM_DOCNR CHAR 10 0
FM_DOCLN FM Document Line GM_REV_FM_DOCLN CHAR 6 0
FMBDGT_TOPOST FM budget to post for a grantee year GM_REV_FMBDGT_TOPOST CURR 17 2
AVAIL_FMBDGT_BEFORE Available FM Budget Before GM_REV_AVAIL_FMBDGT_BEFORE CURR 17 2
AVAIL_FMBDGT_AFTER Available FM Budget After Revaluation GM_REV_AVAIL_FMBDGT_AFTER CURR 17 2
TCURR Transaction Currency TWAER CUKY 5 0
TOTAL_GMBDGT Total GM budget for a grantee year GM_REV_TOTAL_GMBDGT CURR 17 2
TOTAL_GMACTUAL Total GM actuals/commitment for a grantee year GM_REV_TOTAL_GMACTUAL CURR 17 2
GMACTUAL_TOPOST GM actuals/commitment to post for a grantee year GM_REV_GMACTUAL_TOPOST CURR 17 2
AVAIL_GMBDGT_BEFORE Available GM budget before GM_REV_AVAIL_GMBDGT_BEFORE CURR 17 2
AVAIL_GMBDGT_AFTER Available GM Budget After GM_REV_AVAIL_GMBDGT_AFTER CURR 17 2
TOTAL_FMBDGT Total FM Budget for a Grantee Year GM_REV_TOTAL_FMBDGT CURR 17 2
TOTAL_FMACTUAL Total FM actuals/commitment for a grantee year GM_REV_TOTAL_FMACTUAL CURR 17 2
OLD_RATE Old Currency Rate GM_REV_OLD_RATE DEC 9 5
NEW_RATE New Currency Rate GM_REV_NEW_RATE DEC 9 5
ST_CODE Status Code GM_STATUS_CODE NUMC 3 0
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
POPER Posting period POPER 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
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
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
TSL Value in Transaction Currency VTCUR9 CURR 17 2
HSL Value in local currency VLCUR9 CURR 17 2
MSL Quantity QUAN1 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
REFRYEAR Reference fiscal year REFGJAHR NUMC 4 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
REFDOC_DETAIL Reference Key AWKEY CHAR 20 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
GL_ACCOUNT General Ledger Account HKONT CHAR 10 0
CO_AREA Controlling Area KOKRS CHAR 4 0
COSTCENTER Cost Center KOSTL CHAR 10 0
ORDERID Order Number AUFNR CHAR 12 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
PROFIT_CTR Profit Center PRCTR CHAR 10 0
ASSETMAINO Main Asset Number BF_ANLN1 CHAR 12 0
ASSETSUBNO Asset Subnumber BF_ANLN2 CHAR 4 0
MATERIAL Material Number MATNR CHAR 18 0
FM_AREA Financial Management Area FIKRS CHAR 4 0
BUS_AREA Business Area GSBER CHAR 4 0
FUNDS_CTR Funds Center FISTL CHAR 16 0
CMMT_ITEM Commitment Item FM_FIPEX CHAR 24 0
FAREA Functional Area FM_FAREA CHAR 16 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
NETWORK Network Number for Account Assignment NPLNR CHAR 12 0
ROUTING_NO Routing number of operations in the order CO_AUFPL NUMC 10 0
COUNTER_9 Internal counter CIM_COUNT NUMC 8 0
OBJ_ORG_P Reference Organizational Units AWORG CHAR 10 0
OBJ_TYP_P Previous document: Reference procedure AWTYP_PRE CHAR 5 0
OBJ_KEY_P Previous document: Object key (AWREF_REV and AWORG_REV) AWKEY_PRE CHAR 20 0
OBJ_POS_P Previous document: Reference line item AWPOS_PRE CHAR 10 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
LINETYPE Item category LINETYPE CHAR 5 0
XSPLITMOD Item changed by document splitting XSPLITMOD CHAR 1 0
X Yes
NULL No
WSL Value in Original Transaction Currency (Document Currency) VWCUR12 CURR 23 2
RWCUR Currency key of the original transaction currency RWCUR CUKY 5 0
BILLING_STATUS Billing Status for Item GM_BILLING_STATUS CHAR 1 0
B Billed
P Partially Billed
O Over-billed
NULL Unbilled
ERLKZ Completion Indicator for Line Item GM_ERLKZ CHAR 1 0
NULL Not Selected
X Selected
LOEKZ Deletion Indicator GM_LOEKZ CHAR 1 0
NULL Not Selected
X Selected
BILLING_BLOCK_9 Billing Block Flag for an Item GM_BILLING_BLOCK CHAR 1 0
NULL Unblocked
X Blocked
RPMAX Period RPMAX NUMC 3 0
FLG_ADDED Indicator for Additional Line BUED_FLG_ADDED CHAR 1 0
X Created by Rules From The CO-PA Derivation Tool
R Created by The Process of Automatic Release
A Created by the Rollup in the context of Distribution
D Created for distribution consistency
S Created by automatic release from D or A lines
CTEM_CATEGORY Commitment Item Category FM_POTYP NUMC 1 0
1 Balance
2 Revenues
3 Expenditures
4 Balances
5 Clarification Worklist
FISCYEAR Fiscal Year GJAHR NUMC 4 0
CEFFYEAR Year of Cash Effectivity GNJHR NUMC 4 0
BUDCAT Budget Category BUKU_BUDCAT CHAR 2 0
VALTYPE BCS Value Type BUKU_VALTYPE CHAR 2 0
PROCESS Internal Budgeting Process BUKU_PROCESS CHAR 4 0
BUDTYPE Budget Type BUKU_BUDTYPE CHAR 4 0
FUNDSCTR Funds Center FISTL CHAR 16 0
CMMTITEM Commitment Item FM_FIPEX CHAR 24 0
FUNCAREA Functional Area FM_FAREA CHAR 16 0
USERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM CHAR 10 0
TVAL01 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL02 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL03 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL04 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL05 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL06 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL07 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL08 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL09 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL10 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL11 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL12 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL13 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL14 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL15 Budget amount in transaction currency TVALXX9 CURR 17 2
TVAL16 Budget amount in transaction currency TVALXX9 CURR 17 2
LVAL01 Budget amount in local currency LVALXX9 CURR 17 2
LVAL02 Budget amount in local currency LVALXX9 CURR 17 2
LVAL03 Budget amount in local currency LVALXX9 CURR 17 2
LVAL04 Budget amount in local currency LVALXX9 CURR 17 2
LVAL05 Budget amount in local currency LVALXX9 CURR 17 2
LVAL06 Budget amount in local currency LVALXX9 CURR 17 2
LVAL07 Budget amount in local currency LVALXX9 CURR 17 2
LVAL08 Budget amount in local currency LVALXX9 CURR 17 2
LVAL09 Budget amount in local currency LVALXX9 CURR 17 2
LVAL10 Budget amount in local currency LVALXX9 CURR 17 2
LVAL11 Budget amount in local currency LVALXX9 CURR 17 2
LVAL12 Budget amount in local currency LVALXX9 CURR 17 2
LVAL13 Budget amount in local currency LVALXX9 CURR 17 2
LVAL14 Budget amount in local currency LVALXX9 CURR 17 2
LVAL15 Budget amount in local currency LVALXX9 CURR 17 2
LVAL16 Budget amount in local currency LVALXX9 CURR 17 2
DISTKEY Distribution Key SPRED CHAR 4 0
TEXT50 Item Text SGTXT CHAR 50 0
GRANT_SHORT_DESCRIPTION Shorter description of the grant GM_SHORT_DESCRIPTION CHAR 20 0

GMREVRESULTALV1 foreign key relationships

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