I_CASHPOOLHIERARCHY

CDS View

cds view for display cash pool hierarchy

I_CASHPOOLHIERARCHY is a CDS View in S/4HANA. cds view for display cash pool hierarchy. It contains 13 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 13 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CashPoolHierarchy view from CONSUMPTION c view for display cash pool hierarchy
P_Fa_Bkh view union_all BASIC Bank Account Hierarchy for Flow Analyzer

Fields (13)

KeyField CDS FieldsUsed in Views
BankAccount BankAccount 1
BankAccountType BankAccountType 1
CompanyCode CompanyCode 1
Currency Currency 1
HierarchyLevel HierarchyLevel 1
LeadingCashPoolID LeadingCashPoolID 1
MaxTargetAmount MaxTargetAmount 1
MaxTransferAmount MaxTransferAmount 1
MinTargetAmount MinTargetAmount 1
MinTransferAmount MinTransferAmount 1
Note Note 1
ParentBankAccount ParentBankAccount 1
ParticipantCashPoolID ParticipantCashPoolID 1 
@AbapCatalog: {
    sqlViewName: 'ICPHIER',
    compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'cds view for display cash pool hierarchy'
@Analytics: { dataCategory: #CUBE, dataExtraction.enabled: true } //or #CUBE or #NONE

//@Analytics.query: true

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
define view I_CashPoolHierarchy
  as select from P_CASHPOOLHIERARCHY 
(
  P_SAPClient : $session.client
) 
as ICPHIER
association[1..1] to I_Currency as _Currency on $projection.Currency = _Currency.Currency 
{
  BankAccount,
  ParentBankAccount,
  HierarchyLevel,
  ParticipantCashPoolID,
  LeadingCashPoolID,
  @Semantics.currencyCode: true
  @ObjectModel.foreignKey.association: '_Currency'
  Currency,
  @Semantics.amount.currencyCode: 'Currency'
  ICPHIER.MaxTargetAmount as MaxTargetAmount,
  @Semantics.amount.currencyCode: 'Currency' 
  ICPHIER.MinTargetAmount,
  @Semantics.amount.currencyCode: 'Currency'
  ICPHIER.MinTransferAmount,
  @Semantics.amount.currencyCode: 'Currency'
  ICPHIER.MaxTransferAmount, 
  ICPHIER.Note,
  ICPHIER.CompanyCode,
  ICPHIER.BankAccountType,  
  _Currency
            }
/*+[internal] {
"BASEINFO":
{
"FROM":
[],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More