FMFGGLU1 SAP (All fields of US-Federal ledgers 95, 96 and 97) Structure details
Description: All fields of US-Federal ledgers 95, 96 and 97
Structure field list including key, data, relationships and ABAP select examples
FMFGGLU1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "All fields of US-Federal ledgers 95, 96 and 97" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FMFGGLU1 TYPE FMFGGLU1.
The FMFGGLU1 table consists of various fields, each holding specific information or linking keys about All fields of US-Federal ledgers 95, 96 and 97 data available in SAP. These include AWID (Reference document: Current identification), AWORG (Reference Organizational Units), AWTYP (Reference Transaction), BDGT_FUNC_CLSS (Classification of Data According to Major Purpose).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FMFGGLU1 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ACTIV | Business Transaction | GLVOR | CHAR | 4 | CHAR4 | ||||
AWID | Reference document: Current identification | AWID | CHAR | 10 | AWID | ||||
AWORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
BDGT_FUNC_CLSS | Classification of Data According to Major Purpose | FM_BDGT_FUNC_CLSS | CHAR | 3 | CHAR3 | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BLSTATUS_9 | Budgetary ledger status | FMFG_BLSTATUS | CHAR | 5 | FMFG_BLSTATUS | FMFG_BLSTATUS | |||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BUREAU | Federal Bureau | FM_BUREAU | CHAR | 2 | FM_BUREAU | ||||
BUSA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
BUSINESS_LINE | Business Line | FM_BUSINESS_LINE | CHAR | 2 | FM_BUSINESS_LINE | ||||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
COHORT | Reporting Year for Cohort | FM_COHORT | CHAR | 4 | FM_COHORT | ||||
CO_AREA | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
DEFENSE_INDIC_9 | Defense Indicator | FMFG_DEFENSE_INDICATOR | CHAR | 3 | FMFG_DEFENSE_INDICATOR | ||||
DOCCT | Document Type | DOCCT | CHAR | 1 | DOCCT | GCT | |||
DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | CHAR | 6 | DOCLN6 | ||||
DOCNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
DOCTY | FI-SL Document Type | DOCTY | CHAR | 2 | Assigned to domain | DOCTY | BAR | ||
DRCRK | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
FAREA | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
FGDPRTMNT | Federal Department | FM_DEPARTMENT | CHAR | 2 | FM_DEPARTMENT | ||||
FGDPRTMNT_PART | Federal Department Partner | FM_DEPARTMENT_PARTNER | CHAR | 2 | FM_DEPARTMENT | ||||
FLG_ADVANCE_9 | Advanced Flag | FM_FLG_ADVANCE | CHAR | 1 | FMFG_FLG_ADVANCE | ||||
FLG_APPORT | Apportionment Category | FM_FLG_APPORT | CHAR | 1 | FM_FLG_APPORT | ||||
FLG_AUTHOR | Authority Type | FM_FLG_AUTHOR | CHAR | 1 | FM_FLG_AUTHOR | ||||
FLG_AVAIL | Availability Time | FM_FLG_AVAIL | CHAR | 1 | FM_FLG_AVAIL | ||||
FLG_BEA | Budget Enforcement Act Category | FM_FLG_BEA | CHAR | 1 | FM_FLG_BEA | ||||
FLG_BORROW | Borrowing Source | FM_FLG_BORROW | CHAR | 1 | FM_FLG_BORROW | ||||
FLG_COVERED | Covered Indicator | FM_FLG_COVERED | CHAR | 1 | FM_FLG_COVERED | ||||
FLG_CUSTODIAL | Custodial Indicator | FM_FLG_CUSTODIAL | CHAR | 1 | FM_FLG_CUSTODIAL | ||||
FLG_DEFINITE | Definite/Indef indicator | FM_FLG_DEFINITE | CHAR | 1 | FM_FLG_DEFINITE | ||||
FLG_ENTITY | Entity Indicator | FM_FLG_ENTITY | CHAR | 1 | FM_FLG_ENTITY | ||||
FLG_EXCHANGE | Exchange Indicator | FM_FLG_EXCHANGE | CHAR | 1 | FM_FLG_EXCHANGE | ||||
FLG_FEDERAL | Federal/Nonfederal Code | FM_FLG_FEDERAL | CHAR | 1 | FM_FLG_FEDERAL | ||||
FLG_PARTNER | Transaction Partner | FM_FLG_PARTNER | CHAR | 1 | FM_FLG_PARTNER | ||||
FLG_REIMBUR | Reimbursable | FM_FLG_REIMBUR | CHAR | 1 | FM_FLG_REIMBUR | ||||
FMCMMTSTR_9 | FM Commitment String For Budgetary Ledger | FMCMMTSTR | CHAR | 62 | FMCMMTSTR | ||||
FMFG_SUBKEY96_9 | Subkey for FMUSFGFACTS1T | FMFG_SUBKEY96 | CHAR | 10 | CHAR10 | ||||
FMFG_SUBKEY97_9 | Subkey for FMUSFGFACTS2T | FMFG_SUBKEY97 | CHAR | 10 | CHAR10 | ||||
FMFG_SUBKEY_9 | Subkey for FMUSFGT | FMFG_SUBKEY | CHAR | 10 | CHAR10 | ||||
FM_AREA | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
FUND_ACC_SYMBL | Treasury Account Symbol - Main Account | FM_MAIN_ACCT | CHAR | 4 | FM_MAIN_ACCT | ||||
FUND_TYPE | FM Fund Type | FM_FUNDTYPE | CHAR | 6 | Assigned to domain | FM_FUNDTYPE | |||
GL_SIRID | Record number of the line item record | GU_RECID | CHAR | 18 | OBJNR | OBN | |||
HSL | Value in local currency | VLCUR9 | CURR | 17(2) | WERTV9 | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
LEGIS | Type of Legislation | FM_LEGIS | CHAR | 1 | FM_LEGIS | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
LINETYPE | Item category | LINETYPE | CHAR | 5 | Assigned to domain | LINETYPE | |||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
PMT_OFFICE | Payment Office | FMFG_PMT_OFF | CHAR | 5 | Assigned to domain | FMFG_PMT_OFF | FMFG_PMT_OFFICE | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PUBLAW | Public Law Cited | FM_PUBLAW | CHAR | 20 | FM_PUBLAW | ||||
RACCT | Account Number | RACCT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ACC | |
RAGNCY_LCTN_CODE | Agency Location Code | FMFG_ALC | CHAR | 8 | Assigned to domain | FMFG_ALC | FMFG_ALC | ||
RBDGT_FUNC_CLSS | Classification of Data According to Major Purpose | FM_BDGT_FUNC_CLSS | CHAR | 3 | CHAR3 | ||||
RBUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RBUSA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
RCLNT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
RCNTR | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
RCOHORT | Reporting Year for Cohort | FM_COHORT | CHAR | 4 | FM_COHORT | ||||
REFACTIV | FI-SL Business Reference Transaction | REFGLVOR | CHAR | 4 | CHAR4 | ||||
REFDOCCT | Reference document category | REFDOCCT | CHAR | 1 | DOCCT | GCT | |||
REFDOCLN | Six-digit number of the reference posting line | REFBUZEI6 | NUMC | 6 | BUZEI6 | BUZ | |||
REFDOCNR | Reference document number of an accounting document | REFBELNR | CHAR | 10 | ALPHA | BELNR | BLN | ||
REFRYEAR | Reference fiscal year | REFGJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
RFAREA | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
RFINUSE | Application of Secondary Source Funds | FM_FINUSE | CHAR | 16 | Assigned to domain | FM_FINUSE | FIU | ||
RFIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
RFISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
RFLG_APPORT | Apportionment Category | FM_FLG_APPORT | CHAR | 1 | FM_FLG_APPORT | ||||
RFLG_AUTHOR | Authority Type | FM_FLG_AUTHOR | CHAR | 1 | FM_FLG_AUTHOR | ||||
RFLG_AVAIL | Availability Time | FM_FLG_AVAIL | CHAR | 1 | FM_FLG_AVAIL | ||||
RFLG_BEA | Budget Enforcement Act Category | FM_FLG_BEA | CHAR | 1 | FM_FLG_BEA | ||||
RFLG_BORROW | Borrowing Source | FM_FLG_BORROW | CHAR | 1 | FM_FLG_BORROW | ||||
RFLG_COVERED | Covered Indicator | FM_FLG_COVERED | CHAR | 1 | FM_FLG_COVERED | ||||
RFLG_CUSTODIAL | Custodial Indicator | FM_FLG_CUSTODIAL | CHAR | 1 | FM_FLG_CUSTODIAL | ||||
RFLG_DEFINITE | Definite/Indef indicator | FM_FLG_DEFINITE | CHAR | 1 | FM_FLG_DEFINITE | ||||
RFLG_ENTITY | Entity Indicator | FM_FLG_ENTITY | CHAR | 1 | FM_FLG_ENTITY | ||||
RFLG_EXCHANGE | Exchange Indicator | FM_FLG_EXCHANGE | CHAR | 1 | FM_FLG_EXCHANGE | ||||
RFLG_PARTNER | Transaction Partner | FM_FLG_PARTNER | CHAR | 1 | FM_FLG_PARTNER | ||||
RFLG_REIMBUR | Reimbursable | FM_FLG_REIMBUR | CHAR | 1 | FM_FLG_REIMBUR | ||||
RFUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
RLDNR | Ledger | RLDNR | CHAR | 2 | Assigned to domain | ALPHA | RLDNR | GLN | H_T881 |
RLEGIS | Type of Legislation | FM_LEGIS | CHAR | 1 | FM_LEGIS | ||||
RORDNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
RPRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
RPROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
RPUBLAW | Public Law Cited | FM_PUBLAW | CHAR | 20 | FM_PUBLAW | ||||
RRCTY | Record Type | RRCTY | CHAR | 1 | RRCTY | ||||
RTCUR | Currency Key | RTCUR | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
RVBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
RVERS | Version | RVERS | CHAR | 3 | Assigned to domain | ALPHA | RVERS | GVS | |
RWCUR | Currency key of the original transaction currency | RWCUR | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
RYEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
SBUKRS | Company code of partner | PBUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | FM_SGL_ACCOUNT | CHAR | 6 | FM_SGL_ACCOUNT | SGL_ACCOUNT | FMFG_SGL_ACCOUNT | ||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
TRANSFER_ACCT_9 | Transfer Account | FMFG_TRANSFER_ACCT | CHAR | 4 | Assigned to domain | FMFG_TRAN_ACCT | |||
TRANSFER_AGCY_9 | Transfer Agency | FMFG_TRANSFER_AGCY | CHAR | 2 | Assigned to domain | FMFG_TRANSFER | |||
TSL | Value in Transaction Currency | VTCUR9 | CURR | 17(2) | WERTV9 | ||||
USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
WSDAT | Value Date for Currency Translation | WSDAT | DATS | 8 | DATUM | WSD | |||
WSL | Value in Original Transaction Currency (Document Currency) | VWCUR12 | CURR | 23(2) | WERTV12 | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
XSKRL | Indicator: Line item not liable to cash discount? | XSKRL | CHAR | 1 | XFELD | ||||
XSPLITMOD | Item changed by document splitting | XSPLITMOD | CHAR | 1 | XFELD | ||||
YEAR_BDGT_AUTH_9 | Year of Budget Authority | FMFG_YR_BUD_AUTH | CHAR | 4 | FMFG_YR_BUD_AUTH | ||||
PROG_REPT_CAT_9 | Program Reporting Category | FMFG_PROGRAM_REPORT_CATEGORY | CHAR | 3 | FMFG_PROGRAM_REPORT_CATEGORY | ||||
BUDGET_PD_9 | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
APPOR_CATB_DTL_9 | Apportionment Category B Program Code | FMFG_APPORTDTL | CHAR | 4 | |||||
BDGT_IMPACT_9 | Budgetary Impact | FMFG_BDGT_IMPACT | CHAR | 1 | FMFG_BDGT_IMPACT | ||||
FLG_PYA_9 | Prior Year Adjustment Code | FMFG_FLG_PYA | CHAR | 1 | FMFG_FLG_PYA | ||||
PROGRAM_IND_9 | Program | FMFG_PROGRAM_IND | CHAR | 1 | FMFG_PROGRAM_IND | ||||
TP_SUBLEVL_9 | Sublevel Prefix (SP) for Trading Partner | FMFG_TP_SUBLEVL | CHAR | 2 | FMFG_SUBLEVL | ||||
TP_AGENCID_9 | Agency Identifier (AID) for Trading Partner | FMFG_TP_AGENCID | CHAR | 3 | FMFG_AGENCID | ||||
TP_ALTRAID_9 | Allocation Transfer Agency Identifier (ATA) Trading Partner | FMFG_TP_ALTRAID | CHAR | 3 | FMFG_ALTRAID | ||||
TP_BEGPER_9 | Beginning Period of Availability (BPOA) for Trading Partner | FMFG_TP_BEGPER | NUMC | 4 | GJAHR | FMFG_BEGPER | |||
TP_ENDPER_9 | Ending Period of Availability (EPOA) for Trading Partner | FMFG_TP_ENDPER | NUMC | 4 | GJAHR | FMFG_ENDPER | |||
TP_AVTYPE_9 | Availability Type Code (A) for Trading Partner | FMFG_TP_AVTYPE | CHAR | 1 | FMFG_AVTYPE | ||||
TP_MAIN_ACCT_9 | Main Account for Trading Partner | FMFG_TP_MAIN_ACCT | CHAR | 4 | |||||
TP_SUB_ACCT_9 | Subaccount for Trading Partner | FMFG_TP_SUB_ACCT | CHAR | 3 | |||||
BETC_9 | Business Event Type Code | FMFG_BETC | CHAR | 10 | CHAR10 | ||||
TP_BETC_9 | Business Event Type Code for Trading Partner | FMFG_TP_BETC | CHAR | 10 | |||||
TREASURY_OFFS_9 | Treasury Offset Program Eligibility | FMFG_TREASURY_OFFSET | CHAR | 1 | |||||
GARNISHMENT_9 | Garnishment | FMFG_GARNISHMENT | CHAR | 1 | |||||
SUBLEVL_9 | Sublevel Prefix (SP) | FMFG_SUBLEVL | CHAR | 2 | FMFG_SUBLEVL | ||||
AGENCID_9 | Agency Identifier (AID) | FMFG_AGENCID | CHAR | 3 | FMFG_AGENCID | ||||
ALTRAID_9 | Allocation Transfer Agency Identifier (ATA) | FMFG_ALTRAID | CHAR | 3 | FMFG_ALTRAID | ||||
BEGPER_9 | Beginning Period of Availability (BPOA) | FMFG_BEGPER | NUMC | 4 | GJAHR | FMFG_BEGPER | |||
ENDPER_9 | Ending Period of Availability (EPOA) | FMFG_ENDPER | NUMC | 4 | GJAHR | FMFG_ENDPER | |||
AVTYPE_9 | Availability Type Code (A) | FMFG_AVTYPE | CHAR | 1 | FMFG_AVTYPE | ||||
SUB_ACCT_9 | Treasury Account Symbol - Subaccount | FM_SUB_ACCT | CHAR | 3 | FM_SUB_ACCT |
Key field | Non-key field |
How do I retrieve data from SAP structure FMFGGLU1 using ABAP code?
As FMFGGLU1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMFGGLU1 as there is no data to select.How to access SAP table FMFGGLU1
Within an ECC or HANA version of SAP you can also view further information about FMFGGLU1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects