- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Claim Management (PS-CLM)
- Costs (PS-COS)
- Dates (PS-DAT)
- Document (PS-DOC)
- Expenditure Certification (PSM-EC)
- Functions for U.S. Federal Government (PSM-FG)
- Fund Accounting (PSM-FA)
- Funds Management (PSM-FM)
- Grants Management (PSM-GM)
- Information System (PS-IS)
- Material (PS-MAT)
- Payments (PS-CAF)
- Procurement for Public Sector (PSM-GPR)
- Progress (PS-PRG)
- Project Billing (PS-BIL)
- Project Demand (PS-DMN)
- Resources (PS-CRP)
- Revenues and Earnings (PS-REV)
- Simulation (PS-SIM)
- Structures (PS-ST)
- Virtual Data Model for Project System (PS-VDM)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
FMUSFGA
Actual line item table for US Federal Government.
|
#transactional
|
Component: Funds Management
- 🔑 Keys (2)
- 💰 Amounts (3)
- ∑ Quantities
- 📅 Dates (6)
- ☰ Categorical (26)
- Other (79)
- 🔗 Relations (12)
| Column Name | Description | |
|---|---|---|
| RCLNT FK | Client | |
| GL_SIRID | Record number of the line item record |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (RTCUR): | ||
| TSL | Value in Transaction Currency | |
| 💲 Currency key of currency 2 (T882.CURR1): | ||
| HSL | Value in local currency | |
| 💲 Currency key of the original transaction currency (RWCUR): | ||
| WSL | Value in Original Transaction Currency (Document Currency) | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| BUDAT | Posting Date in the Document | |
| WSDAT | Value Date for Currency Translation | |
| BLDAT | Document Date in Document | |
| CPUDT | Day On Which Accounting Document Was Entered | |
| CPUTM | Time of Entry | |
| ASSET_ACQDATE_9 | Asset Value Date |
| Column Name | Description | |
|---|---|---|
| RRCTY | Record Type | Show values |
| DRCRK | Debit/Credit Indicator | Show values |
| DOCCT | Document Category | Show values |
| REFDOCCT | Reference Document Category | Show values |
| FLG_COVERED | Covered Indicator | Show values |
| FLG_CUSTODIAL | Custodial Indicator | Show values |
| FLG_ENTITY | Entity Indicator | Show values |
| FLG_EXCHANGE | Exchange Indicator | Show values |
| FLG_FEDERAL | Federal/Nonfederal Code | Show values |
| FLG_APPORT | Apportionment Category | Show values |
| FLG_AVAIL | Availability Time | Show values |
| FLG_BORROW | Borrowing Source | Show values |
| FLG_DEFINITE | Definite/Indef indicator | Show values |
| FLG_PARTNER | Transaction Partner | Show values |
| FLG_REIMBUR | Reimbursable | Show values |
| FLG_AUTHOR | Authority Type | Show values |
| FLG_BEA | Budget Enforcement Act Category | Show values |
| XSPLITMOD | Item Changed by Document Splitting | Show values |
| XSKRL | Indicator: Line Item Not Liable to Cash Discount? | Show values |
| YEAR_BDGT_AUTH_9 | Year of Budget Authority | Show values |
| FLG_ADVANCE_9 | Advanced Flag | Show values |
| DEFENSE_INDIC_9 | Defense Indicator / Reduction Type | Show values |
| BDGT_IMPACT_9 | Budgetary Impact | Show values |
| FLG_PYA_9 | Prior Year Adjustment Code | Show values |
| TP_AVTYPE_9 | Availability Type Code (A) for Trading Partner | Show values |
| AVTYPE_9 | Availability Type Code (A) | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| RYEAR | Fiscal Year | GJAHR | |
| POPER | Posting period | POPER | |
| DOCNR | Document Number of an Accounting Document | BELNR | |
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | |
| RACCT | Account Number | SAKNR | |
| RPRCTR | Profit Center | PRCTR | |
| RCNTR | Cost Center | KOSTL | |
| RFUND | Fund | BP_GEBER | |
| RFIPEX | Object Class for US Federal | FM_FIPEX | |
| RFISTL | Funds Center | FISTL | |
| RORDNR | Order Number | AUFNR | |
| RVBUND | Company ID of Trading Partner | RCOMP | |
| RAGNCY_LCTN_CODE | Agency Location Code | FMFG_ALC | |
| RFINUSE | Application of Funds | FM_FINUSE | |
| FMFG_SUBKEY_9 | Subkey for FMUSFGT | CHAR10 | |
| BLSTATUS_9 | Budgetary ledger status | FMFG_BLSTATUS | |
| SGTXT | Item Text | TEXT50 | |
| ACTIV | Business Transaction | CHAR4 | |
| REFDOCNR | Reference document number of an accounting document | BELNR | |
| REFRYEAR | Reference fiscal year | GJAHR | |
| REFDOCLN | Six-Digit Number of the Reference Posting Line | BUZEI6 | |
| REFACTIV | FI-SL Business Reference Transaction | CHAR4 | |
| USNAM | User Name | XUBNAME | |
| AWORG | Reference Organizational Units | AWORG | |
| PMT_OFFICE | Payment Office | FMFG_PMT_OFF | |
| COHORT | Reporting Year for Cohort | FM_COHORT | |
| PUBLAW | Public Law Cited | FM_PUBLAW | |
| LEGIS | Type of Legislation | FM_LEGIS | |
| BUREAU | Federal Bureau | FM_BUREAU | |
| BUSINESS_LINE | Business Line | FM_BUSINESS_LINE | |
| FGDPRTMNT | Federal Department | FM_DEPARTMENT | |
| FGDPRTMNT_PART | Federal Department Partner | FM_DEPARTMENT | |
| FUND_ACC_SYMBL | Main Account | FM_MAIN_ACCT | |
| AWID | Reference document: Current identification | AWID | |
| BELNR | Document Number of an Accounting Document | BELNR | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | |
| LINETYPE | Item Category | LINETYPE | |
| FUND_TYPE | FM Fund Type | FM_FUNDTYPE | |
| FM_AREA | Financial Management Area | FIKRS | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | |
| CO_AREA | Controlling Area | CACCD | |
| SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | FM_SGL_ACCOUNT | |
| BDGT_FUNC_CLSS | Classification of Data According to Major Purpose | CHAR3 | |
| FMCMMTSTR_9 | FM Commitment String For Budgetary Ledger | FMCMMTSTR | |
| TRANSFER_AGCY_9 | Transfer Agency | FMFG_TRANSFER | |
| TRANSFER_ACCT_9 | Transfer Account | FMFG_TRAN_ACCT | |
| XBLNR | Reference Document Number | XBLNR1 | |
| LIFNR | Account Number of Supplier | LIFNR | |
| KUNNR | Customer Number | KUNNR | |
| PROG_REPT_CAT_9 | Program Reporting Category | FMFG_PROGRAM_REPORT_CATEGORY | |
| BUDGET_PD_9 | Budget Period | FM_BUDGET_PERIOD | |
| ASSETMAINO_9 | Main Asset Number | BF_ANLN1 | |
| ASSETSUBNO_9 | Asset Subnumber | BF_ANLN2 | |
| MOVEMENTTYPE_9 | Asset Transaction Type | BWASL | |
| NPLNR_9 | Network Number for Account Assignment | AUFNR | |
| APLZL_9 | Internal counter | CIM_COUNT | |
| AUFPL_9 | Routing number of operations in the order | AUFPL | |
| PRZNR_9 | Business Process | CO_PRZNR | |
| IMKEY_9 | Internal Key for Real Estate Object | IMKEY | |
| INTRENO_9 | Internal Real Estate Master Data Code | VVINTRENO | |
| APPOR_CATB_DTL_9 | Apportionment Category B Program Code | ||
| PROGRAM_IND_9 | Disaster Emergency Fund Code | FMFG_DISASTER_EMER_FUND_CODE3 | |
| TP_SUBLEVL_9 | Sublevel Prefix (SP) for Trading Partner | FMFG_SUBLEVL | |
| TP_AGENCID_9 | Agency Identifier (AID) for Trading Partner | FMFG_AGENCID | |
| TP_ALTRAID_9 | Allocation Transfer Agency Identifier (ATA) Trading Partner | FMFG_ALTRAID | |
| TP_BEGPER_9 | Beginning Period of Availability (BPOA) for Trading Partner | FMFG_BEGPER | |
| TP_ENDPER_9 | Ending Period of Availability (EPOA) for Trading Partner | FMFG_ENDPER | |
| TP_MAIN_ACCT_9 | Main Account for Trading Partner | ||
| TP_SUB_ACCT_9 | Subaccount for Trading Partner | ||
| BETC_9 | Business Event Type Code | CHAR10 | |
| TP_BETC_9 | Business Event Type Code for Trading Partner | ||
| TREASURY_OFFS_9 | Treasury Offset Program Eligibility | ||
| GARNISHMENT_9 | Garnishment | ||
| SUBLEVL_9 | Sublevel Prefix (SP) | FMFG_SUBLEVL | |
| AGENCID_9 | Agency Identifier (AID) | FMFG_AGENCID | |
| ALTRAID_9 | Allocation Transfer Agency Identifier (ATA) | FMFG_ALTRAID | |
| BEGPER_9 | Beginning Period of Availability (BPOA) | FMFG_BEGPER | |
| ENDPER_9 | Ending Period of Availability (EPOA) | FMFG_ENDPER | |
| SUB_ACCT_9 | Subaccount | FM_SUB_ACCT |
| Master Data Relations | Join Conditions |
|---|---|
| Reference procedure | FMUSFGA.AWTYP == TTYP.AWTYP |
| FI-SL Document Type | |
| Logical system | FMUSFGA.LOGSYS == TBDLS.LOGSYS |
Funded Program
| |
| Company Code | |
| Business Area | |
| Client | FMUSFGA.RCLNT == T000.MANDT |
| Functional Area | |
Ledger
| |
| Currency Key | |
Version
|