1. SAP Tutorial
  2. SAP PSM

FMUSFGA SAP table for – Actual line item table for US Federal Government

Here we would like to draw your attention to FMUSFGA table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMUSFGA is a SAP standard transp table used for storing Actual line item table for US Federal Government related data in SAP. It comes under the package FMFG_E.

SAP FMUSFGA table

Table FMUSFGA technical data

TableFMUSFGA
Data storingActual line item table for US Federal Government
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFG_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMUSFGA Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMUSFGA table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GL_SIRID : Record number of the line item record
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RLDNR : Ledger
    Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RTCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DRCRK : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • POPER : Posting period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • DOCNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • DOCLN : Six-Character Posting Item for Ledger
    Its data type is CHAR (Character String) with field length 6
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • RBUSA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • RPRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • RCNTR : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • RPROJK : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • RFAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • RFUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • RFIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • RFISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • RORDNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • RVBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • RAGNCY_LCTN_CODE : Agency Location Code
    Its data type is CHAR (Character String) with field length 8
  • RFINUSE : Application of Secondary Source Funds
    Its data type is CHAR (Character String) with field length 16
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • FMFG_SUBKEY_9 : Subkey for FMUSFGT
    Its data type is CHAR (Character String) with field length 10
  • BLSTATUS_9 : Budgetary ledger status
    Its data type is CHAR (Character String) with field length 5
  • TSL : Value in Transaction Currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL : Value in local currency
    Its data type is CURR (Currency Field) with field length 17
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • DOCTY : FI-SL Document Type
    Its data type is CHAR (Character String) with field length 2
  • ACTIV : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WSDAT : Value Date for Currency Translation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REFDOCNR : Reference document number of an accounting document
    Its data type is CHAR (Character String) with field length 10
  • REFRYEAR : Reference fiscal year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFDOCLN : Six-digit number of the reference posting line
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REFDOCCT : Reference document category
    Its data type is CHAR (Character String) with field length 1
  • REFACTIV : FI-SL Business Reference Transaction
    Its data type is CHAR (Character String) with field length 4
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10
  • PMT_OFFICE : Payment Office
    Its data type is CHAR (Character String) with field length 5
  • COHORT : Reporting Year for Cohort
    Its data type is CHAR (Character String) with field length 4
  • PUBLAW : Public Law Cited
    Its data type is CHAR (Character String) with field length 20
  • LEGIS : Type of Legislation
    Its data type is CHAR (Character String) with field length 1
  • FLG_COVERED : Covered Indicator
    Its data type is CHAR (Character String) with field length 1
  • FLG_CUSTODIAL : Custodial Indicator
    Its data type is CHAR (Character String) with field length 1
  • FLG_ENTITY : Entity Indicator
    Its data type is CHAR (Character String) with field length 1
  • FLG_EXCHANGE : Exchange Indicator
    Its data type is CHAR (Character String) with field length 1
  • FLG_FEDERAL : Federal Indicator
    Its data type is CHAR (Character String) with field length 1
  • FLG_APPORT : Apportionment Category
    Its data type is CHAR (Character String) with field length 1
  • FLG_AVAIL : Availability Time
    Its data type is CHAR (Character String) with field length 1
  • FLG_BORROW : Borrowing Source
    Its data type is CHAR (Character String) with field length 1
  • FLG_DEFINITE : Definite/Indef indicator
    Its data type is CHAR (Character String) with field length 1
  • FLG_PARTNER : Transaction Partner
    Its data type is CHAR (Character String) with field length 1
  • FLG_REIMBUR : Reimbursable
    Its data type is CHAR (Character String) with field length 1
  • FLG_AUTHOR : Authority Type
    Its data type is CHAR (Character String) with field length 1
  • FLG_BEA : BEA Category
    Its data type is CHAR (Character String) with field length 1
  • BUREAU : Federal Bureau
    Its data type is CHAR (Character String) with field length 2
  • BUSINESS_LINE : Business Line
    Its data type is CHAR (Character String) with field length 2
  • FGDPRTMNT : Federal Department
    Its data type is CHAR (Character String) with field length 2
  • FGDPRTMNT_PART : Federal Department Partner
    Its data type is CHAR (Character String) with field length 2
  • FUND_ACC_SYMBL : Treasury Account Symbol – Main Account
    Its data type is CHAR (Character String) with field length 4
  • WSL : Value in Original Transaction Currency (Document Currency)
    Its data type is CURR (Currency Field) with field length 23
  • RWCUR : Currency key of the original transaction currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • AWID : Reference document: Current identification
    Its data type is CHAR (Character String) with field length 10
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • LINETYPE : Item category
    Its data type is CHAR (Character String) with field length 5
  • XSPLITMOD : Item changed by document splitting
    Its data type is CHAR (Character String) with field length 1
  • FUND_TYPE : FM Fund Type
    Its data type is CHAR (Character String) with field length 6
  • FM_AREA : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • XSKRL : Indicator: Line item not liable to cash discount?
    Its data type is CHAR (Character String) with field length 1
  • CO_AREA : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • SGL_ACCOUNT : SGL Account, US Federal Government
    Its data type is CHAR (Character String) with field length 4
  • BDGT_FUNC_CLSS : Classification of Data According to Major Purpose
    Its data type is CHAR (Character String) with field length 3
  • FMCMMTSTR_9 : FM Commitment String For Budgetary Ledger
    Its data type is CHAR (Character String) with field length 62
  • TRANSFER_AGCY_9 : Transfer Agency
    Its data type is CHAR (Character String) with field length 2
  • TRANSFER_ACCT_9 : Transfer Account
    Its data type is CHAR (Character String) with field length 4
  • YEAR_BDGT_AUTH_9 : Year of Budget Authority
    Its data type is CHAR (Character String) with field length 4
  • FLG_ADVANCE_9 : Advanced Flag
    Its data type is CHAR (Character String) with field length 1
  • DEFENSE_INDIC_9 : Defense Indicator
    Its data type is CHAR (Character String) with field length 3
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • PROG_REPT_CAT_9 : Program Reporting Category Posted
    Its data type is CHAR (Character String) with field length 3

    • FMUSFGA related tables

    • FMUSFGF2_TRANS : Transfer Agency and Accounts
    • FMBUDSTA : Budgetary ledger account derivation: Open items/Actuals bdgt
    • FMFGF2_SGLATRVAL : FMFG2 – FACTS II SGL Account Attribute Allowable Values
    • FMFG_PO_SUBSET : ZEKKN number to correct invoices for SES
    • FMFG_SAV_FACTS1A : Saved FACTS1A data for docs excluded from SL Repost for 600
    • FMTC_SCHNO : Treasury Confirmation Schedule No status
    • FMFGT_PO : Payment Office – U.S. Federal Government
    • FMFGF2EXT : FACTS2 Bulk Extract File
    • FMFGF2VERSION : Facts II Program Version Number
    • FMFGT_ALC : Agency Location Code – U.S. Federal Government
    • FMBPCLOSE_FTYPE : Preclosing Rollup: Transfer Rules for Fund Type
    • FMTC_SCHTOT : Limit Treasury Schedules
    • FMUSFGFACTS1T : Summary table
    • FMUSFGT : Summary table for US Federal Government
    • FMBUDREV : Revenue/Statistical Postings & Open items/actuals Resource
    • FMUSFGO : Object table 1 for US Federal Government
    • FMUSFGFACTS1P : Plan line items table
    • FMUSFGFACTS1A : Actual line item table
    • FMUSFGFACTS2A : Actual line item table
    • FMBUDBCS : Budgetary ledger account derivation: BCS

    FMUSFGA related transaction codes under SAP package FMFG_E

    • FMFG_E_CL2 : Preclosing rollup: fund rules
    • FMFG_AUTO_TC : Treasury Confirmation – Automated
    • FMFG_E_REL : Release Budget
    • BPACCR : Acc Derivation Budget Entry Document
    • FMUSFG1 : USFG Derivation – Customize
    • FMFG_E_TRANS_REG : Transaction Register
    • RFACTS2_FOOTNOTE : FACTS 2: Footnote Maintenance
    • FMFGAPCON : Acc. Property Main Settings
    • RFACTS1_BL : FACTS 1: Trial Balance
    • FMYC02 : Reassignment for canceling Funds
    • FMFG_E_CF : budget carry forward with subtypes
    • OFBL : Budgetary ledger account derivation
    • FMFG_ACC_CLOSEOUT : Closeout of the Residual Accounts
    • OFCL : Rules for Closing Ledger Accounts
    • OFMFG_PMS_ALC : Map Pmt Meth Supp to ALC and Pmt Off
    • RFACTS2_BL : FACTS 2: Trial Balance
    • FMFG_E_YFITRG02 : Document Listing
    • RFACTS1_FILE_SEND : FACTS 1: Send File to Treasury
    • FMSGLBL : Customize US BL SGL
    • FMFGF2_ATTRIBUTES : Configure Attributes

    Related References

    Related Tutorials

    FMFG_TRADE_ID SAP table for – Non-federal trading partner exceptions for US government

    FMFG_TRADE_ID table in SAP PSM (Functions for U.S. Federal Government in PSM) module. This table is used for storing data...

    FMFGT_PO SAP table for – Payment Office – U.S. Federal Government

    FMFGT_PO table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Payment Office...

    FMUSFGFACTS1A SAP table for – Actual line item table

    FMUSFGFACTS1A table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Actual line...

    FMUSFGT SAP table for – Summary table for US Federal Government

    FMUSFGT table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Summary table...

    FMBLYRCL2 SAP tcode for – US BL federal government derivation

    FMBLYRCL2 tcode in SAP PSM (Functions for U.S. Federal Government in PSM) module. This transaction code is used for US...

    FMUSFGFACTS2A SAP table for – Actual line item table

    FMUSFGFACTS2A table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Actual line...

    FMFGRLAYOUT SAP table for – Reporting Layout for Federal Government

    FMFGRLAYOUT table in SAP PSM (Functions for U.S. Federal Government in PSM) module. This table is used for storing data...

    «
    »