- 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)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Collections Management (FIN-FSCM-COL)
- Credit Management (FIN-FSCM-CR)
- Digital Payments (FIN-FSCM-DP)
- Direct Bank Communication (FIN-FSCM-BNK)
- Dispute Management (FIN-FSCM-DM)
- Financial Risk Management for Commodities (FIN-FSCM-CMM)
- One Exposure (FIN-FSCM-FQM)
- Payment Factory (FIN-FSCM-PF)
- SAP Cash Management (FIN-FSCM-CLM)
- Treasury and Risk Management (FIN-FSCM-TRM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- 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)
- 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)
I_MemoRecordMstrData
all the fields including reference info
| view: IMEMOMSTRDATA
| Extraction:
Not supported
| Component: SAP Cash Management
Tables used:
FQM_FLOW
- 🔑 Keys (1)
- 💰 Amounts (3)
- ∑ Quantities
- 📅 Dates (8)
- ☰ Categorical (13)
- Other (43)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| CashFlowID | Flow ID |
| Column Name | Description | |
|---|---|---|
| 💲 Currency (TransactionCurrency): | ||
| AmountInTransactionCurrency | Amount | |
| 💲 Currency (LocalCurrency): | ||
| AmountInLocalCurrency | Amount | |
| 💲 Following Currency (FollowingCurrency): | ||
| AmountInFollowingCurrency | Amount | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| TransactionDate | Transaction Date | |
| ExpirationDate | Net Due Date | |
| BankStatementDate | Planned Payment Date2 | |
| TermStartDate | Value date | |
| OffsettingValueDate | Value date | |
| TermEndDate | Value date | |
| LoanTermStartDate | Value date | |
| LoanTermEndDate | Value date |
| Column Name | Description | |
|---|---|---|
| CertaintyLevel | Certainty Level | Show values |
| OriginApplication | Source Application | Show values |
| IsDeleted | Deleted | Show values |
| MemoRecordStatus | State for cash memo record | Show values |
| CustomerFactoryCalenderCode | Calendar Type | Show values |
| CashReleaseStatus | Release Status | Show values |
| IncomingStatusReason | Reason for pairing payment advices in cash mgt and forecast | Show values |
| CashRequestStatus | Cash Request Status | Show values |
| CashReqInstrCategory | Trade Request Instrument Category | Show values |
| TrsyTradedAmountBuySellCode | Buy/Sell Indicator | Show values |
| CashReqHasDocument | Checkbox | Show values |
| IsStatisticalItem | Statistics Indicator | Show values |
| TrsyCshFlowDebtInvmtCode | Invest or Borrow | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| ValidFrom | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TZNTSTMPL | |
| ValidTo | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TZNTSTMPL | |
| CashMemoRecordID | ID number for cash management and forecast | IDENR | |
| CompanyCode | Company Code | BUKRS | |
| PlanningLevel | Planning Level | FDLEV | |
| CashPlanningGroup | Planning Group | FDGRP | |
| BankAccountInternalID | Bank Account Technical ID | NUM10 | |
| LiquidityItem | Liquidity Item | FLQPOS | |
| CreatedByUser | User Name | UNAME | |
| CreationTime | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TZNTSTMPL | |
| LastChangedByUser | User Name | UNAME | |
| LastChangeDateTime | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TZNTSTMPL | |
| BusinessArea | Business Area | GSBER | |
| ProfitCenter | Profit Center | PRCTR | |
| AssetFund | Fund | BP_GEBER | |
| AssetGrant | Grant | GM_GRANT_NBR | |
| BankStatementShortID | Source Transaction ID | FQM_ORIGIN_TRANS_ID | |
| HouseBank | Short Key for a House Bank | HBKID | |
| HouseBankAccount | ID for Account Details | HKTID | |
| GLAccount | General Ledger Account | SAKNR | |
| OwnerName | Owner of a Business Transaction | FQM_OWNER | |
| CashFlowCategory | Flow Category | FQM_FLOW_CATEGORY | |
| CashFlowType | Flow Type | FQM_FLOW_TYPE | |
| EffectiveInterestRate | Interest rate | PRZ43 | |
| TextDescription | Item Text | TEXT50 | |
| Segment | Segment for Segmental Reporting | FB_SEGMENT | |
| RuleExchangeRateType | Exchange Rate Type | KURST | |
| ReferenceSiteName | Internal Reference | CHAR16 | |
| OffsettingAccount | Offsetting account | GRUPP | |
| OffsettingCompanyCode | Company Code | BUKRS | |
| OffsettingBankAccount | Bank account number | BANKN | |
| OffsetBankAccountNumber | Bank Account Number | FCLM_BAM_ACC_NUM | |
| OffsettingHouseBank | Short Key for a House Bank | HBKID | |
| OffsettingHouseBankAccount | ID for Account Details | HKTID | |
| PaymentGroup | ID number for payment advice group in cash mgt and forecast | IDENR | |
| OffsettingAccountName | Offsetting Bank Account Technical ID | NUM10 | |
| CABankStatementItem | Memo Record Number (Line Item Number in Bank Statement) | NUM5 | |
| ReceivingBankAccountIntID | Bank Account Technical ID | NUM10 | |
| FinancialInstrumentAssignment | Assignment | TEXT18 | |
| FinancialInstrumentReference | Internal Reference | CHAR16 | |
| FinancialInstrCharacteristic | Characteristics | CHAR25 | |
| BankIdentification | Bank Details ID | CHAR4 | |
| BusinessPartner | Business Partner Number | BU_PARTNER |