1. SAP Tutorial
  2. SAP PSM

FMBUDREV SAP table for – Revenue/Statistical Postings & Open items/actuals Resource

Here we would like to draw your attention to FMBUDREV 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). FMBUDREV is a SAP standard transp table used for storing Revenue/Statistical Postings & Open items/actuals Resource related data in SAP. It comes under the package FMFG_E.

SAP FMBUDREV table

Table FMBUDREV technical data

TableFMBUDREV
Data storingRevenue/Statistical Postings & Open items/actuals Resource
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFG_E
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-PS
Table CategoryTRANSP

SAP FMBUDREV 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 FMBUDREV table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LDGR_AREA : Ledger area
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • FM_AREA : Financial Management Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • COMP_CODE : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FISC_YEAR : From year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • PSTNG_PERIOD : Period from which this entry is valid
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • FUND_TYPE : FM Fund Type
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • VALUE_TYPE : Value Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • TRANSAC : CO Business Transaction
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • AMT_TYPE : Amount type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FUND_STATUS : FM Fund Status (Unexpired, Expired, Cancelled)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • BL_DOC_TYPE : FM budgetary ledger document type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • CFLEV : Carryforward level
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DP_WITH_PO : FM Down payment with reference to purchase order for BL
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • VBUND_FLG : Company ID of trading partner flag for BL
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • FM_LINE : FM US Budgetary Ledger (BL) Line for Account Derivation
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • GL_ACCOUNT : G/L Account Number
    Its data type is CHAR (Character String) with field length 10
  • GL_ACCOUNT_ADJ : G/L Account Number
    Its data type is CHAR (Character String) with field length 10

    • FMBUDREV related tables

    • FMFGT_SS02 : Payment Statistical Sampling Process Rules
    • FMFGF2EXT : FACTS2 Bulk Extract File
    • FMUSFGO : Object table 1 for US Federal Government
    • FMUSFGFACTS1A : Actual line item table
    • FMFGT_ALC : Agency Location Code – U.S. Federal Government
    • FMFG_REPOST_CNTL : Document batching/control for SL Repost for ECC 600 migratio
    • FMBUDACLD : Closing Residual Ledger Accounts : Dummy CC Assignment
    • FMUSFGT : Summary table for US Federal Government
    • FMFGF2MAF : FACTS2 MAF File for Edits
    • FMBUDBCS : Budgetary ledger account derivation: BCS
    • TME_TOLST : Tolerance Key for overdraw tolerance TEXT
    • FMFG_BL_BALACC : Budgetary Ledger balancing account for document split
    • FMUSFGFACTS2T : Summary table
    • FMFG_REPOST_ERR : Errors issued during SL repost for ECC 600 migration
    • FMBUDDIS : Budgetary ledger account derivation: Budgeting (old)
    • FMTC_SCHTOT : Limit Treasury Schedules
    • FMFG_SAV_FACTS1A : Saved FACTS1A data for docs excluded from SL Repost for 600
    • FMFGF2EDGRP : SGL Accounts Edits 2, 3, 5, 10, 11 (FACTS II)
    • FMFGF2_SGLATRVAL : FMFG2 – FACTS II SGL Account Attribute Allowable Values
    • FMFGF2_SGL_TEXTS : FACTS2 – SGL Text Table

    FMBUDREV related transaction codes under SAP package FMFG_E

    • FMFG_E_TRANS_REG : Transaction Register
    • FMFG_TC_REV_SCHEDULE : US Fed. TC Schedule Reversal – Sched
    • FMSGDERIVER : Fund message: customizing
    • OFBL : Budgetary ledger account derivation
    • S_KI4_38000347 : IMG activity: _ISPSFM_V_FMBPCL_FTY
    • FMFG_DIT_FBT : Maintain List of DIT/FBT Accts
    • RFACTS2_PREDC : FACTS 2: Customize Pre-Edit C
    • OFMFG_ALC : Maintain Agency Location Code
    • FMFGAPMT : Accountable Property Movement Types
    • RFACTS2_EDSGL : FACTS 2: Customize Edits 4,7 & 12
    • RFACTS2_EDGRP : FACTS 2: Customize Edits 2,3,5 & 11.
    • S_ALN_01000276 : Maintain File ID and Agency ID
    • FMFG_ACC_CLOSEOUT : Closeout of the Residual Accounts
    • FMFG_CANCELED_AP : Canceled Fund for Account Payable-FI
    • FMYC03DERIVE : FM Object Assignment – Customizing
    • RTREAS_OFFSET_FILE : Create Treasury Offset File
    • RFACTS1_BL : FACTS 1: Trial Balance
    • FMSGDERIVE : Fund message: customizing
    • FMFG_PROG_REPT_CODE : Program Report Category – FACTS II
    • FMFG_E_CF : budget carry forward with subtypes

    Related References

    Related Tutorials

    FMBUDSTA SAP table for – Budgetary ledger account derivation: Open items/Actuals bdgt

    FMBUDSTA table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Budgetary ledger...

    FMBUDRES SAP table for – Budgetary ledger account derivation: Revenue/Statistical

    FMBUDRES table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Budgetary ledger...

    FMFGT_SS01 SAP table for – Payment Statistical Sampling Process Activation table

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

    FMFGBLDRVAREAEAA SAP table for – Derivation rule:Set Expended Appropriations – Actuals (EAA)

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

    FMFGBLDRVAREAMR SAP table for – Derivation rule:Set Miscellaneous Receipts – Actuals (MIR)

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

    FMFGT_SS03 SAP table for – Statistical Sampling Clerk/Supervisor Relationship

    FMFGT_SS03 table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Statistical Sampling...

    FMFGBLAREADOCTY SAP table for – Document Type for BL postings in BL area

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

    «
    »