SAP ABAP Table GMIA (Actual Line Item Table)
Hierarchy
☛
EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷ PSM-GM-GTE (Application Component) Grantee Management
⤷ GMBASIS_E (Package) Grants management (basis)
⤷ PSM-GM-GTE (Application Component) Grantee Management
⤷ GMBASIS_E (Package) Grants management (basis)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | GMIA | Table Relationship Diagram |
Short Description | Actual Line Item Table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | RCLNT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | GL_SIRID | GU_RECID | OBJNR | CHAR | 18 | 0 | Record number of the line item record | ||
3 | RLDNR | RLDNR | RLDNR | CHAR | 2 | 0 | Ledger | T881 | |
4 | RRCTY | RRCTY | RRCTY | CHAR | 1 | 0 | Record Type | ||
5 | RVERS | RVERS | RVERS | CHAR | 3 | 0 | Version | T894 | |
6 | RYEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
7 | RTCUR | RTCUR | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
8 | RUNIT | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
9 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
10 | DOCCT | DOCCT | DOCCT | CHAR | 1 | 0 | Document Type | ||
11 | DOCNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
12 | DOCLN | DOCLN6 | DOCLN6 | CHAR | 6 | 0 | Six-Character Posting Item for Ledger | ||
13 | RBUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
14 | RGRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
15 | RSPONSORED_PROG | GM_SPONSORED_PROG | GM_SPONSORED_PROG | CHAR | 20 | 0 | Sponsored Program | * | |
16 | RSPONSORED_CLASS | GM_SPONSORED_CLASS | GM_SPONSORED_CLASS | CHAR | 20 | 0 | Sponsored Class | * | |
17 | RBDGT_VLDTY_NBR | GM_BDGT_VLDTY_NBR | GM_BDGT_VLDTY_NBR | CHAR | 3 | 0 | Budget Validity Number | ||
18 | RFUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
19 | RVALUETYPE_9 | GM_VALUETYPE | GM_VALUETYPE | CHAR | 2 | 0 | GM Value Type | ||
20 | RTRANS | J_VORGANG | J_VORGANG | CHAR | 4 | 0 | Business Transaction | * | |
21 | RSTATS_IND | GM_STATS | GM_STATS | CHAR | 1 | 0 | Statistical Indicator | ||
22 | RGRANTEE_FY_9 | GM_GRANTEE_FY | GJAHR | NUMC | 4 | 0 | Fiscal Year of Grantee Organization | ||
23 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
24 | BDGT_STATE | GM_BDGT_STATE | GM_BDGT_STATE | CHAR | 1 | 0 | Workflow State of a Record in the Budget Totals Table | ||
25 | TSL | VTCUR9 | WERTV9 | CURR | 17 | 2 | Value in Transaction Currency | ||
26 | HSL | VLCUR9 | WERTV9 | CURR | 17 | 2 | Value in local currency | ||
27 | MSL | QUAN1 | MENG8 | QUAN | 15 | 3 | Quantity | ||
28 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
29 | DOCTY | DOCTY | DOCTY | CHAR | 2 | 0 | FI-SL Document Type | T889 | |
30 | ACTIV | GLVOR | CHAR4 | CHAR | 4 | 0 | Business Transaction | ||
31 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
32 | WSDAT | WSDAT | DATUM | DATS | 8 | 0 | Value Date for Currency Translation | ||
33 | REFDOCNR | REFBELNR | BELNR | CHAR | 10 | 0 | Reference document number of an accounting document | ||
34 | REFRYEAR | REFGJAHR | GJAHR | NUMC | 4 | 0 | Reference fiscal year | ||
35 | REFDOCLN | REFBUZEI6 | BUZEI6 | NUMC | 6 | 0 | Six-digit number of the reference posting line | ||
36 | REFDOCCT | REFDOCCT | DOCCT | CHAR | 1 | 0 | Reference document category | ||
37 | REFACTIV | REFGLVOR | CHAR4 | CHAR | 4 | 0 | FI-SL Business Reference Transaction | ||
38 | REFDOC_DETAIL | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
39 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
40 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
41 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
42 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | TTYP | |
43 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
44 | GL_ACCOUNT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
45 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
46 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
47 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
48 | WBS_ELEMENT | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
49 | PROFIT_CTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
50 | ASSETMAINO | BF_ANLN1 | BF_ANLN1 | CHAR | 12 | 0 | Main Asset Number | ||
51 | ASSETSUBNO | BF_ANLN2 | BF_ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ||
52 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
53 | FM_AREA | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
54 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
55 | FUNDS_CTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
56 | CMMT_ITEM | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | * | |
57 | FAREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | * | |
58 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
59 | NETWORK | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
60 | ROUTING_NO | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
61 | COUNTER_9 | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
62 | OBJ_ORG_P | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
63 | OBJ_TYP_P | AWTYP_PRE | AWTYP | CHAR | 5 | 0 | Previous document: Reference procedure | * | |
64 | OBJ_KEY_P | AWKEY_PRE | AWKEY | CHAR | 20 | 0 | Previous document: Object key (AWREF_REV and AWORG_REV) | ||
65 | OBJ_POS_P | AWPOS_PRE | AWPOS | CHAR | 10 | 0 | Previous document: Reference line item | ||
66 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
67 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
68 | LINETYPE | LINETYPE | LINETYPE | CHAR | 5 | 0 | Item category | * | |
69 | XSPLITMOD | XSPLITMOD | XFELD | CHAR | 1 | 0 | Item changed by document splitting | ||
70 | WSL | VWCUR12 | WERTV12 | CURR | 23 | 2 | Value in Original Transaction Currency (Document Currency) | ||
71 | RWCUR | RWCUR | WAERS | CUKY | 5 | 0 | Currency key of the original transaction currency | * | |
72 | BILLING_STATUS | GM_BILLING_STATUS | GM_BILLING_STATUS | CHAR | 1 | 0 | Billing Status for Item | ||
73 | ERLKZ | GM_ERLKZ | CHAR1_X | CHAR | 1 | 0 | Completion Indicator for Line Item | ||
74 | LOEKZ | GM_LOEKZ | CHAR1_X | CHAR | 1 | 0 | Deletion Indicator | ||
75 | BILLING_BLOCK_9 | GM_BILLING_BLOCK | GM_BILLING_BLOCK | CHAR | 1 | 0 | Billing Block Flag for an Item | ||
76 | DOC_ORIGIN_9 | GM_TECHORG | GM_TECHORG | CHAR | 1 | 0 | Document's Technical Origin | ||
77 | .INCLUDE | 0 | 0 | ||||||
78 | WBS_SHORT_9 | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | GMIA | AWTYP | TTYP | AWTYP | REF | C | CN |
2 | GMIA | DOCTY | T889 | DOCTY | REF | C | CN |
3 | GMIA | LOGSYS | TBDLS | LOGSYS | REF | C | CN |
4 | GMIA | RBUKRS | T001 | BUKRS | REF | C | CN |
5 | GMIA | RCLNT | T000 | MANDT | KEY | 1 | CN |
6 | GMIA | RLDNR | T881 | RLDNR | REF | C | CN |
7 | GMIA | RTCUR | TCURC | WAERS | REF | C | CN |
8 | GMIA | RUNIT | T006 | MSEHI | REF | C | CN |
9 | GMIA | RVERS | T894 | RVERS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462A |