P_CashLiquidityFlow

DDL: P_CASHLIQUIDITYFLOW SQL: PCSHLQDYFLW Type: view BASIC

Cash Liquidity Flow for WCI

P_CashLiquidityFlow is a Basic CDS View that provides data about "Cash Liquidity Flow for WCI" in SAP S/4HANA. It reads from 2 data sources (I_CashPositionFlow, P_LdngLdgrGlobCrcyTranslation) and exposes 16 fields with key fields CashFlowID, ValidFrom.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_CashPositionFlow flow from
P_LdngLdgrGlobCrcyTranslation globalCurrency inner

Annotations (10)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PCSHLQDYFLW view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Cash Liquidity Flow for WCI view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CashFlowID I_CashPositionFlow CashFlowID
KEY ValidFrom I_CashPositionFlow ValidFrom
CompanyCode I_CashPositionFlow CompanyCode
TransactionDate I_CashPositionFlow TransactionDate
PostingDate
CertaintyLevel I_CashPositionFlow CertaintyLevel
TransactionCurrency I_CashPositionFlow TransactionCurrency
AmountInTransactionCurrency I_CashPositionFlow AmountInTransactionCurrency
CompanyCodeCurrency I_CashPositionFlow CompanyCodeCurrency
AmountInCompanyCodeCurrency I_CashPositionFlow AmountInCompanyCodeCurrency
GlobalCurrency P_LdngLdgrGlobCrcyTranslation GlobalCurrency
ExchangeRateType P_LdngLdgrGlobCrcyTranslation ExchangeRateType
BankAccountInternalID I_CashPositionFlow BankAccountInternalID
ExpirationDate
_CompanyCode I_CashPositionFlow _CompanyCode
_BankAccount I_CashPositionFlow _BankAccount 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.sqlViewName: 'PCSHLQDYFLW'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Cash Liquidity Flow for WCI'
define view P_CashLiquidityFlow
  as select from I_CashPositionFlow            as flow
    inner join   P_LdngLdgrGlobCrcyTranslation as globalCurrency on flow.CompanyCode = globalCurrency.CompanyCode
{
  key flow.CashFlowID,
  key flow.ValidFrom,

      @ObjectModel.foreignKey.association: '_CompanyCode'
      flow.CompanyCode,
      flow.TransactionDate,
      case when flow.PostingDate is initial then flow.TransactionDate else flow.PostingDate end as PostingDate,
      flow.CertaintyLevel,
      @Semantics.currencyCode: true
      flow.TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      flow.AmountInTransactionCurrency,
      @Semantics.currencyCode: true
      flow.CompanyCodeCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      flow.AmountInCompanyCodeCurrency,
      @Semantics.currencyCode: true
      globalCurrency.GlobalCurrency                                                             as GlobalCurrency,
      globalCurrency.ExchangeRateType                                                           as ExchangeRateType,

      @ObjectModel.foreignKey.association: '_BankAccount'
      flow.BankAccountInternalID,

      cast( flow.ExpirationDate as fqm_due_date preserving type )                               as ExpirationDate,

      flow._CompanyCode,
      flow._BankAccount
}
where
  flow.IsValid = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASHPOSITIONFLOW",
"P_LDNGLDGRGLOBCRCYTRANSLATION"
],
"ASSOCIATED":
[
"I_BANKACCOUNT",
"I_COMPANYCODE"
],
"BASE":
[
"I_CASHPOSITIONFLOW"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More