C_Liquidityforecastdetailsq

Liquidity Forecast Details Query | view: CLIQFOREDETQUERY | Extraction: Not supported | Component: SAP Cash Management
Column Name Description
Column Name Description
💲 Currency (Currency):
AmountInTransactionCurrency null
AmountInDisplayCurrency null
Column Name Description
Column Name Description
CalendarDay Transaction Date
Column Name Description
CertaintyLevel Certainty Level Show values
CashFlowDirection Cash Flow Direction Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
LiquidityItemName Liquidity Item - Name TEXT30
LiquidityItem Liquidity Item FLQPOS
DomainValueName Short Text for Fixed Values
BankAccountInternalID Bank Account Technical ID
BankAccount Bank Account Number
BankAccountDescription Account Description
BankAccountStatus Bank Account Status
BusinessArea Business Area GSBER
BusinessPartner Business Partner Number BU_PARTNER
CostCenter Cost Center KOSTL
Customer Customer Number KUNNR
HouseBank Short Key for a House Bank
HouseBankAccount ID for Account Details
CashPlanningGroup Planning Group FDGRP
PlanningLevel Planning Level FDLEV
ProfitCenter Profit Center PRCTR
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerCompany Company ID of Trading Partner RCOMP
Supplier Account Number of Supplier
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
SourceCompanyCode Company Code
Master Data Relations Join Conditions
Bank Key
  • ?
  • Client
  • Bank Key
  • C_LIQUIDITYFORECASTDETAILSQ.[column in domain "BANKS"] == BNKA.BANKS
  • C_LIQUIDITYFORECASTDETAILSQ.MANDT == BNKA.MANDT
  • C_LIQUIDITYFORECASTDETAILSQ.BANK == BNKA.BANKL
Bank Account Type ID
  • Bank Account Type ID
  • Client
Controlling Area
  • Client
  • Controlling Area
  • C_LIQUIDITYFORECASTDETAILSQ.MANDT == TKA01.MANDT
  • C_LIQUIDITYFORECASTDETAILSQ.CONTROLLINGAREA == TKA01.KOKRS
Project
  • Client
  • Project (internal)
  • C_LIQUIDITYFORECASTDETAILSQ.MANDT == PROJ.MANDT
  • C_LIQUIDITYFORECASTDETAILSQ.PROJECTINTERNALID == PROJ.PSPNR
Responsible cost center
  • ?
  • Client
  • ?
  • Responsible Cost Center
  • C_LIQUIDITYFORECASTDETAILSQ.[column in domain "DATBI"] == CSKS.DATBI
  • C_LIQUIDITYFORECASTDETAILSQ.MANDT == CSKS.MANDT
  • C_LIQUIDITYFORECASTDETAILSQ.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_LIQUIDITYFORECASTDETAILSQ.RESPONSIBLECOSTCENTER == CSKS.KOSTL