1. SAP Tutorial
  2. SAP PSM

FMUSFGT SAP table for – Summary table for US Federal Government

Here we would like to draw your attention to FMUSFGT 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). FMUSFGT is a SAP standard transp table used for storing Summary table for US Federal Government related data in SAP. It comes under the package FMFG_E.

SAP FMUSFGT table

Table FMUSFGT technical data

TableFMUSFGT
Data storingSummary 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 FMUSFGT 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 FMUSFGT table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RLDNR : Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • ROBJNR : Object number for objects (account assignment elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • COBJNR : Object number for transaction attributes
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • SOBJNR : Object number for partner objects (accnt assignmnt elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RTCUR : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • DRCRK : Debit/Credit Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • 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
  • TSLVT : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL01 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL02 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL03 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL04 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL05 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL06 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL07 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL08 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL09 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL10 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL11 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL12 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL13 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL14 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL15 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL16 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • HSLVT : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL01 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL02 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL03 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL04 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL05 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL06 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL07 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL08 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL09 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL10 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL11 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL12 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL13 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL14 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL15 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL16 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • CSPRED : Distribution key for currency amounts
    Its data type is CHAR (Character String) with field length 4
  • 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
  • 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
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24

    • FMUSFGT related tables

    • FMFGT_SS03 : Statistical Sampling Clerk/Supervisor Relationship
    • FMFGT_POT : Text table for Payment Office – U.S. Federal Government
    • FMUSERGROUP : User maintenance for group
    • FMUSFGFACTS2P : Plan line items table
    • FMFGF2PREDC : Pre-edit C – Expired/Unexpired (FACTS II)
    • FMUSFGC : Object table 2
    • TME_TOL : Overdraw tolerance for Purchase Order / Requisition
    • FMFG_REPOST_CNTL : Document batching/control for SL Repost for ECC 600 migratio
    • FMBUDACLD : Closing Residual Ledger Accounts : Dummy CC Assignment
    • FMUSFGFACTS1A : Actual line item table
    • FMFG_PO_CMMTSTR : Commitment string lookup table for SES ZEKKN correction
    • FMFG_PO_SUBSET : ZEKKN number to correct invoices for SES
    • FMFGF2EDPRF : Edit 8- SF 133 Proof Edit (FACTS II)
    • FMFGF2VERSION : Facts II Program Version Number
    • FMBUDRES : Budgetary ledger account derivation: Revenue/Statistical
    • FMFGF2_SGLATR : FMFG2 – FACTS SGL Attributes
    • FMTC_PMT_TYPE : Pmt Method mapped to the Pmt Type(s) / Codes for US Fed
    • T042F_FMFG_TC : Pmt Method Supp map to ALC and Pmt Office – US Treas Conf
    • FMUSFGFACTS2A : Actual line item table
    • FMFG_ACT_CLI_DEP : US Federal activation of client dependant functionality

    FMUSFGT related transaction codes under SAP package FMFG_E

    • FMYC02 : Reassignment for canceling Funds
    • FMFG_E_ZOPAC : Online Payment and Collection System
    • FMFG_E_TRANS_REG : Transaction Register
    • FMFG_ACC_CLOSEOUT : Closeout of the Residual Accounts
    • RFACTS2_FILE_SEND : FACTS 2: Send File to Treasury
    • S_KI4_38000347 : IMG activity: _ISPSFM_V_FMBPCL_FTY
    • RFACTS2_EDGRP : FACTS 2: Customize Edits 2,3,5 & 11.
    • S_KI4_38000333 : IMG-Aktivität: _ISPSFM_V_FMFGT_ALC
    • RFACTS1_FILE_SEND : FACTS 1: Send File to Treasury
    • FMUSFG2 : USFG Derivation – Maintain
    • FMFGAPAAC : Acc. Property account assignment cat
    • FMFG_TC_REV_SCHEDULE : US Fed. TC Schedule Reversal – Sched
    • FMFG_PMT_TYPE : Maintain Pmt Method to Pmt Type map
    • FMFG_E_REL : Release Budget
    • FMSGDERIVE : Fund message: customizing
    • RFACTS2_UPLMAF : FACTS 2: Upload MAF File
    • FMFGAPCON : Acc. Property Main Settings
    • RFACTS2_EDINV : FACTS 2: Customize Edit 6.
    • FMUSFG1 : USFG Derivation – Customize
    • FMFG_E_CF : budget carry forward with subtypes

    Related References

    Related Tutorials

    GLT3 SAP table for – Summary Data Preparations for Consolidation

    GLT3 table in SAP FI (Consolidation in FI) module. This table is used for storing data of Summary Data Preparations...

    FMRBT SAP table for – Summary table

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

    FMAVCT SAP table for – AVC Summary Table (BCS)

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

    FMSPLITT SAP table for – Summary table

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

    FMUSFGFACTS1T SAP table for – Summary table

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

    J_3RKKR0 SAP table for – Account correspondence – summary table

    J_3RKKR0 table in SAP FI (Localization in FI) module. This table is used for storing data of Account correspondence -...

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

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

    «
    »