P_CashPositionCashFlow

DDL: P_CASHPOSITIONCASHFLOW SQL: PCPCASHFLOW Type: view COMPOSITE

Cash Position Cash Flow

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

2 data source(s) 16 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 PCPCASHFLOW 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 Cash Position Cash Flow view

Fields (16)

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
HouseBank I_CashFlow HouseBank
HouseBankAccount I_CashFlow HouseBankAccount
BankAccountInternalID I_CashFlow BankAccountInternalID
BankAccountCurrency I_CashFlow BankAccountCurrency
TransactionCurrency I_CashFlow TransactionCurrency
PlanningLevel I_CashFlow PlanningLevel
AmountInTransactionCurrency I_CashFlow AmountInTransactionCurrency 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PCPCASHFLOW'
@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: 'Cash Position Cash Flow'
define view P_CashPositionCashFlow 
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.HouseBank,
     Flow.HouseBankAccount,
     Flow.BankAccountInternalID,   
     Flow.BankAccountCurrency,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
     Flow.TransactionCurrency,
     Flow.PlanningLevel,
     Flow.AmountInTransactionCurrency  as AmountInTransactionCurrency   
}
where   IsValid = 'X'
    and ExpirationDate >= $session.system_date
    and TransactionDate <= :P_KeyDate
--    and ( CertaintyLevel = 'ACTUAL' or CertaintyLevel = 'INTRAM' or _recn.CshRecnclnID is null )
    and CashReleaseStatus  = ''
    and  ( ValidFrom <= TSTMP_CURRENT_UTCTIMESTAMP() and ValidTo >= TSTMP_CURRENT_UTCTIMESTAMP() )
--    and  ( ValidFrom <= UTCL_CURRENT() and ValidTo >= UTCL_CURRENT() )

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

Learn More