1. SAP Tutorial
  2. SAP PSM

FMUSFGFACTS1T SAP table for – Summary table

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

SAP FMUSFGFACTS1T table

Table FMUSFGFACTS1T technical data

TableFMUSFGFACTS1T
Data storingSummary table
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFG_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMUSFGFACTS1T 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 FMUSFGFACTS1T 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
  • RFUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • RFINUSE : Application of Secondary Source Funds
    Its data type is CHAR (Character String) with field length 16
  • RFLG_COVERED : Covered Indicator
    Its data type is CHAR (Character String) with field length 1
  • RFLG_CUSTODIAL : Custodial Indicator
    Its data type is CHAR (Character String) with field length 1
  • RFLG_ENTITY : Entity Indicator
    Its data type is CHAR (Character String) with field length 1
  • RFLG_EXCHANGE : Exchange Indicator
    Its data type is CHAR (Character String) with field length 1
  • RVBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • RFLG_PARTNER : Transaction Partner
    Its data type is CHAR (Character String) with field length 1
  • RBDGT_FUNC_CLSS : Classification of Data According to Major Purpose
    Its data type is CHAR (Character String) with field length 3
  • 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
  • RFAREA : Functional Area
    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_SUBKEY96_9 : Subkey for FMUSFGFACTS1T
    Its data type is CHAR (Character String) with field length 10
  • SBUKRS : Company code of partner
    Its data type is CHAR (Character String) with field length 4
  • 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
  • FM_AREA : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • FLG_FEDERAL : Federal Indicator
    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
  • SGL_ACCOUNT : SGL Account, US Federal Government
    Its data type is CHAR (Character String) with field length 4
  • RFISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24

    • FMUSFGFACTS1T related tables

    • FMTC_SCHTOT : Limit Treasury Schedules
    • FMUSFGFACTS2O : Object table 1
    • FMFGF2PREDC : Pre-edit C – Expired/Unexpired (FACTS II)
    • FMFGT_SS01 : Payment Statistical Sampling Process Activation table
    • FMUSFGC : Object table 2
    • FMFGAPCON : Accountable Property Configuration Data
    • FMBPCLOSE_FTYPE : Preclosing Rollup: Transfer Rules for Fund Type
    • FMFG_BL_BALACC : Budgetary Ledger balancing account for document split
    • FMUSFGFACTS2C : Object table 2
    • FMFGF2_SGLATRVAL : FMFG2 – FACTS II SGL Account Attribute Allowable Values
    • FMFG_ACT_CLI_DEP : US Federal activation of client dependant functionality
    • FMFG_REPOST_RCLR : Reversed clearing documents for ECC 600 migration
    • FMFGAPAAC : Account Assignment Categories for Acc. Property
    • FMFGF2EDGRP : SGL Accounts Edits 2, 3, 5, 10, 11 (FACTS II)
    • FMFGF2VERSION : Facts II Program Version Number
    • FMFGF2MAF : FACTS2 MAF File for Edits
    • FMUSFGA : Actual line item table for US Federal Government
    • FMUSFGO : Object table 1 for US Federal Government
    • FMUSFGFACTS1O : Object table 1
    • FMFGF2EXT : FACTS2 Bulk Extract File

    FMUSFGFACTS1T related transaction codes under SAP package FMFG_E

    • FMFG_PROG_REPT_CODE : Program Report Category – FACTS II
    • S_KI4_38000317 : IMG activity: _ISPSFM_V_T042F_FMFG
    • RFACTS2_FOOTNOTE : FACTS 2: Footnote Maintenance
    • FMFG_E_1099_C : Tax Form 1099-C
    • OFMFG_PMS_ALC : Map Pmt Meth Supp to ALC and Pmt Off
    • FMFGF2_ATTRIBUTES : Configure Attributes
    • FMFG_SS_STATUS : Payment Sampling Process Status Repo
    • RFACTS2_PREDC : FACTS 2: Customize Pre-Edit C
    • FMFG_E_CL0 : Preclosing Rollup
    • FMFG_SS_BATCH : Payment Statistical Sampling – Invoi
    • S_KI4_38000336 : IMG-Aktivität: _ISPSFM_FMUSFG1
    • FMFG_CANCELED_AR : Canceled Fund for Acct Receivable-FI
    • BPACC : Line derivation budgeting documents
    • RFACTS2_MAF : FACTS 2: Maintain MAF File
    • OFGR : Create user groups
    • FMSGDERIVER : Fund message: customizing
    • FMFGAPCR : Accountable Property program
    • RFACTS2_BL : FACTS 2: Trial Balance
    • RFACTS2_EDSGL : FACTS 2: Customize Edits 4,7 & 12
    • RFACTS1_TR : FACTS 1: Transaction Register

    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....

    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...

    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 -...

    FMUSFGFACTS2T SAP table for – Summary table

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

    «
    »