C_Liquidityforecast_Overviewq

Query for Liquidity Forecast Overview | view: CLFOVERVIEWQUERY | Extraction: Not supported | Component: SAP Cash Management
Column Name Description
Column Name Description
💲 Currency (Currency):
OpeningBalanceAmtInTransCrcy null
NetAmountInTransacCurrency null
ClosingBalanceAmtInTransCrcy null
Column Name Description
Column Name Description
CalendarDay Transaction Date
Column Name Description
Column Name Description Domain name
CompanyCode Company Code
CompanyCodeName Name of Company Code or Company
DomainValueName Short Text for Fixed Values
BankAccountInternalID Bank Account Technical ID
BankAccountDescription Account Description
BankAccount Bank Account Number
BankAccountStatus Bank Account Status
Master Data Relations Join Conditions
Bank Key
  • Bank Key
  • ?
  • Client
  • C_LIQUIDITYFORECAST_OVERVIEWQ.BANK == BNKA.BANKL
  • C_LIQUIDITYFORECAST_OVERVIEWQ.[column in domain "BANKS"] == BNKA.BANKS
  • C_LIQUIDITYFORECAST_OVERVIEWQ.MANDT == BNKA.MANDT
Bank Account Type ID
  • Bank Account Type ID
  • Client
Business Area
  • Client
  • Business Area
  • C_LIQUIDITYFORECAST_OVERVIEWQ.MANDT == TGSB.MANDT
  • C_LIQUIDITYFORECAST_OVERVIEWQ.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • C_LIQUIDITYFORECAST_OVERVIEWQ.MANDT == TKA01.MANDT
  • C_LIQUIDITYFORECAST_OVERVIEWQ.CONTROLLINGAREA == TKA01.KOKRS