- 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_GranteeMgmtActlDocQry1
Grantee Management Commitment/Actual Document Items Query
| view: CGMACDOCIANQ1
| Extraction:
Not supported
| Component: Information System
Tables used:
GMIA, T001, TKA02, FM01, GMGR, GMGRANTNONE, GMVALUETYPE, GMGRTYPE, T882, GMSPCLASS, PRPS, FINSC_FISC_DATE
- 🔑 Keys
- 💰 Amounts (6)
- ∑ Quantities
- 📅 Dates (2)
- ☰ Categorical (3)
- Other (30)
- 🔗 Relations (7)
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 💲 Grant currency (GrantCurrency): | ||
| AmountInGrantCurrency | GM Amount in Grant Currency | |
| CmtmtAmountInGrantCrcy | Commitment Amount in Grant Currency in Grantee Mgmt | |
| ActlAmountInGrantCrcy | Actual Amount in Grant Currency in Grantee Management | |
| 💲 GM Company Code Currency (CompanyCodeCurrency): | ||
| AmountInCompanyCodeCurrency | GM Amount in Company Code Currency | |
| CmtmtAmtInCompanyCodeCurrency | Commitment Amount in Company Code Currency in Grantee Mgmt | |
| ActualAmountInCompanyCodeCrcy | Actual Amount in Company Code Currency in Grantee Management | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| PostingDate | Posting Date in the Document | |
| CreationDate | Day On Which Accounting Document Was Entered |
| Column Name | Description | |
|---|---|---|
| GranteeMgmtValueTypeCategory | GM Value Type Category | Show values |
| IsStatisticalItem | Statistical Indicator | Show values |
| SponsoredClassType | Sponsored Class Type | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| GrantFiscalYear | Fiscal Year of Sponsor (is Grant Fiscal Year) | GJAHR | |
| GrantFiscalYearPeriod | Posting Period of Sponsor (is Grant Posting Period) | POPER | |
| GrantID | Grant | GM_GRANT_NBR | |
| SponsoredProgram | Sponsored Program | GM_SPONSORED_PROG | |
| SponsoredClass | Sponsored Class | GM_SPONSORED_CLASS | |
| Fund | Fund | BP_GEBER | |
| GteeMBudgetValidityNumber | Budget Validity Number | GM_BDGT_VLDTY_NBR | |
| GLAccount | G/L Account | SAKNR | |
| FinancialManagementArea | Financial Management Area | FIKRS | |
| BusinessArea | Business Area | GSBER | |
| FundsCenter | Funds Center | FISTL | |
| CommitmentItem | Commitment Item | FM_FIPEX | |
| FunctionalArea | Functional Area | FKBER | |
| FundedProgram | Funded Program | FM_MEASURE | |
| ControllingArea | Controlling Area | CACCD | |
| CostCenter | Cost Center | KOSTL | |
| MasterFixedAsset | Fixed Asset | ANLN1 | |
| FixedAsset | Asset Subnumber | ANLN2 | |
| OrderID | Order ID | AUFNR | |
| ProfitCenter | Profit Center | PRCTR | |
| WBSElementExternalID | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | |
| Material | Material Number | MATNR | |
| GranteeMgmtValueType | GM Value Type | GM_VALUETYPE | |
| BusinessTransactionType | Business Transaction Category | FINS_BTTYPE | |
| GranteeFiscalYear | Fiscal Year for Grantee Organization | GJAHR | |
| ReferenceDocument | Reference document number | AWREF | |
| ReferenceDocumentFiscalYear | Reference fiscal year | GJAHR | |
| ReferenceDocumentItem | Reference Document Line Item | NUMC6 | |
| ReferenceDocumentContext | Reference Organizational Units | AWORG | |
| ReferenceDocumentLogicalSystem | Logical System of Reference Document | LOGSYS |
| Master Data Relations | Join Conditions |
|---|---|
Company Code
| |
GM Company Code Currency
| |
Grant currency
| |
Grant Sponsor
| |
| Lifecycle Status | C_GRANTEEMGMTACTLDOCQRY1.GRANTLIFECYCLESTATUS == TJ02.ISTAT |
| Logical system | C_GRANTEEMGMTACTLDOCQRY1.LOGICALSYSTEM == TBDLS.LOGSYS |
| Reference procedure | C_GRANTEEMGMTACTLDOCQRY1.REFERENCEDOCUMENTTYPE == TTYP.AWTYP |