FMUSFGA SAP (Actual line item table for US Federal Government.) Table details

Dictionary Type: Table
Description: Actual line item table for US Federal Government.




ABAP Code to SELECT data from FMUSFGA
Related tables to FMUSFGA
Access table FMUSFGA




Table field list including key, data, relationships and ABAP select examples

FMUSFGA is a standard SAP Table which is used to store Actual line item table for US Federal Government. data and is available within R/3 SAP systems depending on the version and release level.

The FMUSFGA table consists of various fields, each holding specific information or linking keys about Actual line item table for US Federal Government. data available in SAP. These include GL_SIRID (Record number of the line item record), RLDNR (Ledger), RRCTY (Record Type), RVERS (Version).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FMUSFGA table 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
RCLNTClient MANDTCLNT3T000MANDT
GL_SIRIDRecord number of the line item record GU_RECIDCHAR18OBJNROBN
RLDNRLedger RLDNRCHAR2T881ALPHARLDNRGLNH_T881
RRCTYRecord Type RRCTYCHAR1RRCTY
RVERSVersion RVERSCHAR3T894ALPHARVERSGVS
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
RTCURCurrency Key RTCURCUKY5TCURCWAERSFWS
DRCRKDebit/Credit Indicator SHKZGCHAR1SHKZG
POPERPosting period POPERNUMC3POPERPOPR
DOCCTDocument Type DOCCTCHAR1DOCCTGCT
DOCNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
DOCLNSix-Character Posting Item for Ledger DOCLN6CHAR6DOCLN6
RBUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RACCTAccount Number RACCTCHAR10Assigned to domainALPHASAKNRACC
RBUSABusiness Area GSBERCHAR4TGSBGSBERGSB
RPRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
RCNTRCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
RPROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
RFAREAFunctional Area FKBERCHAR16TFKBFKBERFBE
RFUNDFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
RFIPEXCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
RFISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
RORDNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
RVBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
RAGNCY_LCTN_CODEAgency Location Code FMFG_ALCCHAR8Assigned to domainFMFG_ALCFMFG_ALC
RFINUSEApplication of Secondary Source Funds FM_FINUSECHAR16Assigned to domainFM_FINUSEFIU
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
FMFG_SUBKEY_9Subkey for FMUSFGT FMFG_SUBKEYCHAR10CHAR10
BLSTATUS_9Budgetary ledger status FMFG_BLSTATUSCHAR5FMFG_BLSTATUSFMFG_BLSTATUS
TSLValue in Transaction Currency VTCUR9CURR17(2) WERTV9
HSLValue in local currency VLCUR9CURR17(2) WERTV9
SGTXTItem Text SGTXTCHAR50TEXT50
DOCTYFI-SL Document Type DOCTYCHAR2T889DOCTYBAR
ACTIVBusiness Transaction GLVORCHAR4CHAR4
BUDATPosting Date in the Document BUDATDATS8DATUM
WSDATValue Date for Currency Translation WSDATDATS8DATUMWSD
BLDATDocument Date in Document BLDATDATS8DATUM
REFDOCNRReference document number of an accounting document REFBELNRCHAR10ALPHABELNRBLN
REFRYEARReference fiscal year REFGJAHRNUMC4GJAHRGJAHRGJR
REFDOCLNSix-digit number of the reference posting line REFBUZEI6NUMC6BUZEI6BUZ
REFDOCCTReference document category REFDOCCTCHAR1DOCCTGCT
REFACTIVFI-SL Business Reference Transaction REFGLVORCHAR4CHAR4
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
AWTYPReference Transaction AWTYPCHAR5TTYPAWTYP
AWORGReference Organizational Units AWORGCHAR10AWORG
PMT_OFFICEPayment Office FMFG_PMT_OFFCHAR5Assigned to domainFMFG_PMT_OFFFMFG_PMT_OFFICE
COHORTReporting Year for Cohort FM_COHORTCHAR4FM_COHORT
PUBLAWPublic Law Cited FM_PUBLAWCHAR20FM_PUBLAW
LEGISType of Legislation FM_LEGISCHAR1FM_LEGIS
FLG_COVEREDCovered Indicator FM_FLG_COVEREDCHAR1FM_FLG_COVERED
FLG_CUSTODIALCustodial Indicator FM_FLG_CUSTODIALCHAR1FM_FLG_CUSTODIAL
FLG_ENTITYEntity Indicator FM_FLG_ENTITYCHAR1FM_FLG_ENTITY
FLG_EXCHANGEExchange Indicator FM_FLG_EXCHANGECHAR1FM_FLG_EXCHANGE
FLG_FEDERALFederal/Nonfederal Code FM_FLG_FEDERALCHAR1FM_FLG_FEDERAL
FLG_APPORTApportionment Category FM_FLG_APPORTCHAR1FM_FLG_APPORT
FLG_AVAILAvailability Time FM_FLG_AVAILCHAR1FM_FLG_AVAIL
FLG_BORROWBorrowing Source FM_FLG_BORROWCHAR1FM_FLG_BORROW
FLG_DEFINITEDefinite/Indef indicator FM_FLG_DEFINITECHAR1FM_FLG_DEFINITE
FLG_PARTNERTransaction Partner FM_FLG_PARTNERCHAR1FM_FLG_PARTNER
FLG_REIMBURReimbursable FM_FLG_REIMBURCHAR1FM_FLG_REIMBUR
FLG_AUTHORAuthority Type FM_FLG_AUTHORCHAR1FM_FLG_AUTHOR
FLG_BEABudget Enforcement Act Category FM_FLG_BEACHAR1FM_FLG_BEA
BUREAUFederal Bureau FM_BUREAUCHAR2FM_BUREAU
BUSINESS_LINEBusiness Line FM_BUSINESS_LINECHAR2FM_BUSINESS_LINE
FGDPRTMNTFederal Department FM_DEPARTMENTCHAR2FM_DEPARTMENT
FGDPRTMNT_PARTFederal Department Partner FM_DEPARTMENT_PARTNERCHAR2FM_DEPARTMENT
FUND_ACC_SYMBLTreasury Account Symbol - Main Account FM_MAIN_ACCTCHAR4FM_MAIN_ACCT
WSLValue in Original Transaction Currency (Document Currency) VWCUR12CURR23(2) WERTV12
RWCURCurrency key of the original transaction currency RWCURCUKY5Assigned to domainWAERSFWS
AWIDReference document: Current identification AWIDCHAR10AWID
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
LINETYPEItem category LINETYPECHAR5Assigned to domainLINETYPE
XSPLITMODItem changed by document splitting XSPLITMODCHAR1XFELD
FUND_TYPEFM Fund Type FM_FUNDTYPECHAR6Assigned to domainFM_FUNDTYPE
FM_AREAFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
XSKRLIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
CO_AREAControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
SGL_ACCOUNTStandard General Ledger Account for US Federal Government FM_SGL_ACCOUNTCHAR6FM_SGL_ACCOUNTSGL_ACCOUNTFMFG_SGL_ACCOUNT
BDGT_FUNC_CLSSClassification of Data According to Major Purpose FM_BDGT_FUNC_CLSSCHAR3CHAR3
FMCMMTSTR_9FM Commitment String For Budgetary Ledger FMCMMTSTRCHAR62FMCMMTSTR
TRANSFER_AGCY_9Transfer Agency FMFG_TRANSFER_AGCYCHAR2Assigned to domainFMFG_TRANSFER
TRANSFER_ACCT_9Transfer Account FMFG_TRANSFER_ACCTCHAR4Assigned to domainFMFG_TRAN_ACCT
YEAR_BDGT_AUTH_9Year of Budget Authority FMFG_YR_BUD_AUTHCHAR4FMFG_YR_BUD_AUTH
FLG_ADVANCE_9Advanced Flag FM_FLG_ADVANCECHAR1FMFG_FLG_ADVANCE
DEFENSE_INDIC_9Defense Indicator FMFG_DEFENSE_INDICATORCHAR3FMFG_DEFENSE_INDICATOR
MEASUREFunded Program FM_MEASURECHAR24FMMEASUREFM_MEASUREFM_MEASURE
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
PROG_REPT_CAT_9Program Reporting Category FMFG_PROGRAM_REPORT_CATEGORYCHAR3FMFG_PROGRAM_REPORT_CATEGORY
BUDGET_PD_9FM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
ASSETMAINO_9Main Asset Number BF_ANLN1CHAR12ALPHABF_ANLN1AN1
ASSETSUBNO_9Asset Subnumber BF_ANLN2CHAR4ALPHABF_ANLN2AN2
MOVEMENTTYPE_9Asset Transaction Type ANBWACHAR3Assigned to domainBWASL
ASSET_ACQDATE_9Asset value date BZDATDATS8DATUM
NPLNR_9Network Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
APLZL_9Internal counter CIM_COUNTNUMC8CIM_COUNT
AUFPL_9Routing number of operations in the order CO_AUFPLNUMC10AUFPL
PRZNR_9Business Process CO_PRZNRCHAR12Assigned to domainALPHACO_PRZNRKWP
IMKEY_9Internal Key for Real Estate Object IMKEYCHAR8IMKEY
INTRENO_9Internal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
APPOR_CATB_DTL_9Apportionment Category B Program Code FMFG_APPORTDTLCHAR4
BDGT_IMPACT_9Budgetary Impact FMFG_BDGT_IMPACTCHAR1FMFG_BDGT_IMPACT
FLG_PYA_9Prior Year Adjustment Code FMFG_FLG_PYACHAR1FMFG_FLG_PYA
PROGRAM_IND_9Program FMFG_PROGRAM_INDCHAR1FMFG_PROGRAM_IND
TP_SUBLEVL_9Sublevel Prefix (SP) for Trading Partner FMFG_TP_SUBLEVLCHAR2FMFG_SUBLEVL
TP_AGENCID_9Agency Identifier (AID) for Trading Partner FMFG_TP_AGENCIDCHAR3FMFG_AGENCID
TP_ALTRAID_9Allocation Transfer Agency Identifier (ATA) Trading Partner FMFG_TP_ALTRAIDCHAR3FMFG_ALTRAID
TP_BEGPER_9Beginning Period of Availability (BPOA) for Trading Partner FMFG_TP_BEGPERNUMC4GJAHRFMFG_BEGPER
TP_ENDPER_9Ending Period of Availability (EPOA) for Trading Partner FMFG_TP_ENDPERNUMC4GJAHRFMFG_ENDPER
TP_AVTYPE_9Availability Type Code (A) for Trading Partner FMFG_TP_AVTYPECHAR1FMFG_AVTYPE
TP_MAIN_ACCT_9Main Account for Trading Partner FMFG_TP_MAIN_ACCTCHAR4
TP_SUB_ACCT_9Subaccount for Trading Partner FMFG_TP_SUB_ACCTCHAR3
BETC_9Business Event Type Code FMFG_BETCCHAR10CHAR10
TP_BETC_9Business Event Type Code for Trading Partner FMFG_TP_BETCCHAR10
TREASURY_OFFS_9Treasury Offset Program Eligibility FMFG_TREASURY_OFFSETCHAR1
GARNISHMENT_9Garnishment FMFG_GARNISHMENTCHAR1
SUBLEVL_9Sublevel Prefix (SP) FMFG_SUBLEVLCHAR2FMFG_SUBLEVL
AGENCID_9Agency Identifier (AID) FMFG_AGENCIDCHAR3FMFG_AGENCID
ALTRAID_9Allocation Transfer Agency Identifier (ATA) FMFG_ALTRAIDCHAR3FMFG_ALTRAID
BEGPER_9Beginning Period of Availability (BPOA) FMFG_BEGPERNUMC4GJAHRFMFG_BEGPER
ENDPER_9Ending Period of Availability (EPOA) FMFG_ENDPERNUMC4GJAHRFMFG_ENDPER
AVTYPE_9Availability Type Code (A) FMFG_AVTYPECHAR1FMFG_AVTYPE
SUB_ACCT_9Treasury Account Symbol - Subaccount FM_SUB_ACCTCHAR3FM_SUB_ACCT

Key field Non-key field



How do I retrieve data from SAP table FMUSFGA using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMUSFGA to SELECT all data from the table
DATA: WA_FMUSFGA TYPE FMUSFGA.

SELECT SINGLE *
FROM FMUSFGA
INTO CORRESPONDING FIELDS OF WA_FMUSFGA
WHERE...

How to access SAP table FMUSFGA

Within an ECC or HANA version of SAP you can also view further information about FMUSFGA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!