P_MemoRecord

Memo Record | view: PMEMORECORD | Extraction: Not supported | Component: SAP Cash Management
Tables used: FDES
Column Name Description
DocumentIsArchived FK Archiving category
CompanyCode FK Company Code
GLAccount G/L account/internal Cash Mgmt account
CashPlanningGroup FK Planning Group
PlanningLevel FK Planning Level
TransactionCurrency FK Planned currency for cash management and forecast
TransactionDate Planning Date
BankStatementByCashManagement ID number for cash management and forecast
BusinessArea FK Business Area
Column Name Description
Column Name Description
Column Name Description
TransactionDate Planning Date
CreationDate Date on Which Record Was Created
LastChangeDate Date of last change
ExpirationDate Archiving or automatic expiration date
BankStatementDate Bank Statement Date
StartDate Start date
Column Name Description
InvertedExchangeRateIsAllowed Indicator: inverted rate entry Show values
Column Name Description Domain name
AmountInCompanyCodeCurrency null
AmountInTransactionCurrency null
CreatedByUser User who created the record USRID
LastChangedByUser Last user to make a change XUBNAME
Characteristic Characteristics MERKM
AssignmentReference Assignment Number ZUONR
DocumentItemText Text TEXT50
OffsettingAccount Offsetting account GRUPP
BankStatement Bank statement number AUSNR
FinancialTransactionType Transaction type VOART
InterestRateInPercent Interest rate PRZ43
ProfitCenter Profit Center PRCTR
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
PaymentMethod Payment Method ZLSCH
Master Data Relations Join Conditions
Bank Account Technical ID
  • Bank Account Technical ID
  • Client
  • ?
Business Area
  • Client
  • Business Area
  • P_MEMORECORD.MANDT == TGSB.MANDT
  • P_MEMORECORD.BUSINESSAREA == TGSB.GSBER
Planning Group
  • Client
  • Planning Group
  • P_MEMORECORD.MANDT == T035.MANDT
  • P_MEMORECORD.CASHPLANNINGGROUP == T035.GRUPP
Company Code
  • Client
  • Company Code
  • P_MEMORECORD.MANDT == T001.MANDT
  • P_MEMORECORD.COMPANYCODE == T001.BUKRS
Archiving category
  • Archiving category
  • Client
  • P_MEMORECORD.DOCUMENTISARCHIVED == T037A.ARCHK
  • P_MEMORECORD.MANDT == T037A.MANDT
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • P_MEMORECORD.MANDT == TCURV.MANDT
  • P_MEMORECORD.EXCHANGERATETYPE == TCURV.KURST
Liquidity Item
  • Liquidity Item
  • Client
  • P_MEMORECORD.LIQUIDITYITEM == FLQLPOS.LQPOS
  • P_MEMORECORD.MANDT == FLQLPOS.MANDT
Planning Level
  • Planning Level
  • Client
  • P_MEMORECORD.PLANNINGLEVEL == T036.EBENE
  • P_MEMORECORD.MANDT == T036.MANDT
Planning type
  • Planning type
  • Client
  • P_MEMORECORD.PLANNINGTYPE == T037.DSART
  • P_MEMORECORD.MANDT == T037.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Planned currency for cash management and forecast
  • Planned currency for cash management and forecast
  • Client
  • P_MEMORECORD.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_MEMORECORD.MANDT == TCURC.MANDT