C_MemoRecordTP

Memo Record Administrative Data | view: CMEMORECORDTP | Extraction: Not supported | Component: SAP Cash Management
Tables used: FQM_FLOW, TPIT_TRADE_REQ, FCLM_BAM_AMD, FCLM_BAM_AMD_T, FCLM_BAM_AC_TYPE, BUT000, T001, TKA02, TRBAC_ASSIGN_T, TRBAC_CHARAC_T, TRBAC_INT_REF_T, FLQLPOST, T036T, USR21
Column Name Description
CashFlowID Flow ID
Column Name Description
💲 Currency (TransactionCurrency):
AmountInTransactionCurrency Amount
💲 Currency (TradedCurrency):
AmountInTradedCurrency Amount
OpenAmountInTradedCurrency Amount
💲 Following Currency (FollowingCurrency):
AmountInFollowingCurrency Amount
OpenAmountInFollowingCurrency Amount
Column Name Description
Column Name Description
TransactionDate Transaction Date
ExpirationDate Net Due Date
OffsettingValueDate Value date
BankStatementDate Statement Date
TermStartDate Value date
CashReqValueDate Transaction Date
TermEndDate Value date
LoanTermStartDate Value date
LoanTermEndDate Value date
Column Name Description
CshTrdReqSubmdByUserIsHidden Truth Value: True/False Show values
OriginApplication Source Application Show values
IsDeleted Deleted Show values
CustomerFactoryCalenderCode Calendar Type Show values
CashReleaseStatus Release Status Show values
Column Name Description Domain name
CashMemoRecordID ID number for cash management and forecast
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
PlanningLevel Planning Level FDLEV
CashPlanningGroup Planning Group FDGRP
BankAccountInternalID Bank Account Technical ID
BankAccountRevision Revision Number FCLM_REVISION
BankAccount Bank Account Number
BankAccountDescription Account Description TEXT60
MemoRecordStatus State for cash memo record
MemoRecordStatusCriticality null
LiquidityItem Liquidity Item FLQPOS
LiquidityItemDescription Liquidity Item - Name
BusinessArea Business Area GSBER
ProfitCenter Profit Center PRCTR
OffsettingCompanyCode Company Code
OffsettingCompanyCodeName Name of Company Code or Company TEXT25
OffsettingAccount Offsetting account
OffsettingBankAccount Bank account number BANKN
OffsetBankAccountNumber Bank Account Number
OffsettingHouseBank Short Key for a House Bank
OffsettingHouseBankAccount ID for Account Details
BankStatementShortID Source Transaction ID
AssetFund Fund BP_GEBER
AssetGrant Grant GM_GRANT_NBR
CreatedByUser User Name
CreatedByUserDescription User Description SUIDTECHDESC
CreationTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
LastChangedByUser User Name
LastChangedByUserDescription User Description SUIDTECHDESC
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
CashRequestSubmittedByUser Submitted By UNAME
HouseBank Short Key for a House Bank
HouseBankAccount ID for Account Details
GLAccount General Ledger Account SAKNR
OwnerName Owner of a Business Transaction FQM_OWNER
CertaintyLevel FCLM_MM_CERTAINTY_LEVEL
CertaintyLevelName Short Text for Fixed Values
CashFlowCategory Flow Category FQM_FLOW_CATEGORY
CashFlowType Flow Type FQM_FLOW_TYPE
EffectiveInterestRate Interest rate PRZ43
TextDescription Item Text
IsStatisticalItem Statistics Indicator
StatisticalItemText Short Text for Fixed Values
Segment Segment for Segmental Reporting FB_SEGMENT
CashReleaseStatusText Short Text for Fixed Values DDTEXT
TreasuryTradeRequest Trade Request ID
CashRequestStatus Cash Request Status
CashRequestStatusDesc Short Text for Fixed Values DDTEXT
CashReqInstrCategory Trade Request Instrument Category
CashReqInstrCategoryDesc Short Text for Fixed Values DDTEXT
TrsyTradedAmountBuySellCode Buy/Sell Indicator
CashReqCompanyCode Company Code
CashReqCompanyCodeName Name of Company Code or Company TEXT25
SendingBankAccountIntID Bank Account Technical ID
SendingBankAccount Bank Account Number
SendingBankAccountName Account Description TEXT60
ReceivingBankAccountIntID Bank Account Technical ID
ReceivingBankAccount Bank Account Number
ReceivingBankAccountName Account Description TEXT60
BusinessPartner Business Partner Number
BusinessPartnerName null
BankIdentification Bank Details ID
FinancialInstrumentAssignment Assignment
FinancialInstrAssignmentDesc Value Description TRBA_DESCRIPTION
FinancialInstrumentReference Internal Reference
FinancialInstrReferenceDesc Value Description TRBA_DESCRIPTION
FinancialInstrCharacteristic Characteristics
FinancialInstrCharcDesc Value Description TRBA_DESCRIPTION
CashReqLiquidityItem Liquidity Item
CashReqLiquidityItemName Liquidity Item - Name TEXT30
CashReqPlanningLevel Planning Level
CashReqPlanningLevelName Planning Level Short Text TEXT10
CashReqHasDocument Checkbox
TrsyTradeReqCancellationReason Trade Request: Cancel Reason
TrsyTradeReqCanclnRsnName Short Text for Fixed Values DDTEXT
CashRequestText Item Text
TrsyCshFlowDebtInvmtCode Invest or Borrow
OffstgBankAccountInternalID Offsetting Bank Account Technical ID NUM10
CashPaymentAdviceGroup ID number for payment advice group in cash mgt and forecast IDENR