Menu

SAP Table FMUSFGA

Actual line item table for US Federal Government

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table FMUSFGA (Actual line item table for US Federal Government) is a standard table in SAP ERP. It belongs to the package FMFG_E.

Technical Information

Table FMUSFGA
Short Text Actual line item table for US Federal Government
Package FMFG_E
Table Type Transparent Table

Fields for Table FMUSFGA

Field Name Key Description Data Element Type Length Check Table
RCLNT Client MANDT CLNT 3 T000
GL_SIRID Record number of the line item record GU_RECID CHAR 18
RLDNR Ledger RLDNR CHAR 2 T881
RRCTY Record Type RRCTY CHAR 1
RVERS Version RVERS CHAR 3 T894
RYEAR Fiscal Year GJAHR NUMC 4
RTCUR Currency Key RTCUR CUKY 5 TCURC
DRCRK Debit/Credit Indicator SHKZG CHAR 1
POPER Posting period POPER NUMC 3
DOCCT Document Type DOCCT CHAR 1
DOCNR Accounting Document Number BELNR_D CHAR 10
DOCLN Six-Character Posting Item for Ledger DOCLN6 CHAR 6
RBUKRS Company Code BUKRS CHAR 4 T001
RACCT Account Number RACCT CHAR 10 *
RBUSA Business Area GSBER CHAR 4 TGSB
RPRCTR Profit Center PRCTR CHAR 10 *
RCNTR Cost Center KOSTL CHAR 10 *
RPROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 PRPS
RFAREA Functional Area FKBER CHAR 16 TFKB
RFUND Fund BP_GEBER CHAR 10 *
RFIPEX Commitment Item FM_FIPEX CHAR 24 *
RFISTL Funds Center FISTL CHAR 16 *
RORDNR Order Number AUFNR CHAR 12 *
RVBUND Company ID of trading partner RASSC CHAR 6 *
RAGNCY_LCTN_CODE Agency Location Code FMFG_ALC CHAR 8 *
RFINUSE Application of Secondary Source Funds FM_FINUSE CHAR 16 *
LOGSYS Logical system LOGSYS CHAR 10 TBDLS
FMFG_SUBKEY_9 Subkey for FMUSFGT FMFG_SUBKEY CHAR 10
BLSTATUS_9 Budgetary ledger status FMFG_BLSTATUS CHAR 5
TSL Value in Transaction Currency VTCUR9 CURR 17
HSL Value in local currency VLCUR9 CURR 17
SGTXT Item Text SGTXT CHAR 50
DOCTY FI-SL Document Type DOCTY CHAR 2 T889
ACTIV Business Transaction GLVOR CHAR 4
BUDAT Posting Date in the Document BUDAT DATS 8
WSDAT Value Date for Currency Translation WSDAT DATS 8
BLDAT Document Date in Document BLDAT DATS 8
REFDOCNR Reference document number of an accounting document REFBELNR CHAR 10
REFRYEAR Reference fiscal year REFGJAHR NUMC 4
REFDOCLN Six-digit number of the reference posting line REFBUZEI6 NUMC 6
REFDOCCT Reference document category REFDOCCT CHAR 1
REFACTIV FI-SL Business Reference Transaction REFGLVOR CHAR 4
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8
CPUTM Time of Entry CPUTM TIMS 6
USNAM User name USNAM CHAR 12 *
AWTYP Reference Transaction AWTYP CHAR 5 TTYP
AWORG Reference Organizational Units AWORG CHAR 10
PMT_OFFICE Payment Office FMFG_PMT_OFF CHAR 5 *
COHORT Reporting Year for Cohort FM_COHORT CHAR 4
PUBLAW Public Law Cited FM_PUBLAW CHAR 20
LEGIS Type of Legislation FM_LEGIS CHAR 1
FLG_COVERED Covered Indicator FM_FLG_COVERED CHAR 1
FLG_CUSTODIAL Custodial Indicator FM_FLG_CUSTODIAL CHAR 1
FLG_ENTITY Entity Indicator FM_FLG_ENTITY CHAR 1
FLG_EXCHANGE Exchange Indicator FM_FLG_EXCHANGE CHAR 1
FLG_FEDERAL Federal/Nonfederal Code FM_FLG_FEDERAL CHAR 1
FLG_APPORT Apportionment Category FM_FLG_APPORT CHAR 1
FLG_AVAIL Availability Time FM_FLG_AVAIL CHAR 1
FLG_BORROW Borrowing Source FM_FLG_BORROW CHAR 1
FLG_DEFINITE Definite/Indef indicator FM_FLG_DEFINITE CHAR 1
FLG_PARTNER Transaction Partner FM_FLG_PARTNER CHAR 1
FLG_REIMBUR Reimbursable FM_FLG_REIMBUR CHAR 1
FLG_AUTHOR Authority Type FM_FLG_AUTHOR CHAR 1
FLG_BEA Budget Enforcement Act Category FM_FLG_BEA CHAR 1
BUREAU Federal Bureau FM_BUREAU CHAR 2
BUSINESS_LINE Business Line FM_BUSINESS_LINE CHAR 2
FGDPRTMNT Federal Department FM_DEPARTMENT CHAR 2
FGDPRTMNT_PART Federal Department Partner FM_DEPARTMENT_PARTNER CHAR 2
FUND_ACC_SYMBL Treasury Account Symbol - Main Account FM_MAIN_ACCT CHAR 4
WSL Value in Original Transaction Currency (Document Currency) VWCUR12 CURR 23
RWCUR Currency key of the original transaction currency RWCUR CUKY 5 *
AWID Reference document: Current identification AWID CHAR 10
BELNR Accounting Document Number BELNR_D CHAR 10
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3
LINETYPE Item category LINETYPE CHAR 5 *
XSPLITMOD Item changed by document splitting XSPLITMOD CHAR 1
FUND_TYPE FM Fund Type FM_FUNDTYPE CHAR 6 *
FM_AREA Financial Management Area FIKRS CHAR 4 *
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 *
XSKRL Indicator: Line item not liable to cash discount? XSKRL CHAR 1
CO_AREA Controlling Area KOKRS CHAR 4 *
SGL_ACCOUNT Standard General Ledger Account for US Federal Government FM_SGL_ACCOUNT CHAR 6
BDGT_FUNC_CLSS Classification of Data According to Major Purpose FM_BDGT_FUNC_CLSS CHAR 3
FMCMMTSTR_9 FM Commitment String For Budgetary Ledger FMCMMTSTR CHAR 62
TRANSFER_AGCY_9 Transfer Agency FMFG_TRANSFER_AGCY CHAR 2 *
TRANSFER_ACCT_9 Transfer Account FMFG_TRANSFER_ACCT CHAR 4 *
YEAR_BDGT_AUTH_9 Year of Budget Authority FMFG_YR_BUD_AUTH CHAR 4
FLG_ADVANCE_9 Advanced Flag FM_FLG_ADVANCE CHAR 1
DEFENSE_INDIC_9 Defense Indicator FMFG_DEFENSE_INDICATOR CHAR 3
MEASURE Funded Program FM_MEASURE CHAR 24 FMMEASURE
XBLNR Reference Document Number XBLNR1 CHAR 16
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 *
PROG_REPT_CAT_9 Program Reporting Category FMFG_PROGRAM_REPORT_CATEGORY CHAR 3
BUDGET_PD_9 FM: Budget Period FM_BUDGET_PERIOD CHAR 10 *
ASSETMAINO_9 Main Asset Number BF_ANLN1 CHAR 12
ASSETSUBNO_9 Asset Subnumber BF_ANLN2 CHAR 4
MOVEMENTTYPE_9 Asset Transaction Type ANBWA CHAR 3 *
ASSET_ACQDATE_9 Asset value date BZDAT DATS 8
NPLNR_9 Network Number for Account Assignment NPLNR CHAR 12 *
APLZL_9 Internal counter CIM_COUNT NUMC 8
AUFPL_9 Routing number of operations in the order CO_AUFPL NUMC 10
PRZNR_9 Business Process CO_PRZNR CHAR 12 *
IMKEY_9 Internal Key for Real Estate Object IMKEY CHAR 8
INTRENO_9 Internal Real Estate Master Data Code VVINTRENO CHAR 13
APPOR_CATB_DTL_9 Apportionment Category B Program Code FMFG_APPORTDTL CHAR 4
BDGT_IMPACT_9 Budgetary Impact FMFG_BDGT_IMPACT CHAR 1
FLG_PYA_9 Prior Year Adjustment Code FMFG_FLG_PYA CHAR 1
PROGRAM_IND_9 Program FMFG_PROGRAM_IND CHAR 1
TP_SUBLEVL_9 Sublevel Prefix (SP) for Trading Partner FMFG_TP_SUBLEVL CHAR 2
TP_AGENCID_9 Agency Identifier (AID) for Trading Partner FMFG_TP_AGENCID CHAR 3
TP_ALTRAID_9 Allocation Transfer Agency Identifier (ATA) Trading Partner FMFG_TP_ALTRAID CHAR 3
TP_BEGPER_9 Beginning Period of Availability (BPOA) for Trading Partner FMFG_TP_BEGPER NUMC 4
TP_ENDPER_9 Ending Period of Availability (EPOA) for Trading Partner FMFG_TP_ENDPER NUMC 4
TP_AVTYPE_9 Availability Type Code (A) for Trading Partner FMFG_TP_AVTYPE CHAR 1
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
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
AGENCID_9 Agency Identifier (AID) FMFG_AGENCID CHAR 3
ALTRAID_9 Allocation Transfer Agency Identifier (ATA) FMFG_ALTRAID CHAR 3
BEGPER_9 Beginning Period of Availability (BPOA) FMFG_BEGPER NUMC 4
ENDPER_9 Ending Period of Availability (EPOA) FMFG_ENDPER NUMC 4
AVTYPE_9 Availability Type Code (A) FMFG_AVTYPE CHAR 1
SUB_ACCT_9 Treasury Account Symbol - Subaccount FM_SUB_ACCT CHAR 3