- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Claim Management (PS-CLM)
- Functions for U.S. Federal Government (PSM-FG)
- Fund Accounting (PSM-FA)
- Funds Management (PSM-FM)
- Grants Management (PSM-GM)
- Information System (PS-IS)
- Procurement for Public Sector (PSM-GPR)
- Project Billing (PS-BIL)
- Project Demand (PS-DMN)
- 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 Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_FundsMgmtAvailyCtrlQry1
Funds Management AVC Query
| view: CFMAVCITMANQ1
| Extraction:
Not supported
| Component: Information system
Tables used:
FMAVCP, FMAVCT, FMAVCT_RECON_YR, FMBUDGETPD, FMCI, FMHICI, FM01, BUAVCSRC, FMFINCODE, FMMEASURE, FMFCTR, TFKB, GMGR, GMGRANTNONE, GMGRTYPE, BUAVCLDGR, FINSC_FISC_DATE, FINSC_PERIOD
- 🔑 Keys
- 💰 Amounts (3)
- ∑ Quantities
- 📅 Dates (1)
- ☰ Categorical (2)
- Other (11)
- 🔗 Relations (5)
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 💲 Financial Management Area Currency (FinancialManagementAreaCrcy): | ||
| ConsumableAmountInFMACrcy | Consumable Amount | |
| ConsumedAmountInFMACrcy | Consumed Amount | |
| AvailableAmountInFMACrcy | Available Amount | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| ReferenceDocumentChangeDate | Reference Document Change Date in Funds Management |
| Column Name | Description | |
|---|---|---|
| BudgetWorkFlowStatus | Workflow Status of a Record in the AVC Totals Table | Show values |
| ControlObjectAmountType | Amount Type (Availability Control) | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| FinMgmtAreaFiscalYear | Fiscal Year | GJAHR | |
| BdgtCashEffectivityFiscalYear | Year of Cash Effectivity in Budgeting | GJAHR | |
| ControlObjectCoverGroup | Cover Group in Control Object | FMCE_CVRGRP | |
| ControlObjectBudgetPeriod | Budget Period in Control Object | FM_BUDGET_PERIOD | |
| ControlObjectCommitmentItem | Commitment Item in Control Object | FM_FIPEX | |
| CommitmentItemFiscalYear | null | ||
| ControlObjectFunctionalArea | Functional Area in Control Object | FKBER | |
| ControlObjectFund | Fund in Control Object | BP_GEBER | |
| ControlObjectFundedProgram | Funded Program in Control Object | FM_MEASURE | |
| ControlObjectFundsCenter | Funds Center in Control Object | FISTL | |
| CtrlObjFundsMgmtCustomerField | Customer Field in Control Object | FM_USERDIM |
| Master Data Relations | Join Conditions |
|---|---|
Control Ledger
| |
Grant in Control Object
| |
Financial Management Area
| |
Financial Management Area Currency
| |
Fiscal Year Variant
|