I_Liquidityforecastdetailscube

Liquidity Forecast Details Cube | view: ILIQFOREDETAILSC | TRAN | Extraction: Full only | Component: SAP Cash Management
Column Name Description
Column Name Description
💲 Currency (TransactionCurrency):
AmountInTransactionCurrency null
💲 null (DisplayCurrency):
AmountInDisplayCurrency null
Column Name Description
Column Name Description
CalendarDay Transaction Date
Column Name Description
CashFlowDirection Cash Flow Direction Show values
BankAccountStatus Bank Account Status Show values
CertaintyLevel Certainty Level Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
LiquidityItem Liquidity Item FLQPOS
BankAccountInternalID Bank Account Technical ID NUM10
BankAccount Bank Account Number FCLM_BAM_ACC_NUM
BankAccountDescription Account Description TEXT60
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 HBKID
HouseBankAccount ID for Account Details HKTID
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 LIFNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
SourceCompanyCode Company Code BUKRS
DomainValueName Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Bank Key
  • Bank Key
  • Client
  • ?
  • I_LIQUIDITYFORECASTDETAILSCUBE.BANK == BNKA.BANKL
  • I_LIQUIDITYFORECASTDETAILSCUBE.MANDT == BNKA.MANDT
  • I_LIQUIDITYFORECASTDETAILSCUBE.[column in domain "BANKS"] == BNKA.BANKS
Bank Account Type ID
  • Bank Account Type ID
  • Client
Controlling Area
  • Controlling Area
  • Client
  • I_LIQUIDITYFORECASTDETAILSCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_LIQUIDITYFORECASTDETAILSCUBE.MANDT == TKA01.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_LIQUIDITYFORECASTDETAILSCUBE.COUNTRY == T005.LAND1
  • I_LIQUIDITYFORECASTDETAILSCUBE.MANDT == T005.MANDT
Project
  • Project (internal)
  • Client
  • I_LIQUIDITYFORECASTDETAILSCUBE.PROJECTINTERNALID == PROJ.PSPNR
  • I_LIQUIDITYFORECASTDETAILSCUBE.MANDT == PROJ.MANDT
Responsible cost center
  • ?
  • ?
  • Client
  • Responsible Cost Center
  • I_LIQUIDITYFORECASTDETAILSCUBE.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_LIQUIDITYFORECASTDETAILSCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_LIQUIDITYFORECASTDETAILSCUBE.MANDT == CSKS.MANDT
  • I_LIQUIDITYFORECASTDETAILSCUBE.RESPONSIBLECOSTCENTER == CSKS.KOSTL