SAP ABAP Table GMREVRESULTALV1 (Result list of revaluation)
Hierarchy
☛
EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷ PSM-GM-GTE-UP (Application Component) Actual Update and Commitment Update
⤷ GMACCOUNTING_E (Package) Grants management (accounting)
⤷ PSM-GM-GTE-UP (Application Component) Actual Update and Commitment Update
⤷ GMACCOUNTING_E (Package) Grants management (accounting)
Basic Data
Table Category | INTTAB | Structure |
Structure | GMREVRESULTALV1 | Table Relationship Diagram |
Short Description | Result list of revaluation |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | ICON_STATUS | GM_ICON_STATUS | SYCHAR132 | CHAR | 132 | 0 | Status | ||
2 | ST_TEXT | GM_APPL_STATUS | CHAR36 | CHAR | 36 | 0 | Processing Status | ||
3 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
4 | LINE_TYPE | GM_REV_LINE_TYPE | CHAR20 | CHAR | 20 | 0 | Revaluation Result Line Type | ||
5 | VALUETYPE_TEXT | GM_VALUETYPE_TXT | TEXT40 | CHAR | 40 | 0 | Value Type Text | ||
6 | REFDOCNR | REFBELNR | BELNR | CHAR | 10 | 0 | Reference document number of an accounting document | ||
7 | REFDOCLN | REFBUZEI6 | BUZEI6 | NUMC | 6 | 0 | Six-digit number of the reference posting line | ||
8 | DOCNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
9 | DOCLN | DOCLN6 | DOCLN6 | CHAR | 6 | 0 | Six-Character Posting Item for Ledger | ||
10 | REVAL_AMOUNT | GM_REV_ACTUALS_TOPOST | CURR | 17 | 2 | Revaluated actuals/commitments amount to post | |||
11 | OLD_AMOUNT | GM_REV_OLD_ACTUALS | CURR | 17 | 2 | Old actuals/commitments amount | |||
12 | NEW_AMOUNT | GM_REV_NEW_ACTUALS | CURR | 17 | 2 | New Actual/Commitment Amounts | |||
13 | GRANT_CURR | GM_GRANT_CURRENCY | WAERS | CUKY | 5 | 0 | Grant currency | * | |
14 | CCODE_YEAR | GM_GRANTEE_FY | GJAHR | NUMC | 4 | 0 | Fiscal Year of Grantee Organization | ||
15 | FUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
16 | FUND_TEXT | FM_BESCHR | TEXT40 | CHAR | 40 | 0 | Description | ||
17 | FM_DOCNR | GM_REV_FM_DOCNR | CHAR10 | CHAR | 10 | 0 | FM Document Number | ||
18 | FM_DOCLN | GM_REV_FM_DOCLN | CHAR6 | CHAR | 6 | 0 | FM Document Line | ||
19 | FMBDGT_TOPOST | GM_REV_FMBDGT_TOPOST | CURR | 17 | 2 | FM budget to post for a grantee year | |||
20 | AVAIL_FMBDGT_BEFORE | GM_REV_AVAIL_FMBDGT_BEFORE | CURR | 17 | 2 | Available FM Budget Before | |||
21 | AVAIL_FMBDGT_AFTER | GM_REV_AVAIL_FMBDGT_AFTER | CURR | 17 | 2 | Available FM Budget After Revaluation | |||
22 | TCURR | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | * | |
23 | TOTAL_GMBDGT | GM_REV_TOTAL_GMBDGT | CURR | 17 | 2 | Total GM budget for a grantee year | |||
24 | TOTAL_GMACTUAL | GM_REV_TOTAL_GMACTUAL | CURR | 17 | 2 | Total GM actuals/commitment for a grantee year | |||
25 | GMACTUAL_TOPOST | GM_REV_GMACTUAL_TOPOST | CURR | 17 | 2 | GM actuals/commitment to post for a grantee year | |||
26 | AVAIL_GMBDGT_BEFORE | GM_REV_AVAIL_GMBDGT_BEFORE | CURR | 17 | 2 | Available GM budget before | |||
27 | AVAIL_GMBDGT_AFTER | GM_REV_AVAIL_GMBDGT_AFTER | CURR | 17 | 2 | Available GM Budget After | |||
28 | TOTAL_FMBDGT | GM_REV_TOTAL_FMBDGT | CURR | 17 | 2 | Total FM Budget for a Grantee Year | |||
29 | TOTAL_FMACTUAL | GM_REV_TOTAL_FMACTUAL | CURR | 17 | 2 | Total FM actuals/commitment for a grantee year | |||
30 | OLD_RATE | GM_REV_OLD_RATE | DEC | 9 | 5 | Old Currency Rate | |||
31 | ST_CODE | GM_STATUS_CODE | NUMC | 3 | 0 | Status Code | |||
32 | RCLNT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
33 | GL_SIRID | GU_RECID | OBJNR | CHAR | 18 | 0 | Record number of the line item record | ||
34 | RLDNR | RLDNR | RLDNR | CHAR | 2 | 0 | Ledger | T881 | |
35 | RRCTY | RRCTY | RRCTY | CHAR | 1 | 0 | Record Type | ||
36 | RVERS | RVERS | RVERS | CHAR | 3 | 0 | Version | T894 | |
37 | RYEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
38 | RTCUR | RTCUR | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
39 | RUNIT | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
40 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
41 | DOCCT | DOCCT | DOCCT | CHAR | 1 | 0 | Document Type | ||
42 | RBUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
43 | RGRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
44 | RSPONSORED_PROG | GM_SPONSORED_PROG | GM_SPONSORED_PROG | CHAR | 20 | 0 | Sponsored Program | * | |
45 | RSPONSORED_CLASS | GM_SPONSORED_CLASS | GM_SPONSORED_CLASS | CHAR | 20 | 0 | Sponsored Class | * | |
46 | RBDGT_VLDTY_NBR | GM_BDGT_VLDTY_NBR | GM_BDGT_VLDTY_NBR | CHAR | 3 | 0 | Budget Validity Number | ||
47 | RFUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
48 | RVALUETYPE_9 | GM_VALUETYPE | GM_VALUETYPE | CHAR | 2 | 0 | GM Value Type | ||
49 | RTRANS | J_VORGANG | J_VORGANG | CHAR | 4 | 0 | Business Transaction | * | |
50 | RSTATS_IND | GM_STATS | GM_STATS | CHAR | 1 | 0 | Statistical Indicator | ||
51 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
52 | BDGT_STATE | GM_BDGT_STATE | GM_BDGT_STATE | CHAR | 1 | 0 | Workflow State of a Record in the Budget Totals Table | ||
53 | TSL | VTCUR9 | WERTV9 | CURR | 17 | 2 | Value in Transaction Currency | ||
54 | HSL | VLCUR9 | WERTV9 | CURR | 17 | 2 | Value in local currency | ||
55 | MSL | QUAN1 | MENG8 | QUAN | 15 | 3 | Quantity | ||
56 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
57 | DOCTY | DOCTY | DOCTY | CHAR | 2 | 0 | FI-SL Document Type | T889 | |
58 | ACTIV | GLVOR | CHAR4 | CHAR | 4 | 0 | Business Transaction | ||
59 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
60 | WSDAT | WSDAT | DATUM | DATS | 8 | 0 | Value Date for Currency Translation | ||
61 | REFRYEAR | REFGJAHR | GJAHR | NUMC | 4 | 0 | Reference fiscal year | ||
62 | REFDOCCT | REFDOCCT | DOCCT | CHAR | 1 | 0 | Reference document category | ||
63 | REFACTIV | REFGLVOR | CHAR4 | CHAR | 4 | 0 | FI-SL Business Reference Transaction | ||
64 | REFDOC_DETAIL | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
65 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
66 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
67 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
68 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | TTYP | |
69 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
70 | GL_ACCOUNT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
71 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
72 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
73 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
74 | WBS_ELEMENT | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
75 | PROFIT_CTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
76 | ASSETMAINO | BF_ANLN1 | BF_ANLN1 | CHAR | 12 | 0 | Main Asset Number | ||
77 | ASSETSUBNO | BF_ANLN2 | BF_ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ||
78 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
79 | FM_AREA | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
80 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
81 | FUNDS_CTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
82 | CMMT_ITEM | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | * | |
83 | FAREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | * | |
84 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
85 | NETWORK | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
86 | ROUTING_NO | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
87 | COUNTER_9 | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
88 | OBJ_ORG_P | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
89 | OBJ_TYP_P | AWTYP_PRE | AWTYP | CHAR | 5 | 0 | Previous document: Reference procedure | * | |
90 | OBJ_KEY_P | AWKEY_PRE | AWKEY | CHAR | 20 | 0 | Previous document: Object key (AWREF_REV and AWORG_REV) | ||
91 | OBJ_POS_P | AWPOS_PRE | AWPOS | CHAR | 10 | 0 | Previous document: Reference line item | ||
92 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
93 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
94 | LINETYPE | LINETYPE | LINETYPE | CHAR | 5 | 0 | Item category | * | |
95 | XSPLITMOD | XSPLITMOD | XFELD | CHAR | 1 | 0 | Item changed by document splitting | ||
96 | WSL | VWCUR12 | WERTV12 | CURR | 23 | 2 | Value in Original Transaction Currency (Document Currency) | ||
97 | RWCUR | RWCUR | WAERS | CUKY | 5 | 0 | Currency key of the original transaction currency | * | |
98 | BILLING_STATUS | GM_BILLING_STATUS | GM_BILLING_STATUS | CHAR | 1 | 0 | Billing Status for Item | ||
99 | ERLKZ | GM_ERLKZ | CHAR1_X | CHAR | 1 | 0 | Completion Indicator for Line Item | ||
100 | LOEKZ | GM_LOEKZ | CHAR1_X | CHAR | 1 | 0 | Deletion Indicator | ||
101 | BILLING_BLOCK_9 | GM_BILLING_BLOCK | GM_BILLING_BLOCK | CHAR | 1 | 0 | Billing Block Flag for an Item | ||
102 | RPMAX | RPMAX | RPMAX | NUMC | 3 | 0 | Period | ||
103 | FLG_ADDED | BUED_FLG_ADDED | BUED_FLG_ADDED | CHAR | 1 | 0 | Indicator for Additional Line | ||
104 | CTEM_CATEGORY | FM_POTYP | FM_POTYP | NUMC | 1 | 0 | Commitment Item Category | ||
105 | FISCYEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
106 | CEFFYEAR | GNJHR | GJAHR | NUMC | 4 | 0 | Year of Cash Effectivity | ||
107 | BUDCAT | BUKU_BUDCAT | RLDNR | CHAR | 2 | 0 | Budget Category | * | |
108 | VALTYPE | BUKU_VALTYPE | BUKU_VALTYPE | CHAR | 2 | 0 | BCS Value Type | * | |
109 | PROCESS | BUKU_PROCESS | BUKU_PROCESS | CHAR | 4 | 0 | Internal Budgeting Process | * | |
110 | BUDTYPE | BUKU_BUDTYPE | CHAR4 | CHAR | 4 | 0 | Budget Type | ||
111 | FUNDSCTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
112 | CMMTITEM | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | * | |
113 | FUNCAREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | * | |
114 | USERDIM | FM_USERDIM | CHAR10 | CHAR | 10 | 0 | Customer Field for FM Actual and Commitment Data | ||
115 | TVAL01 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
116 | TVAL02 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
117 | TVAL03 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
118 | TVAL04 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
119 | TVAL05 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
120 | TVAL06 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
121 | TVAL07 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
122 | TVAL08 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
123 | TVAL09 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
124 | TVAL10 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
125 | TVAL11 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
126 | TVAL12 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
127 | TVAL13 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
128 | TVAL14 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
129 | TVAL15 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
130 | TVAL16 | TVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in transaction currency | ||
131 | LVAL01 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
132 | LVAL02 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
133 | LVAL03 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
134 | LVAL04 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
135 | LVAL05 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
136 | LVAL06 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
137 | LVAL07 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
138 | LVAL08 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
139 | LVAL09 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
140 | LVAL10 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
141 | LVAL11 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
142 | LVAL12 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
143 | LVAL13 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
144 | LVAL14 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
145 | LVAL15 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
146 | LVAL16 | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
147 | DISTKEY | SPRED | SPRED | CHAR | 4 | 0 | Distribution Key | * | |
148 | TEXT50 | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
149 | GRANT_SHORT_DESCRIPTION | GM_SHORT_DESCRIPTION | CHAR | 20 | 0 | Shorter description of the grant |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | GMREVRESULTALV1 | AWTYP | TTYP | AWTYP | REF | C | CN |
2 | GMREVRESULTALV1 | DOCTY | T889 | DOCTY | REF | C | CN |
3 | GMREVRESULTALV1 | LOGSYS | TBDLS | LOGSYS | REF | C | CN |
4 | GMREVRESULTALV1 | RBUKRS | T001 | BUKRS | REF | C | CN |
5 | GMREVRESULTALV1 | RCLNT | T000 | MANDT | KEY | 1 | CN |
6 | GMREVRESULTALV1 | RLDNR | T881 | RLDNR | REF | C | CN |
7 | GMREVRESULTALV1 | RTCUR | TCURC | WAERS | REF | C | CN |
8 | GMREVRESULTALV1 | RUNIT | T006 | MSEHI | REF | C | CN |
9 | GMREVRESULTALV1 | RVERS | T894 | RVERS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 110 |