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