P_FORECASTBALANCECASHFLOW

DDL: P_FORECASTBALANCECASHFLOW SQL: PFCCASHFLOW Type: view COMPOSITE

Forecast Balance Cash Flow

P_FORECASTBALANCECASHFLOW is a Composite CDS View that provides data about "Forecast Balance Cash Flow" in SAP S/4HANA. It reads from 2 data sources (I_CashFlow, P_PlngLvlInCshPoolBalPrfl) and exposes 15 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_CashFlow Flow from
P_PlngLvlInCshPoolBalPrfl P_PlngLvlInCshPoolBalPrfl inner

Parameters (2)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_CashPoolBalCalcPrfl prof_name

Annotations (10)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PFCCASHFLOW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Forecast Balance Cash Flow view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem I_CashFlow OriginSystem
KEY OriginApplication I_CashFlow OriginApplication
KEY OriginDocument I_CashFlow OriginDocument
KEY OriginTransaction I_CashFlow OriginTransaction
KEY OriginTransactionQualifier I_CashFlow OriginTransactionQualifier
KEY CashFlow I_CashFlow CashFlow
KEY ValidFrom I_CashFlow ValidFrom
KEY ValidTo I_CashFlow ValidTo
CompanyCode I_CashFlow CompanyCode
TransactionCurrency I_CashFlow TransactionCurrency
PlanningLevel I_CashFlow PlanningLevel
TransactionDate I_CashFlow TransactionDate
CashFlowID I_CashFlow CashFlowID
CertaintyLevel I_CashFlow CertaintyLevel
AmountInTransactionCurrency I_CashFlow AmountInTransactionCurrency 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PFCCASHFLOW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType:  #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
--@EndUserText.label: 'Forecast Balance Cash Flow'
define view P_FORECASTBALANCECASHFLOW 
with parameters 
        P_KeyDate           : vdm_v_key_date,
        P_CashPoolBalCalcPrfl : prof_name
        
as select from I_CashFlow as Flow 
   inner join   P_PlngLvlInCshPoolBalPrfl( P_CashPoolBalCalcPrfl: $parameters.P_CashPoolBalCalcPrfl ) as profile on  profile.PlanningLevel       = Flow.PlanningLevel

{
  key Flow.OriginSystem,
  key Flow.OriginApplication,
  key Flow.OriginDocument,
  key Flow.OriginTransaction,
  key Flow.OriginTransactionQualifier,                                                                                                                   
  key Flow.CashFlow,
  key Flow.ValidFrom,
  key Flow.ValidTo,
  
    Flow.CompanyCode,
    Flow.TransactionCurrency, 
    Flow.PlanningLevel, 
    Flow.TransactionDate,
    Flow.CashFlowID,
    Flow.CertaintyLevel,
    Flow.AmountInTransactionCurrency  as AmountInTransactionCurrency 
}
where Flow.IsValid = 'X'
  and Flow.ExpirationDate >= $session.system_date
  and Flow.TransactionDate > :P_KeyDate
  and Flow.TransactionDate <= DATS_ADD_DAYS(:P_KeyDate, 90, 'FAIL')
  and Flow.CashReleaseStatus  = ''
  and Flow.ValidFrom <= TSTMP_CURRENT_UTCTIMESTAMP() and Flow.ValidTo >= TSTMP_CURRENT_UTCTIMESTAMP() 

 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASHFLOW",
"P_PLNGLVLINCSHPOOLBALPRFL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More